Temporal data in a fast-changing world!
This training will focus on methods and techniques for handling bitemporal data in a Data Warehouse. It includes how to populate and afterwards get bitemporal data out of the Data Warehouse’s core layer.
Over time, things change - things like customers, products, accounts, and so forth. But most of the data we keep about things describes what they are like currently, not what they used to be like. When things change, we update the data that describes them so that the description remains current. But all these things have a history, and many of them have a future as well, and often data about their past or about their future is also important. Tom Johnston
Nowadays, most data warehouses already store "some kind of history of" data. But what about events that took place at a different time than what the data warehouse represents to us? Or data that will be valid in the future? For example, future planned prices for products and goods or special prices for discount battles or sales promotions like the “Black Friday” in the United States.
Further details on the content of the training can be found in our Academy in the section Training -> Temporal Data.
|Event Date||2022-06-02 09:00|
|Event End Date||2022-06-10 13:00|
|Late Fee||100,00€ (From 2022-05-20 14:50)|
|Part 1||2022-06-02, 09:00-13:00|
|Part 2||2022-06-03, 09:00-13:00|
|Part 3||2022-06-08, 09:00-13:00|
|Part 4||2022-06-10, 09:00-13:00|