1. A Brief History of Temporal Data Management
Contents
Excluding Time from Databases: A Ubiquitous Paradigm12
The 1980s13
Historical Databases13
History Tables13
The 1990s14
Temporal Extensions to SQL14
Data Warehouses and Data Marts Come of Age14
The Inmon/Kimball Religious Wars16
The 2000s18
Data Cubes18
Slowly Changing Dimensions19
Real-Time Data Warehouses20
The Future of Databases: Seamless Access to Temporal Data20
Closing In on Seamless Access22
Glossary References24
Temporal data management is not a new development. From the earliest days of business data processing (as it was called back then), transactions were captured in a transaction log and the files and tables those transactions were applied to were periodically backed up. With those ...

Get Managing Time in Relational Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial