TEMPORAL DATABASES (TEMPORAL EXTENSIONS)
Throughout the 1990s, and perhaps even a little before that, a large community of academics spent a huge amount of time conducting research into so-called temporal databases. A temporal database supports some aspect of time. We might think that all modern RDBMSs support time because of the DATE/TIME data type. This is not what temporal databases are about. The DATE/TIME data type is a kind of user-defined time support. A real temporal database has time support within the structure of the DBMS. The schema tables, the query processor, etc., all have to have a fundamental understanding of time. We need to be able to ask questions like:
How many people move to a larger house within one year of their salary ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management 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.
