Managing Time in Relational Databases: How to Design, Update and Query Temporal Data

3.8 avg rating
( 5 ratings by Goodreads )
 
9780123750419: Managing Time in Relational Databases: How to Design, Update and Query Temporal Data

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.

"synopsis" may belong to another edition of this title.

From the Back Cover:

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.

For more information, please visit www.assertedversioning.com

About the Author:

Dr. Tom Johnston is the Chief Scientist at Asserted Versioning, LLC, which has developed a middleware product which supports the standard theory of bitemporal data, and which also implements the Asserted Versioning extensions to that standard theory. He is the co-author of Managing Time in Relational Databases (Morgan-Kaufmann, 2010). He lives in Atlanta, Georgia.

Randall Weis, founder and CEO of InBase, Inc, has more than 25 years of experience in IT and IT management, specializing in enterprise data architecture. Weis' technical expertise is in sophisticated, multi-tiered systems. He has designed logical and physical data models and implemented several high profile, very large database (VLDB) systems in the financial and insurance industries. These systems have had very stringent performance and real-time history requirements. His software development company, InBase, Inc., has developed software and Web sites used by some of the nations largest companies. Weis has been a presenter at various user groups, including Guide, Share, Midwest Database Users Group and Camp IT Expo. His technique for modeling history, retro activity and future dating has been reviewed and approved for the physical implementation of IBM's Insurance Application Architecture (IAA).

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Johnston, Tom
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Quantity Available: 10
Seller
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2010. HRD. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # TE-9780123750419

More Information About This Seller | Ask Bookseller a Question

Buy New
48.30
Convert Currency

Add to Basket

Shipping: 3.07
Within U.S.A.
Destination, Rates & Speeds

2.

Tom Johnston, Randall Weis
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2010)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Hardcover Quantity Available: 10
Seller
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2010. Hardback. Book Condition: New. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. 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. Bookseller Inventory # EOD9780123750419

More Information About This Seller | Ask Bookseller a Question

Buy New
51.74
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Tom Johnston; Randall Weis
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Quantity Available: > 20
Print on Demand
Seller
BWB
(Valley Stream, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: New. This item is Print on Demand - Depending on your location, this item may ship from the US or UK. Bookseller Inventory # POD_9780123750419

More Information About This Seller | Ask Bookseller a Question

Buy New
55.37
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

JOHNSTON, TOM; WEIS, RANDALL
Published by Morgan Kaufmann (2010)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Hardcover Quantity Available: 10
Seller
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2010. Hardback. Book Condition: NEW. 9780123750419 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Bookseller Inventory # HTANDREE0892497

More Information About This Seller | Ask Bookseller a Question

Buy New
48
Convert Currency

Add to Basket

Shipping: 8
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

JOHNSTON, TOM; WEIS, RANDALL
Published by Morgan Kaufmann (2010)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Hardcover Quantity Available: 10
Seller
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2010. Hardback. Book Condition: NEW. 9780123750419 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Bookseller Inventory # HTANDREE01196617

More Information About This Seller | Ask Bookseller a Question

Buy New
48
Convert Currency

Add to Basket

Shipping: 8
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Johnston, Tom
Published by Morgan Kaufmann Publishers Inc. (2016)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Paperback Quantity Available: 1
Print on Demand
Seller
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann Publishers Inc., 2016. Paperback. Book Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Bookseller Inventory # ria9780123750419_lsuk

More Information About This Seller | Ask Bookseller a Question

Buy New
53.23
Convert Currency

Add to Basket

Shipping: 3.87
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Johnston, Tom; Weis, Randall
Published by Morgan Kaufmann
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Hardcover Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann. Hardcover. Book Condition: New. 0123750415 New Condition. Bookseller Inventory # NEW6.0040898

More Information About This Seller | Ask Bookseller a Question

Buy New
61.33
Convert Currency

Add to Basket

Shipping: 3.84
Within U.S.A.
Destination, Rates & Speeds

8.

Tom Johnston, Randall Weis
Published by Morgan Kaufmann (2010)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Hardcover Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2010. Hardcover. Book Condition: New. 1. Bookseller Inventory # DADAX0123750415

More Information About This Seller | Ask Bookseller a Question

Buy New
67.41
Convert Currency

Add to Basket

Shipping: 3.07
Within U.S.A.
Destination, Rates & Speeds

9.

Tom Johnston
Published by Morgan Kaufmann (2010)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Quantity Available: > 20
Print on Demand
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2010. HRD. Book Condition: New. New Book. Delivered from our US warehouse in 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND.Established seller since 2000. Bookseller Inventory # IP-9780123750419

More Information About This Seller | Ask Bookseller a Question

Buy New
62.47
Convert Currency

Add to Basket

Shipping: 9
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Johnston, Tom, Weis, Randall
Published by Morgan Kaufmann (2017)
ISBN 10: 0123750415 ISBN 13: 9780123750419
New Hardcover Quantity Available: 2
Print on Demand
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann, 2017. Hardcover. Book Condition: New. This item is printed on demand. Bookseller Inventory # P110123750415

More Information About This Seller | Ask Bookseller a Question

Buy New
71.60
Convert Currency

Add to Basket

Shipping: 2.30
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book