Chapter 5. Temporal data management and analytics in an operational warehouse 175
Before looking into the technology, though, we first examine the concepts
involved and then consider several example use cases.
5.1.1 Temporal use cases for the operational data warehouse
There are numerous use cases in an operational data warehousing environment
where temporal awareness is useful or even required to manage and query the
data properly. We consider several here that illustrate key aspects of temporal
analysis.
Time-based business results analysis
One of the most common and most useful activities that can be performed in any
data warehouse environment is to report on some business results or metrics for
some specific point in time or to make a comparison ...