Managing Time in Relational Databases

  • Author : Tom Johnston
  • Publsiher : Morgan Kaufmann
  • Release : 19 August 2010
  • ISBN : 0080963374
  • Page : 512 pages
  • Rating : 4/5 from 21 voters

Download or read online book entitled Managing Time in Relational Databases written by Tom Johnston and published by Morgan Kaufmann. This book was released on 19 August 2010 with total page 512 pages. Available in PDF, EPUB and Kindle. Get best books that you want by click Get Book Button and Read as many books as you like. 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

Managing Time in Relational Databases
Author: Tom Johnston,Randall Weis
Publisher: Morgan Kaufmann
Relase: 2010-08-19
ISBN: 0080963374
GET BOOK

Bitemporal Data

Bitemporal Data
Author: Tom Johnston
Publisher: Newnes
Relase: 2014-08-19
ISBN: 9780124080553
GET BOOK

Time and Relational Theory

Time and Relational Theory
Author: C. J. Date,Nikos Lorentzos,Hugh Darwen
Publisher: Morgan Kaufmann
Relase: 2014-07-16
ISBN: 0128006315
GET BOOK

Database Modeling and Design

Database Modeling and Design
Author: Toby J. Teorey,Sam S. Lightstone,Tom Nadeau,H.V. Jagadish
Publisher: Elsevier
Relase: 2011-02-10
ISBN: 9780123820211
GET BOOK

Joe Celko s SQL for Smarties

Joe Celko s SQL for Smarties
Author: Joe Celko
Publisher: Elsevier
Relase: 2010-11-22
ISBN: 0123820235
GET BOOK

Fundamentals of Relational Database Management Systems

Fundamentals of Relational Database Management Systems
Author: S. Sumathi,S. Esakkirajan
Publisher: Springer
Relase: 2007-03-20
ISBN: 9783540483991
GET BOOK

Recent Advances in Information and Communication Technology 2015

Recent Advances in Information and Communication Technology 2015
Author: Herwig Unger,Phayung Meesad,Sirapat Boonkrong
Publisher: Springer
Relase: 2015-06-14
ISBN: 9783319190242
GET BOOK

Applications of Computational Intelligence in Biomedical Technology

Applications of Computational Intelligence in Biomedical Technology
Author: Radim Bris,Jaroslav Majernik,Krzysztof Pancerz,Elena Zaitseva
Publisher: Springer
Relase: 2015-06-25
ISBN: 9783319191478
GET BOOK

Hands On Relational Database Management System RDBMS 1000 MCQ

Hands On Relational Database Management System RDBMS 1000  MCQ
Author: Harry Chaudhary.
Publisher: STCD COMPANY
Relase: 2018-09-11
ISBN: 9780359075362
GET BOOK

Innovations for Community Services

Innovations for Community Services
Author: Michal Hodoň,Gerald Eichler,Christian Erfurth,Günter Fahrnberger
Publisher: Springer
Relase: 2018-06-05
ISBN: 9783319934082
GET BOOK

Database Administration

Database Administration
Author: Craig S. Mullins
Publisher: Addison-Wesley
Relase: 2012-10-11
ISBN: 9780133012729
GET BOOK

Management of Time Series Data

Management of Time Series Data
Author: Abel Matus Castillejos
Publisher: Unknown
Relase: 2006
ISBN: OCLC:225483533
GET BOOK

Real Time Stream Data Management

Real Time   Stream Data Management
Author: Wolfram Wingerath,Norbert Ritter,Felix Gessert
Publisher: Springer
Relase: 2019-01-02
ISBN: 9783030105556
GET BOOK

Recent Advances in Information Systems and Technologies

Recent Advances in Information Systems and Technologies
Author: Álvaro Rocha,Ana Maria Correia,Hojjat Adeli,Luís Paulo Reis,Sandra Costanzo
Publisher: Springer
Relase: 2017-03-27
ISBN: 9783319565354
GET BOOK

Advances in Conceptual Modeling

Advances in Conceptual Modeling
Author: Peter P. Chen,David W. Embley,Jacques Kouloumdjian,Stephen W. Liddle,John F. Roddick
Publisher: Springer Science & Business Media
Relase: 1999-10-27
ISBN: 3540666532
GET BOOK