DB2 Temporal Tables – Research Required

DB2 Temporal Tables

It is usually pretty easy to quickly implement the new DB2 features. DB2 makes it easy to improve your database performance with a new zParm or table space definition. Unlike most of these new features, however, DB2 temporal tables need research . . . → Read More: DB2 Temporal Tables — Research Required

DB2 Temporal Tables – Capturing a Snapshot of Your Business

DB2 offers application designers new functionality for their data warehousing requirements. The new DB2 10 Temporal Tables provide a way to have a snapshot in time of the status of customers, orders or any other type of business situation. DB2 Temporal Tables, with their built in functionality, automatically understand the business time or system time . . . → Read More: DB2 Temporal Tables — Capturing a Snapshot of Your Business

DB2 10 Enhances Business Intelligence Performance

The improvements in DB2 10 technology are definitely making building performance into business intelligence systems easier. The additional SQL data warehousing extensions such as Rank, Dense_Rank, and Materialized Query tables (MQTs) were great when they came out in DB2 8 and DB2 9. DB2 10 takes another giant step. . . . → Read More: DB2 10 Enhances Business Intelligence Performance

DB2 10 Temporal Tables Improve Performance

Within all database systems there are tables that hold transactions or some type of data based on time. These transactions unfortunately build up over time to handle regulatory compliance, infrequent access or support development of historical and trending reports.

Within your database design, this time-based transaction data builds up quickly and managing it so the . . . → Read More: DB2 10 Temporal Tables Improve Performance