Database system that provides for history-enabled tables

  • US 20070130226A1
  • Filed: 12/01/2005
  • Published: 06/07/2007
  • Est. Priority Date: 12/01/2005
  • Status: Active Grant
First Claim
Patent Images

1. A history-enabled table in a relational database system, the history-enabled table comprising:

  • a set of other columns;

    a start time column;

    a period column;

    a set of current rows, a current row containing current values of the fields that belong to the set of other columns and a start time field belonging to the start time column, the value of the start time field indicating the time at which the most recent change in the current values occurred; and

    a set of history rows, the history rows having copied fields belonging to the set of other columns or a subset thereof and a row period field belonging to the period column, the values of the copied fields being copied from a current row prior to deletion or updating of the current row and the row period field'"'"'s value being set to indicate the period between the start time value of the copied current row and the time of the update or deletion of the copied current row.

View all claims
    ×
    ×

    Thank you for your feedback

    ×
    ×