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

# BITEMPORAL TABLES

## Contents

> Implementation Details

> Bitemporal Tables

> Modifications

> > Current Modification
> > Sequenced Modification
> > Nonsequenced Modification

> Queries

> > Timeslice Querie
> > The Spectrum of Bitemporal Queries
> > Multi-table queries involving bitemporal tables

> Integrity Constraints

> Temporal Partitioning

> > VT Current/TT Current + Bitemporal State
> > VT State/TT Current + State/State Archive
> > VT State/TT Current + State/Event Archive

> Vacuuming

#

# Implementation Details

> Oracle8 Server

#

# Bitemporal Tables

> Oracle8 Server

#

# Modifications

> Oracle8 Server

#

# Queries

> Oracle8 Server

#

# Integrity Constraints

> Oracle8 Server

#

# Temporal Partitioning

> Oracle8 Server

#

# Vacuuming

> Oracle8 Server

#### Code Credits

Scott I Calvert, Department of Computer Science, University of Arizona (calverts@CS.Arizona.EDU)

#### Html Credits

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