Back to School Savings: Save up to 30% on print books and eBooks. No promo code needed.

Back to School Savings: Save up to 30%

Managing Time in Relational Databases

How to Design, Update and Query Temporal Data

1st Edition - July 13, 2010

Authors: Tom Johnston, Randall Weis

Hardback ISBN:
9 7 8 - 0 - 1 2 - 3 7 5 0 4 1 - 9
eBook ISBN:
9 7 8 - 0 - 0 8 - 0 9 6 3 3 7 - 2

Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own framework for… Read more

Image - Managing Time in Relational Databases

Purchase Options

Save 50% on book bundles

Immediately download your ebook while waiting for your print delivery. No promo code is needed.

Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own framework for managing temporal data. It discusses the management of uni-temporal and bi-temporal data in relational databases, so that they can be seamlessly accessed together with current data; the encapsulation of temporal data structures and processes; ways to implement temporal data management as an enterprise solution; and the internalization of pipeline datasets.

The book is organized into three parts. Part 1 traces the history of temporal data management and presents a taxonomy of bi-temporal data management methods. Part 2 provides an introduction to Asserted Versioning, covering the origins of Asserted Versioning; core concepts of Asserted Versioning; the schema common to all asserted version tables, as well as the various diagrams and notations used in the rest of the book; and how the basic scenario works when the target of that activity is an asserted version table. Part 3 deals with designing, maintaining, and querying asserted version databases. It discusses the design of Asserted Versioning databases; temporal transactions; deferred assertions and other pipeline datasets; Allen relationships; and optimizing Asserted Versioning databases.