Managing Time in Relational Databases

Managing Time in Relational Databases
Author :
Publisher : Morgan Kaufmann
Total Pages : 502
Release :
ISBN-10 : 9780080963372
ISBN-13 : 0080963374
Rating : 4/5 (374 Downloads)

Book Synopsis Managing Time in Relational Databases by : Tom Johnston

Download or read book Managing Time in Relational Databases written by Tom Johnston and published by Morgan Kaufmann. This book was released on 2010-08-19 with total page 502 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.


Managing Time in Relational Databases Related Books

Managing Time in Relational Databases
Language: en
Pages: 502
Authors: Tom Johnston
Categories: Computers
Type: BOOK - Published: 2010-08-19 - Publisher: Morgan Kaufmann

DOWNLOAD EBOOK

Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own
Time and Relational Theory
Language: en
Pages: 579
Authors: C.J. Date
Categories: Computers
Type: BOOK - Published: 2014-08-13 - Publisher: Morgan Kaufmann

DOWNLOAD EBOOK

Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating h
Temporal Data & the Relational Model
Language: en
Pages: 449
Authors: C.J. Date
Categories: Computers
Type: BOOK - Published: 2003 - Publisher: Morgan Kaufmann

DOWNLOAD EBOOK

A review of relational concepts -- An overview of Tutorial D -- Time and the database -- What is the problem? -- Intervals -- Operators on intervals -- The EXPA
Information Modeling and Relational Databases
Language: en
Pages: 1086
Authors: Terry Halpin
Categories: Mathematics
Type: BOOK - Published: 2024-07-22 - Publisher: Elsevier

DOWNLOAD EBOOK

Information Modeling and Relational Databases, Third Edition, provides an introduction to ORM (Object-Role Modeling) and much more. In fact, it is the only book
Bitemporal Data
Language: en
Pages: 400
Authors: Tom Johnston
Categories: Computers
Type: BOOK - Published: 2014-08-19 - Publisher: Newnes

DOWNLOAD EBOOK

Bitemporal data has always been important. But it was not until 2011 that the ISO released a SQL standard that supported it. Currently, among major DBMS vendors