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

GET 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
Bitemporal Data
Language: en
Pages: 400
Authors: Tom Johnston
Categories: Computers
Type: BOOK - Published: 2014-08-19 - Publisher: Newnes

GET 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
Developing Robust Date and Time Oriented Applications in Oracle Cloud
Language: en
Pages: 464
Authors: Michal Kvet
Categories: Computers
Type: BOOK - Published: 2023-05-12 - Publisher: Packt Publishing Ltd

GET EBOOK

Create robust temporal solutions in Oracle Cloud and spread the solution worldwide by leveraging its regional properties and time zone synchronization Purchase
Database Modeling and Design
Language: en
Pages: 347
Authors: Toby J. Teorey
Categories: Computers
Type: BOOK - Published: 2011-02-10 - Publisher: Elsevier

GET EBOOK

Database Modeling and Design, Fifth Edition, focuses on techniques for database design in relational database systems. This extensively revised fifth edition fe
Joe Celko's SQL for Smarties
Language: en
Pages: 817
Authors: Joe Celko
Categories: Computers
Type: BOOK - Published: 2010-11-22 - Publisher: Elsevier

GET EBOOK

Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39