Bitemporal Table - Explore the Science & Experts | ideXlab

Scan Science and Technology

Contact Leading Edge Experts & Companies

Bitemporal Table

The Experts below are selected from a list of 3 Experts worldwide ranked by ideXlab platform

Randall Weis – 1st expert on this subject based on the ideXlab platform

  • Designing and Generating Asserted Versioning Databases
    Managing Time in Relational Databases, 2020
    Co-Authors: Tom Johnston, Randall Weis

    Abstract:

    This chapter discusses how Asserted Versioning databases can be designed and generated. An Asserted Versioning database is one that contains at least one asserted version Table. Asserted Versioning databases are generated from the combination of a conventional logical data model and a set of metadata entries. Asserted Versioning simplifies the management of temporal databases by providing maintenance encapsulation, query encapsulation, and design encapsulation. The chapter discusses how temporal design requirements are expressed in metadata associated with a conventional logical data model, how this metadata is used to convert nontemporal Table schemas into Bitemporal Table schemas, and also how it is used to generate the code, such as stored procedures, that enforce both temporal entity integrity and temporal referential integrity on those Tables. If ERwin is used as the data modeling tool, then a set of Erwin macros that have been written will do the conversion automatically. Otherwise, the conversion will be a manual process.

Tom Johnston – 2nd expert on this subject based on the ideXlab platform

  • Designing and Generating Asserted Versioning Databases
    Managing Time in Relational Databases, 2020
    Co-Authors: Tom Johnston, Randall Weis

    Abstract:

    This chapter discusses how Asserted Versioning databases can be designed and generated. An Asserted Versioning database is one that contains at least one asserted version Table. Asserted Versioning databases are generated from the combination of a conventional logical data model and a set of metadata entries. Asserted Versioning simplifies the management of temporal databases by providing maintenance encapsulation, query encapsulation, and design encapsulation. The chapter discusses how temporal design requirements are expressed in metadata associated with a conventional logical data model, how this metadata is used to convert nontemporal Table schemas into Bitemporal Table schemas, and also how it is used to generate the code, such as stored procedures, that enforce both temporal entity integrity and temporal referential integrity on those Tables. If ERwin is used as the data modeling tool, then a set of Erwin macros that have been written will do the conversion automatically. Otherwise, the conversion will be a manual process.