realtime- transaction processing system
TRANSCRIPT
![Page 1: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/1.jpg)
SEMINAR ON
REAL TIME TRANSACTION
PROCESSING SYSTEM
Presented by
Kunal Mahurkar(ME)Computer Engineering,
AISSMSCOE,PUNE
Under Guidance of
Mrs.Shaikh (Professor)
(ME)Computer Engineering,
AISSMSCOE,PUNE
![Page 2: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/2.jpg)
TRANSACTION General Meaning
Instance of examples,
05/02/2023 2High Performance Database, (ME)Computer Dept.,
AISSMSCOE, Pune
Real Time Transaction Processing System
![Page 3: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/3.jpg)
05/02/2023 3
TRANSACTION
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Real Time Transaction Processing System
![Page 4: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/4.jpg)
05/02/2023 4
TRANSACTION
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Real Time Transaction Processing System
![Page 5: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/5.jpg)
05/02/2023 5
TRANSACTION PROCESSING
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Information Sytem
Store data
Retrieve data
Real Time Transaction Processing System
![Page 6: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/6.jpg)
05/02/2023 6
TRANSACTION PROCESSING FEATURES
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Measured by no. of Tx they can process in given time
Real Time Transaction Processing System
![Page 7: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/7.jpg)
05/02/2023 7
TRANSACTION PROCESSING FEATURES
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Real Time Transaction Processing System
![Page 8: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/8.jpg)
05/02/2023 8
TRANSACTION PROCESSING FEATURES
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
No Corruption of data.
Example. 2 operators cannot sell same seat on an aeroplane.
Real Time Transaction Processing System
![Page 9: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/9.jpg)
05/02/2023 9
TRANSACTION PROCESSING FEATURES
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
![Page 10: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/10.jpg)
05/02/2023 10
TRANSACTION PROCESSING FEATURES
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
MODULAR GROWTH
Growth at incremental cost rather than requires a complete replacement
Must be able to add, update or replace h/w or s/w without shutting down system
Real Time Transaction Processing System
![Page 11: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/11.jpg)
05/02/2023 11
TYPES OF TRANSACTION PROCESSING
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Real Time Transaction Processing System
![Page 12: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/12.jpg)
05/02/2023 12
REAL TIME TRANSACTION PROCESSING SYSTEM
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
When deadlines are included CORRECTNESS of an EXECUTION is no longer solely an issue of d/b CONSISTENCY.
Real Time Transaction Processing System
![Page 13: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/13.jpg)
05/02/2023 13
DEADLINES CHARACTERIZATION HARD DEADLINE
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
=
Real Time Transaction Processing System
![Page 14: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/14.jpg)
05/02/2023 14
DEADLINES CHARACTERIZATION
FIRM DEADLINE
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Real Time Transaction Processing System
![Page 15: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/15.jpg)
05/02/2023 15
DEADLINES CHARACTERIZATION SOFT DEADLINE
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
=
Real Time Transaction Processing System
![Page 16: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/16.jpg)
05/02/2023 16
Waitt1
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Will cause t1
To missdeadline
Pre-empt t2
T1 will complete its
task BUT DON’T
FORGET t2
Real Time Transaction Processing System
![Page 17: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/17.jpg)
05/02/2023 17High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
Real Time Transaction Processing System
![Page 18: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/18.jpg)
05/02/2023High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
18
Main memorydatabase
Server process
![Page 19: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/19.jpg)
05/02/2023High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
19
ISSUE IN REAL TIME PROCESSING SYSTEM
![Page 20: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/20.jpg)
05/02/2023 20
REFERENCES Database System Concepts 6th edition _
Henry F Korth Abraham Silberschatz, S Sudharshan
http://www.i95dev.com/is-real-time-processing-better-than-batch-processing/
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune
![Page 21: realtime- transaction Processing System](https://reader035.vdocuments.us/reader035/viewer/2022062316/58ef6e431a28ab69088b465f/html5/thumbnails/21.jpg)
05/02/2023 21
ANY QUESTIONS
THANK YOU..
High Performance Database,(ME)Computer Dept.,AISSMSCOE,Pune