Patent · US Active

Management of temporal data by means of a canonical schema

US8713073B2 · kind B2 · utility

3Cited by
7References
22Claims
0Family size

Assignee

Inventors

Key dates

Filing dateJun 21, 2012
Grant dateApr 29, 2014
Priority date
Expiry dateJun 21, 2032

Classification

  • Technology area (CPC G)Physics
  • CPC primaryG06F16/219
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

Computer programs embodied in computer-readable media that can use canonical schemas to persist data from non-temporal tables, effective-time tables, assertion-time tables, and bitemporal tables, and that can enforce temporal integrity constraints on those tables, are provided. In one embodiment, the canonical schemas are used by database tables. In another embodiment, they are used by the physical files which persist data from those tables. Temporal metadata is used to express temporal requirements. Thus, uni-temporal, bitemporal, and temporally-enabled non-temporal tables can be generated without altering existing data models or designing temporal features into new data models. Support is also provided for managing temporal data that exists in future assertion time, and for using episodes to enforce temporal referential integrity.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.