09/30142058 DC : 0

Foreword
Introduction
1 Scope
2 Normative references
   2.1 ISO/IEC JTC 1 standards
3 Terms and definitions
   3.1 Definitions
        3.1.1 Definitions taken from ISO/IEC 9075-1
        3.1.2 Definitions taken from ISO/IEC 9075-2
        3.1.3 Definitions provided in Part 1
        3.1.4 Definitions provided in Part 7
   3.2 Notations
        3.2.1 Notations provided in Part 1
        3.2.2 Notations provided in Part 7
   3.3 Conventions
4 Concepts
   4.1 Overview
        4.1.1 Tracked Table and History Table
        4.1.2 Concept of Transaction Timestamp
        4.1.3 Operations of Tracked Table
        4.1.4 Querying to History Table
        4.1.5 Concept of Period Normalization
   4.2 Structure of History Table
   4.3 Generating History Table and Storing History
        Row to History Table
   4.4 Referring History Table
   4.5 Types representing history rows
        4.5.1 HS_History type
        4.5.2 type
   4.6 Complementary SQL-invoked regular functions
        4.6.1 Constructor method of the HS_History type
        4.6.2 Methods of the HS_History type for treating
               a period
        4.6.3 Methods of the type
   4.7 The History Information Schema
5 History Procedures
   5.1 HS_CreateHistory Procedure and Sub Procedures
        5.1.1 HS_CreateHistory Procedure
        5.1.2 HS_CreateHistoryErrorCheck Procedure
        5.1.3 HS_CreateHistoryTableType Procedure
        5.1.4 HS_CreateHistoryTable Procedure
        5.1.5 HS_CreateUpdateTrigger Procedure
        5.1.6 HS_CreateInsertTrigger Procedure
        5.1.7 HS_CreateDeleteTrigger Procedure
        5.1.8 HS_CreatePNormalizeMethod Procedure
        5.1.9 HS_InitializeHistoryTable Procedure
   5.2 HS_DropHistory Procedure and Sub Procedures
        5.2.1 HS_DropHistory Procedure
        5.2.2 HS_DropHistoryErrorCheck Procedure
        5.2.3 HS_DropHistoryTableTypeMethod Procedure
        5.2.4 HS_DropHistoryTrigger Procedure
        5.2.6 HS_DropHistoryTableType Procedure
   5.3 Utility Procedures for History
        5.3.1 HS_CreateCommaSeparatedPrimaryKeyList Procedure
        5.3.2 HS_CreateCommaSeparatedPrimaryKeyAndTypeList
               Procedure
        5.3.3 HS_CreatePrimaryKeySelfJoinCondition Procedure
        5.3.4 Functions for extracting an identifier
        5.3.5 HS_CreateCommaSeparatedTrackedColumnList
               Procedure
        5.3.6 HS_CreateCommaSeparatedTrackedColumnAndTypeList
               Procedure
        5.3.7 Functions for constructing an identifier and
               
        5.3.8 HS_GetPrimaryKeys function
        5.3.9 HS_GetTransactionTimestamp function
   5.4 and
   5.5 Schema for Type
6 History Types
   6.1 HS_History Type and Routines
        6.1.1 HS_History Type
        6.1.2 HS_History Method
        6.1.3 HS_Overlaps Methods
        6.1.4 HS_Meets Methods
        6.1.5 HS_Precedes Methods
        6.1.6 HS_PrecedesOrMeets Methods
        6.1.7 HS_Succeeds Methods
        6.1.8 HS_SucceedsOrMeets Methods
        6.1.9 HS_Contains Methods
        6.1.10 HS_Equals Methods
        6.1.11 HS_MonthInterval Method
        6.1.12 HS_DayInterval Method
        6.1.13 HS_Intersect Methods
        6.1.14 HS_Union Methods
        6.1.15 HS_Except Methods
   6.2 Type and Routines
        6.2.1 Type
        6.2.2 HS_HistoryTable Method
        6.2.3 HS_PNormalize Methods
7 SQL/MM History Information Schema
   7.1 Introduction
   7.2 HS_TRACKED_TABLES view
   7.3 HS_TRACKED_COLUMNS view
8 SQL/MM History Definition Schema
   8.1 Introduction
   8.2 HS_TRACKED_TABLES base table
   8.3 HS_TRACKED_COLUMNS base table
9 Status Codes
10 Conformance
   10.1 Requirements for conformance
   10.2 Features of ISO/IEC 9075 required in this
        part of ISO/IEC 13249
   10.3 Claims of conformance
Annex A (informative) - Example Application
   A.1 Introduction
   A.2 Storing History Rows
   A.3 Example of Queries to History Table
Bibliography