Managing Time in Relational Databases

How to Design, Update and Query Temporal Data

Nonfiction, Computers, Database Management, General Computing
Cover of the book Managing Time in Relational Databases by Tom Johnston, Randall Weis, Elsevier Science
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Tom Johnston, Randall Weis ISBN: 9780080963372
Publisher: Elsevier Science Publication: August 19, 2010
Imprint: Morgan Kaufmann Language: English
Author: Tom Johnston, Randall Weis
ISBN: 9780080963372
Publisher: Elsevier Science
Publication: August 19, 2010
Imprint: Morgan Kaufmann
Language: English

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.

  • Integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development.
  • Provides a true practical guide to the different possible methods of time-oriented databases with techniques of using existing funtionality to solve real world problems within an enterprise data architecture environment.
  • Written by IT professionals for IT professionals, this book employs a heavily example-driven approach which reinforces learning by showing the results of puting the techniques discussed into practice.
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Elsevier Science

Cover of the book Keys to Running Successful Research Projects by Tom Johnston, Randall Weis
Cover of the book Advances in Organometallic Chemistry by Tom Johnston, Randall Weis
Cover of the book Guide to Food Safety and Quality During Transportation by Tom Johnston, Randall Weis
Cover of the book Major Process Equipment Maintenance and Repair by Tom Johnston, Randall Weis
Cover of the book Cognitive Computing: Theory and Applications by Tom Johnston, Randall Weis
Cover of the book Discrimination Testing in Sensory Science by Tom Johnston, Randall Weis
Cover of the book Colorants for Non-Textile Applications by Tom Johnston, Randall Weis
Cover of the book Multidimensional Systems Signal Processing Algorithms and Application Techniques by Tom Johnston, Randall Weis
Cover of the book Advances in the Study of Behavior by Tom Johnston, Randall Weis
Cover of the book Nanostructured Materials by Tom Johnston, Randall Weis
Cover of the book Repetitive Project Scheduling: Theory and Methods by Tom Johnston, Randall Weis
Cover of the book Perennial Grasses for Bioenergy and Bioproducts by Tom Johnston, Randall Weis
Cover of the book Advances in Carbohydrate Chemistry and Biochemistry by Tom Johnston, Randall Weis
Cover of the book Nitride Semiconductor Light-Emitting Diodes (LEDs) by Tom Johnston, Randall Weis
Cover of the book Color Trends and Selection for Product Design by Tom Johnston, Randall Weis
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy