1 / 9

DBST 652 – Lecture 8 – Part 1

DBST 652 – Lecture 8 – Part 1. Transactions. Transaction Processing. Logical units of database processing Examples - banking, reservations, stock markets ATM - transfer $100 from savings to checking. Transaction Processing.

nero
Download Presentation

DBST 652 – Lecture 8 – Part 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBST 652 – Lecture 8 – Part 1 • Transactions

  2. Transaction Processing • Logical units of database processing • Examples - banking, reservations, stock markets • ATM - transfer $100 from savings to checking

  3. Transaction Processing • Multiuser systems - job A gets some time, then job B, then job A and so on. • Could also have parallel processing. Job A runs while job B runs. • See p. 611 - figure 17.1

  4. Transaction Processing • Transaction - logical unit of work • Could involve inserts, updates, deletes • see steps for reads and writes on p. 555

  5. Transaction Processing • Problems with concurrency - if not controlled: • 1. Lost update • 2. Dirty read (temporary update) • 3. Incorrect summary

  6. Transaction Processing • Transaction - either all completes or no change to the database remains • COMMIT or ROLLBACK

  7. Transaction Processing • Easier said than done - what could keep from completing transaction? • Computer crash • system error • local errors • deadlock • disk failure • p. 616 has list

  8. Transaction Processing • Need to keep track of transactions so can recover to a consistent point in time • Tracks begin, read/write/delete, end, commit, rollback • look at diagram on p. 618

  9. Transaction Processing • A log keeps track of transactions • Has before and after data • Used to recover database See Part 1b next

More Related