Transaction Log - Anatomy of A General Database Log

Anatomy of A General Database Log

A database log record is made up of:

  • Log Sequence Number: A unique id for a log record. With LSNs, logs can be recovered in constant time. Most logs' LSNs are assigned in monotonically increasing order, which is useful in recovery algorithms, like ARIES.
  • Prev LSN: A link to the last log record. This implies database logs are constructed in linked list form.
  • Transaction ID number: A reference to the database transaction generating the log record.
  • Type: Describes the type of database log record.
  • information about the actual changes that triggered the log record to be written

Read more about this topic:  Transaction Log

Famous quotes containing the words anatomy, general and/or log:

    “I love to see, when leaves depart,
    The clear anatomy arrive,”
    —Roy Campbell (1902–1957)

    “The general so likes your music, that he desires you for love’s sake to make no more noise with it.”
    —William Shakespeare (1564–1616)

    “This state is full of these log cabin Abe Lincolns with price tags on ‘em. The louder he yells, the higher his price.”
    —Robert Rossen (1908–1966)