Businesses often overwrite critical pieces of historical data related to customer behavior and market conditions. Teradata’s time-aware, temporal database capability empowers customers to capture, track and analyze change history of evolving business data to create a full picture of the company’s business. Analyzing the full history rather than just the most current updates reveals a true picture at any specific point in time. In doing so, customers gain greater visibility into data while reducing expense, implementation time, and data errors. Temporal analytics provides powerful capabilities for various types of customers requiring complex historical tracking and analysis functions. Teradata Temporal that lets you:
Gain richer, more meaningful analysis that reflects time-based changes in your business and environment
Eliminate complexity that increases development costs, delays applications, and complicates queries, ETL, and data maintenance
Take advantage of your database to automatically track history and understand changes over time
Teradata Temporal helps all industries, for example:
- Retailers – Do consistent year-over-year sales comparisons even as products are moved from one category to another.
- Insurers – Easily understand which customers had policies on a certain date, including those with changes made retroactively or in advance of the effective date.
- Manufacturers – Create more meaningful sales performance reports using sales territory realignment history.
Teradata Professional Services can help our customers implement the temporal option via two services: requirements assessment and implementation services.
Features & Benefits
Teradata 13.10 – The Time-Aware Analytics Database
| New Analytical Dimension – Gain new insights and a better understanding of your business by being able to clearly see how things have changed over time or how they looked at any point in time. |
|
|
| Faster Time to Value – Reduce the cost and complexity of implementing and using a temporal data warehouse. |
|
|
| More Detailed History – Extend the concept of detailed data in your data warehouse from transactions and similar data to all dimensions of your business data. |
|
|
| Specify Full Bi-Temporal Tables and Queries – Even without knowledge of effective date fields and complex condition clauses. |
|
|
| Improved Data Quality – Automatic temporal update processing reduces ETL and data maintenance complexity and leads to high quality data for everyone to use |
|
|
Primary Components
- Time dimension processing integrated throughout the Teradata Database
- Period data type
- Valid time and transaction time column attributes
- Temporal semantics including temporal qualifiers on constraints, queries, or sessions
- Complete integration for the most efficient addition of temporal history and processing to a data warehouse
- Backward compatibility
- Existing applications run without change
- Time series expansion
- Dynamically define time series on period data
- Produce results at periodic time points
|
Related Business Needs
Next Steps
Solid state storage 201
A look at better options for enterprise storage
Learn More
How can we help?
Contact us for insights and answers to your questions.
Contact Teradata