Kıbrıs Db2 for z/OS: Exploiting Temporal Tables Eğitimi

• identify applications that may benefit from using temporal tables
• describe how temporal tables may be used to automatically handle historical data by using data versioning
• explain the difference between system-period and application-period data versioning
• define and use system and application-period temporal tables
• describe and use the new period-specification clauses in the SQL language
• use new utility options specific to temporal tables
• describe and use archive tables'.

The need for historical data; traditional methods for handling historical data; temporal table support; system-period temporal tables; application-period temporal tables.

Creating system-period temporal tables; Defining the system-period temporal table; ROW BEGIN, ROW END & TRANSACTION START ID columns; Defining the history table; Enabling system-period data versioning; Enabling an existing table for system-period data versioning; System-period data versioning example; Catalog tables.

Defining the application-period temporal table; Overlapping data; BUSINESS_TIME WITHOUT OVERLAPS; Modifying existing tables; Index creation; Catalog tables.

SYSTEM_TIME period-specification; FOR SYSTEM_TIME AS OF . . .; FOR SYSTEM_TIME FROM . . . TO . . .; FOR SYSTEM_TIME BETWEEN . . . AND . . .; BUSINESS_TIME period specification; FOR BUSINESS_TIME AS OF . .; FOR PORTION OF BUSINESS_TIME; Traditional UPDATE; UPDATE for time period - qualifying rows; Row category and behaviour; Row behaviour example (UPDATE); Row behaviour example (DELETE); Reasons to be cautious!!; Special registers and BIND options (DB2 11).

Archiving old data; Archive tables (Db2 11 for z/OS); Defining archive tables; NSERT, UPDATE & MERGE behaviour; SELECT behaviour.

Utility restrictions; LISTDEF additions; LISTDEF behaviour examples; RECOVER utility; LOAD utility.

Defining temporal tables; manipulating and reporting data in temporal tables.