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

### Temporal Database Design

### Oracle8 Server

## Detailed Contents

This document deals with the case discussed in Chapter 11 using Oracle DBMS. It follows the general outline of the TDB book and is arranged in the following manner. The codes are all developed under Oracle 8.0.

> Conceptual Design

> Logical Design

> Physical Design

> Advanced Design Aspects

> Application Development

##

## Conceptual Design(Oracle8 Server)

## Logical Design (Oracle8 Server)

> Mapping to Relational Schema (cf11-1.sql)

> Applying Temporal Annotations

> > Entity Lifespans (cf11-1-1.sql)
> > Relationship Valid Time (cf11-2-4.sql)
> > Valid Time of Attributes ( Not used in this case )
> > Transaction Time (cf11-5-6.sql)
> > Primary Keys (cf11-711.sql)
> > Referential Integrity (cf111219.sql)
> > Uniqueness Constraints (cf11-20.sql)

## Physical Design (Oracle8 Server)

> Partition of table "LOT" (cf11-21.sql)

## Advanced Design Aspects (Oracle8 Server)

> Applying Temporal Annotations

> > Time-Invariant Keys (cf11-22.sql)
> > Time-Invariant Uniqueness Constraints (cf11-23.sql)

##

## Application Development (Oracle8 Server)

> All application queries (cf112443.sql)

#### Code Credits:

Wei Li, Department of Computer Science, University of Arizona (weil@cs.arizona.edu)

#### HTML Credits:

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