Cover Image

Managing time in relational databases : how to design, update and query temporal data /

Show other versions (2)

Managing time in relational databases shows how to make the rich information content of bi-temporal data available to business users, while simplifying the design, maintenance and retrieval of that data. Metadata declarations eliminate the need to directly model temporal data. Temporal data maintena...

Full description

Bibliographic Details
Main Author: Johnston, Tom, 1944-
Corporate Author: ScienceDirect (Online service)
Other Authors: Weis, Randall
Format: eBook
Language:English
Published: Amsterdam ; Boston : Elsevier/Morgan Kaufmann, ©2010.
Subjects:
Temporal databases.
Relational databases.
Database management.
Querying (Computer science)
Bases de données spatio-temporelles.
Bases de données relationnelles.
Bases de données > Gestion.
Bases de données > Interrogation.
online searching.
COMPUTERS > Data Processing.
Database management
Relational databases
Temporal databases
Electronic books.
Online Access:Connect to the full text of this electronic book
Table of Contents:
  • An introduction to temporal data management. A brief history of temporal data management
  • A taxonomy of bi-temporal data management methods
  • An introduction to asseted versioning. The origins of asserted versioning : computer science research
  • The origins of asserted versioning : IT best practices
  • The core concepts of asserted versioning
  • Diagrams and other notations
  • The basic scenario
  • Designing, maintaining and querying asserted version databases. Designing and generating asserted versioning databases
  • An introduction to temporal transactions
  • Temporal transactions on single tables
  • Temporal transactions on multiple tables
  • Deferred assertions and other pipeline datasets
  • Re-presenting internalized pipeline datasets
  • Allen relationship and other queries
  • Optimizing asserted versioning databases
  • Conclusion.