Transaction Log - Tables

Tables

These tables are maintained in memory, and can be efficiently reconstructed (if not exactly, to an equivalent state) from the log and the database:

  • Transaction Table: The table contains one entry for each active transaction. This includes Transaction ID and lastLSN, where lastLSN describes the LSN of the most recent log record for the transaction.
  • Dirty Page Table: The table contains one entry for each dirty page that hasn't been written to disk. The entry contains recLSN, where recLSN is the LSN of the first log record that caused the page to be dirty.
  • Transaction Log: A DBMS uses a transaction log to keep track of all transactions that updates the database. The information stored in this log is used by DBMS for a recovery requirement triggered by 'Roll Back' statement.
Database management systems
  • Database models
  • Database normalization
  • Database storage
  • Distributed DBMS
  • Federated database system
  • Referential integrity
  • Relational algebra
  • Relational calculus
  • Relational database
  • Relational DBMS
  • Relational model
  • Object-relational database
  • Transaction processing
Concepts
  • Database
  • ACID
  • CRUD
  • Null
  • Candidate key
  • Foreign key
  • Primary key
  • Superkey
  • Surrogate key
  • Armstrong's axioms
  • NoSQL
Objects
  • Relation
    • table
    • column
    • row
  • View
  • Transaction
  • Log
  • Trigger
  • Index
  • Stored procedure
  • Cursor
  • Partition
Components
  • Concurrency control
  • Data dictionary
  • JDBC
  • XQJ
  • ODBC
  • Query language
  • Query optimizer
  • Query plan
Functions
  • Administration and automation
  • Query optimization
  • Replication
Database products
Object-oriented
comparison
Relational
comparison
Document-oriented
NewSQL

Read more about this topic:  Transaction Log

Famous quotes containing the word tables:

    “Hast thou named all the birds without a gun?
    Loved the wood rose, and left it on its stalk?
    At rich men’s tables eaten bread and pulse?
    Unarmed, faced danger with a heart of trust?”
    —Ralph Waldo Emerson (1803–1882)

    “Eddie Felson: Church of the Good Hustler.
    Charlie: Looks more like a morgue to me. Those tables are the slabs they lay the stiffs on.
    Eddie Felson: I’ll be alive when I get out, Charlie.”
    —Sydney Carroll, U.S. screenwriter, and Robert Rossen. Eddie Felson (Paul Newman)

    “All my life I have said, “Whatever happens there will always be tables and chairs”—and what a mistake.”
    —Elizabeth Bowen (1899–1973)