Managing time in relational databases : how to design, update and query temporal data / Tom Johnston, Randall Weis.

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 maintena...

Full description

Saved in:
Bibliographic Details
Main Author: Johnston, Tom, 1944-
Other Authors: Weis, Randall
Format: eBook
Language:English
Published: Amsterdam ; Boston : Elsevier/Morgan Kaufmann, ©2010.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000 a 4500
001 ocn652754987
003 OCoLC
005 20240623213015.0
006 m o d
007 cr cnu---unuuu
008 100805s2010 ne a ob 001 0 eng d
010 |a  2010282025 
040 |a OPELS  |b eng  |e pn  |c OPELS  |d OSU  |d N$T  |d EBLCP  |d OCLCQ  |d OPELS  |d OCLCQ  |d VLB  |d OCLCF  |d OCLCQ  |d YDXCP  |d OCLCQ  |d AZK  |d LIV  |d OCLCQ  |d D6H  |d CEF  |d NLE  |d AU@  |d COO  |d UKMGB  |d OCLCQ  |d WYU  |d LEAUB  |d STF  |d OL$  |d VT2  |d OCLCQ  |d BRF  |d OCLCO  |d OCLCQ  |d OCLCO  |d INARC  |d OCLCL  |d OCLCQ  |d OCLCL  |d SXB 
015 |a GBB068403  |2 bnb 
015 |a GBB6H2553  |2 bnb 
016 7 |a 015567488  |2 Uk 
016 7 |a 017549571  |2 Uk 
019 |a 961631458  |a 1058267814  |a 1064980365  |a 1097086760  |a 1102531586  |a 1103265364  |a 1129338360  |a 1192337679  |a 1240529941 
020 |a 9780080963372  |q (electronic bk.) 
020 |a 0080963374  |q (electronic bk.) 
020 |z 9780123750419 
020 |z 0123750415 
035 |a (OCoLC)652754987  |z (OCoLC)961631458  |z (OCoLC)1058267814  |z (OCoLC)1064980365  |z (OCoLC)1097086760  |z (OCoLC)1102531586  |z (OCoLC)1103265364  |z (OCoLC)1129338360  |z (OCoLC)1192337679  |z (OCoLC)1240529941 
037 |a 9780080963372  |b Ingram Content Group 
050 4 |a QA76.9.D3  |b J64 2010eb 
050 4 |a QA76.9.D32  |b J65 2010eb 
072 7 |a COM  |x 018000  |2 bisacsh 
049 |a HCDD 
100 1 |a Johnston, Tom,  |d 1944-  |1 https://id.oclc.org/worldcat/entity/E39PCjDfmXr4PQgD4MMwWbXkym 
245 1 0 |a Managing time in relational databases :  |b how to design, update and query temporal data /  |c Tom Johnston, Randall Weis. 
260 |a Amsterdam ;  |a Boston :  |b Elsevier/Morgan Kaufmann,  |c ©2010. 
300 |a 1 online resource (xxiii, 478 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
520 |a 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. 
504 |a Includes bibliographical references and index. 
505 0 |a 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. 
588 0 |a Print version record. 
650 0 |a Temporal databases. 
650 0 |a Relational databases. 
650 0 |a Database management. 
650 0 |a Querying (Computer science) 
650 7 |a online searching.  |2 aat 
650 7 |a COMPUTERS  |x Data Processing.  |2 bisacsh 
650 7 |a Temporal databases.  |2 blmlsh 
650 7 |a Relational databases.  |2 blmlsh 
650 7 |a Database management.  |2 blmlsh 
650 7 |a Querying (Computer science)  |2 blmlsh 
650 7 |a Database management  |2 fast 
650 7 |a Querying (Computer science)  |2 fast 
650 7 |a Relational databases  |2 fast 
650 7 |a Temporal databases  |2 fast 
700 1 |a Weis, Randall. 
758 |i has work:  |a Managing time in relational databases (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGCmx98pJfCfvrbQFTgyq3  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Johnston, Tom, 1944-  |t Managing time in relational databases.  |d Amsterdam ; Boston : Elsevier/Morgan Kaufmann, ©2010  |z 9780123750419  |w (OCoLC)515496628 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=647533  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD