Normal Execution of an Xact
{"Image DocumentName": "Normal Execution of an Xact", "Image ImageDescription": "Assume: Strict 2PL concurrency control. STEAL, NO-FORCE buffer management, with WAL. Disk writes are atomic (i.e., all-or-nothing) Transaction is a series of reads & writes, followed by commit or abort. Update TransTable on transaction start/end. For each update operation: create log record with LSN l = ++MaxLSN and. prevLSN = TransTable[XID].lastLSN; update TransTable[XID].lastLSN = l. if modified page NOT in DirtyPageTable, then add it with recLSN = l. When buffer manager replaces a dirty page, remove its entry from the DPT.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}