Bitemporal Databases

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

All mainstream database systems lack support for temporal metadata, and instead store only the most recent data. Consequently, they can only manage temporal data in an ad hoc manner – oftentimes not effectively. Yet there are countless application domains that need temporal data. This book offers a much-needed solution: It includes a bitemporal relational data model, based on nested relations, as well as its algebra and calculus languages for expressing queries. The fundamental construct for representing temporal data is a bitemporal atom; a value, its validity period, and the time this data was recorded in the database. The concept of ‘context’ defines different views of bitemporal data. BtSQL, a simple bitemporal variation of the SQL, is introduced. The book also provides a prototype implementation, which demonstrates the feasibility of the proposed approach in an object-relational database system. Researchers and practitioners in database development will find this book useful. It can be used as a textbook in advanced database courses – particularly in application domains where temporal metadata can greatly leverage the value of the data as it is stored and utilized.