skip to content
Managing time in relational databases : how to design, update and query temporal data Preview this item
ClosePreview this item
Checking...

Managing time in relational databases : how to design, update and query temporal data

Author: Tom Johnston; Randall Weis
Publisher: Amsterdam ; London : Morgan Kaufmann, ©2010.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:
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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Tom Johnston; Randall Weis
ISBN: 9780123750419 0123750415
OCLC Number: 515496628
Description: xxiii, 478 pages : illustrations ; 25 cm
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.
Responsibility: Tom Johnston, Randall Weis.
More information:

Abstract:

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. This book integrates an  Read more...

Reviews

Editorial reviews

Publisher Synopsis

"You cannot escape temporal data. You need to get over it, sit down and read what Tom and Randy are telling you in this book. " Joe Celko, Independent Consultant & Columnist for Intelligent Read more...

 
User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/515496628> # Managing time in relational databases : how to design, update and query temporal data
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "515496628" ;
   library:placeOfPublication <http://dbpedia.org/resource/London> ; # London
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/ne> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/802616689#Place/amsterdam> ; # Amsterdam
   schema:about <http://id.worldcat.org/fast/1739127> ; # Querying (Computer science)
   schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
   schema:about <http://dewey.info/class/005.753/e22/> ;
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:about <http://id.worldcat.org/fast/1147471> ; # Temporal databases
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://viaf.org/viaf/125917619> ; # Randall Weis
   schema:copyrightYear "2010" ;
   schema:creator <http://viaf.org/viaf/148015712> ; # Tom Johnston
   schema:datePublished "2010" ;
   schema:description "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."@en ;
   schema:description "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."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/802616689> ;
   schema:inLanguage "en" ;
   schema:name "Managing time in relational databases : how to design, update and query temporal data"@en ;
   schema:productID "515496628" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/515496628#PublicationEvent/amsterdam_london_morgan_kaufmann_2010> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/802616689#Agent/morgan_kaufmann> ; # Morgan Kaufmann
   schema:workExample <http://worldcat.org/isbn/9780123750419> ;
   umbel:isLike <http://bnb.data.bl.uk/id/resource/GBB068403> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/515496628> ;
    .


Related Entities

<http://dbpedia.org/resource/London> # London
    a schema:Place ;
   schema:name "London" ;
    .

<http://experiment.worldcat.org/entity/work/data/802616689#Agent/morgan_kaufmann> # Morgan Kaufmann
    a bgn:Agent ;
   schema:name "Morgan Kaufmann" ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/1147471> # Temporal databases
    a schema:Intangible ;
   schema:name "Temporal databases"@en ;
    .

<http://id.worldcat.org/fast/1739127> # Querying (Computer science)
    a schema:Intangible ;
   schema:name "Querying (Computer science)"@en ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/125917619> # Randall Weis
    a schema:Person ;
   schema:familyName "Weis" ;
   schema:givenName "Randall" ;
   schema:name "Randall Weis" ;
    .

<http://viaf.org/viaf/148015712> # Tom Johnston
    a schema:Person ;
   schema:birthDate "1944" ;
   schema:familyName "Johnston" ;
   schema:givenName "Tom" ;
   schema:name "Tom Johnston" ;
    .

<http://worldcat.org/isbn/9780123750419>
    a schema:ProductModel ;
   schema:isbn "0123750415" ;
   schema:isbn "9780123750419" ;
    .

<http://www.worldcat.org/title/-/oclc/515496628>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
   schema:about <http://www.worldcat.org/oclc/515496628> ; # Managing time in relational databases : how to design, update and query temporal data
   schema:dateModified "2018-11-11" ;
   void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.