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

Hardcover (Print)
Buy New
Buy New from BN.com
$67.96
Used and New from Other Sellers
Used and New from Other Sellers
from $42.30
Usually ships in 1-2 business days
(Save 46%)
Other sellers (Hardcover)
  • All (7) from $42.30   
  • New (5) from $42.30   
  • Used (2) from $59.95   

Overview

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

Read More Show Less

Editorial Reviews

From the Publisher
"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 Enterprise, USA

"The authors present an original and comprehensive conceptual approach called Asserted Versioning, which includes support for bi-temporality and is a significant advance in the theory and practice of managing time-varying data." Richard Snodgrass, Professor of Computer Science at the University of Arizona

Read More Show Less

Product Details

  • ISBN-13: 9780123750419
  • Publisher: Elsevier Science
  • Publication date: 8/13/2010
  • Edition description: New Edition
  • Pages: 512
  • Product dimensions: 7.60 (w) x 9.40 (h) x 1.30 (d)

Meet the Author

Tom Johnston is an independent consultant specializing in enterprise data architecture, and in relational, object-oriented and data warehouse modeling in various industries, including telecommunications, health care, banking, retailing and transportation. He is also a regular columnist for DMReview and other industry-leading magazines and journals. His Web site is www.MindfulData.org.

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

Read More Show Less

Table of Contents

Part 1. An Introduction to Temporal Data Management Chapter 1. A Brief History of Temporal Data Management Chapter 2. A Taxonomy of Bi-Temporal Data Management Methods Part 2. An Introduction to Asserted Versioning Chapter 3.The Origins of Asserted Versioning: Computer Science Research Chapter 4.The Origins of Asserted Versioning: IT Best Practices Chapter 5. The Core Concepts of Asserted Versioning Chapter 6. Diagrams and Other Notations Chapter 7. The Basic Scenario Part 3. Designing, Maintaining and Querying Asserted Version Databases Chapter 8. Designing and Generating Asserted Versioning Databases Chapter 9. An Introduction to Temporal Transactions Chapter 10.Temporal Transactions on Single Tables Chapter 11. Temporal Transactions on Multiple Tables Chapter 12. Deferred Assertions and Other Pipeline Datasets Chapter 13. Re-Presenting Internalized Pipeline Datasets Chapter 14. Allen Relationship and Other Queries Chapter 15. Optimizing Asserted Versioning Databases Chapter 16. Conclusion Appendix: Bibliographical Essay

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)