- Hardcover: 512 pages
- Publisher: Morgan Kaufmann; 1 edition (July 27, 2010)
- Language: English
- ISBN-10: 0123750415
- ISBN-13: 978-0123750419
- Product Dimensions: 7.5 x 1.1 x 9.2 inches
- Shipping Weight: 2.3 pounds (View shipping rates and policies)
- Average Customer Review: 10 customer reviews
- Amazon Best Sellers Rank: #1,520,459 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Managing Time in Relational Databases: How to Design, Update and Query Temporal Data 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Frequently bought together
Customers who viewed this item also viewed
"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
"Information technology consultants Johnston and Weis explain how to integrate time into a business data system, so that the past, present, and projected future of things can be accessed easily and quickly. Tables that show time are versioned tables, and they show how using them lowers the cost and increases the value of temporal data, data that shows change through time. They introduce temporal data management and asserted versioning, then look at designing, maintaining, and querying asserted version databases."--SciTech Book News
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
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
This book is no light read and is focused on the design and management of relational database tables using uni-temporal and bi-temporal data primarily in a business setting such as healthcare systems utilizing transaction processing.
Objectives as mentioned in the book:
* Seamless Access to Temporal Data -- One objective of this book is to describe how to manage uni-temporal and bi-temporal data in relational databases in such a way that they can be seamlessly accessed together with current data.
* Encapsulation Of Temporal Data Structures and Processes -- A second objective is to describe how to encapsulate the complexities of uni-temporal and bi-temporal data management.
* Enterprise Contextualization -- A third objective of this book is to explain how to implement temporal data management as an enterprise solution.
* Internalization of Pipeline Datasets -- The final objective of this book is to describe how to bring pending transactions into their production tables that are their targets, and how to retain posted transactions in those same tables.
Working with temporal data on a daily basis I find this subject interesting and this book relevant to my needs but I can see where this subject matter would apply to a niche market.
This textbook is not for the casual reader and it assumes that the reader has a level of database skills already in place, has a familiarity with temporal data, some familiarity with relational database tables, and assumes the reader has some SQL coding skills or is familiar with the syntax.
There are many examples throughout the book and all examples are in black & white with diagrams or coding examples; there are no glossy photos. Although I have not yet been able to go through the entire book I can see that I will benefit from the information contained and apply it to my daily work.
This book is not for everyone and is not misleading in trying to sell itself as an all-in-one database development resource. The title says it all -- Managing Time in Relational Databases: How to Design, Update and Query Temporal Data
Despite the weightiness of this 400-page effort, which required quite the journey (be forewarned), this book is one of the most painstakingly detailed technology efforts that I have read in quite some time that goes to great lengths in making sure the reader understands the material that is presented. No stones are left unturned along the way in the explanations of the authors on how to design, update, and query temporal data. In addition, the introductions that Johnston and Weis provide on temporal data management and asserted versioning in the first 150 pages are unrivaled in textbook publishing.
The authors state in their preface that there are four objectives of this book: (1) to describe how to manage uni-temporal and bi-temporal data in relational databases in such a way that they can be seamlessly accessed together with current data, (2) to describe how to encapsulate the complexities of uni-temporal and bi-temporal data management, (3) to explain how to implement temporal data management as an enterprise solution, and (4) to describe how to bring pending transactions into the production tables that are their targets, and how to retain posted transactions in those same tables.
The authors also note that as this book when to press, they started the process of converting their initial provisional patent application for Asserted Versioning into a patent application, although any non-software-vendor company is granted the right to develop its own temporal data management software based on the concepts presented in this book, as long as such software is for use only by the company and not sold, leased, licensed, or given away to any other company or individual. An implementation of the concepts presented by the authors, the Asserted Versioning Framework (AVF), is also being created by the authors.
Superb illustrations accompany explanations of concepts in all the right places. And the concluding chapter that the authors provide offers more substance than many lengthy white papers, offering an "ongoing research and development" section that presents a partial list of topics on which the authors are working, with topics such as use of AVF via Java and Hibernate of special interest to me. The asserted versioning glossary that spans over 50 pages of fine print and concludes the text is also highly appreciated. Well recommended to all data professionals.
Most recent customer reviews
Full disclosure: this book was provided to me free of...Read more