Select an Action
Managing time in relational databases : how to design, update and query temporal data
Title:
Managing time in relational databases : how to design, update and query temporal data
Author:
Johnston, Tom, 1944-
ISBN:
9780080963372
Personal Author:
Publication Information:
Amsterdam ; Boston : Elsevier/Morgan Kaufmann, ©2010.
Physical Description:
1 online resource (xxiii, 478 pages) : illustrations
Contents:
An introduction to temporal data management. A brief history of temporal data management -- A taxonomy of bi-temporal data management methods -- An introduction to asseted versioning. The origins of asserted versioning : computer science research -- The origins of asserted versioning : IT best practices -- The core concepts of asserted versioning -- Diagrams and other notations -- The basic scenario -- Designing, maintaining and querying asserted version databases. Designing and generating asserted versioning databases -- An introduction to temporal transactions -- Temporal transactions on single tables -- Temporal transactions on multiple tables -- Deferred assertions and other pipeline datasets -- Re-presenting internalized pipeline datasets -- Allen relationship and other queries -- Optimizing asserted versioning databases -- Conclusion.
Abstract:
Managing time in relational databases shows how to make the rich information content of bi-temporal data available to business users, while simplifying the design, maintenance and retrieval of that data. Metadata declarations eliminate the need to directly model temporal data. Temporal data maintenance is isolated in code that can be invoked to update bi-temporal data in any database and from any application program, across the enterprise. Anyone who can write queries against conventional data will be able to write queries against the bi-temporal data structures described in this book. Key features: 1. Integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development. 2. 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. 3. 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.
Subject Term:
Genre:
Added Author:
Electronic Access:
ScienceDirect https://www.sciencedirect.com/science/book/9780123750419Available:*
Shelf Number | Item Barcode | Shelf Location | Status |
|---|---|---|---|
| QA76.9 .D3 J64 2010 EB | 1181373-1001 | Elsevier E-Book Collections | Searching... |
On Order
Select a list
Make this your default list.
The following items were successfully added.
There was an error while adding the following items. Please try again.
:
Select An Item
Data usage warning: You will receive one text message for each title you selected.
Standard text messaging rates apply.