The Experts below are selected from a list of 3 Experts worldwide ranked by ideXlab platform
Randall Weis - One of the best experts on this subject based on the ideXlab platform.
-
Designing and Generating Asserted Versioning Databases
Managing Time in Relational Databases, 2020Co-Authors: Tom Johnston, Randall WeisAbstract: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 - One of the best experts on this subject based on the ideXlab platform.
-
Designing and Generating Asserted Versioning Databases
Managing Time in Relational Databases, 2020Co-Authors: Tom Johnston, Randall WeisAbstract: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.
