Bitemporal Databases: Modeling and Implementation

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.

Canan Eren Atay received MS, PhD degrees from CUNY. Dr. Atay is an instructor at Dokuz Eylul University, Izmir, Turkey. Abdullah Uz Tansel studied at USC and the Middle East Technical University in Ankara, Turkey; is a professor of Computer Science at Baruch College and the Graduate Center of CUNY. His current research is on SaaS and SOA.