O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

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

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

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