0 - 3 of 3 tags for time series

When Teradata released its new temporal capabilities in 2010, it caused us all to start to thinking differently about the element of time in the Data Warehouse by providing powerful tools for managing and navigating temporal & bitemporal data structures. With the release of Teradata R14.10, we will be challenged still further.

The Teradata Temporal feature, available with Teradata 13.10 allows the customer to capture, track, and analyze the full history of evolving business data rather than just the most current updates.

Time is one of the most powerful dimensions a data warehouse can support. Unfortunately it’s also one of the most problematic. Unlike OLTP environments that focus on only the most current versions of reference data, DW environments are often required to present data not only as it currently exists, but also as it previously existed. Implemented correctly, a data warehouse can support several temporal orientations, the three most common being “current,” “point-in-time,” and “periodic.” Implemented incorrectly, you will create a solution that will be impossible to maintain or support.