O'Reilly logo

Managing Time in Relational Databases by Randall Weis, Tom Johnston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required