Year of Publication

2001

Paper Type

Master's Thesis

College

College of Computing, Engineering & Construction

Degree Name

Master of Science in Computer and Information Sciences (MS)

Department

Computing

First Advisor

Dr. Jae Y. Lee

Abstract

Despite the inclusion of a variety of time-related or 'temporal' datatypes in the SQL-92 standard, vendors of commercially-available Relational Database Management Systems (RDBMS) have universally elected to not fully comply with the standard. Perhaps even more frustrating is the fact that each vendor has chosen to include a different subset of temporal datatypes than their competitors, with most vendors adding a proprietary twist to their datatypes not even contained within the standard.

This lack of conformity has left users of these database products faced with a difficult choice: either avoid temporal functionality within their database applications or develop and manage complex and often convoluted code to insert, maintain, and query this important data. Industry is replete with examples of both choices; not all of which have happy endings.

This project demonstrates some of the options available to RDBMS users who choose to employ temporal functionality in their applications. Alternatives are presented using a conceptual human resources application deployed via internet. Data is stored in a commercial RDBMS product. Solutions to temporal storage and query issues are presented.

Share

COinS