Patent ID: 8219522
Filing Date: 2012-07-10
Classification: G06F

Abstract:
1. A computer program embodied in a computer-readable storage medium for managing temporal data, the computer program comprising: logic adapted to store temporal data in at least one temporal table, the at least one temporal table being stored in a temporal database, each temporal table using a single canonical schema that includes, in any order: logic adapted to store additional data in the at least one temporal table, the additional data comprising at least one business data column such that each business data column in each row in the temporal table contains data that describes the state of the object represented by the row in which each business data column occurs; and logic adapted to create temporal tables, the logic adapted to create temporal tables including, in any order: whereby a cost to express temporal data requirements in data models is reduced; and whereby no changes are required to the data models of databases some or all of whose tables are converted into temporal tables.