| #### Developing Time-Oriented Database Applications in SQL Richard T. Snodgrass |

# Transaction-Time State Tables

## Contents

Transaction-Time State Tables
Defining a Transaction-Time State Table
Maintaining the Transaction-Time Table

> Indirectly Via Triggers
> Directly Via Rewritten Modifications

Queries
Partitioning

> Current and Archival Stores
> Queries
> Utilizing the Primary Key

Vacuuming

## About Transaction-Time State Table

SQLServer

## Defining a Transaction-Time State Table

Microsoft SQL Server

## Maintaining the Transaction-Time Table

Microsoft SQL Server

## Queries

Microsoft SQL Server

## Partitioning

Microsoft SQL Server

## Vacuuming

Microsoft SQL Server

#

HTML Credits

Jian Yang, Department of Computer Science, University of Arizona (yangjian@cs.arizona.edu)
April 27, 1999 (Last Update)