Year

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

Committee Chairperson

Dr. Jae Y. Lee

Rights Statement

http://rightsstatements.org/vocab/InC/1.0/

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.

Download

Share

COinS
 

Accessibility Statement

This item was created or digitized before April 24, 2027, or is a reproduction of legacy material created before that date. It is preserved in its original, unmodified state specifically for research, reference, or historical recordkeeping. In accordance with the ADA Title II Final Rule, the Library provides accessible versions of archival materials by request. If you are experiencing difficulty accessing the information on the site due to a disability, please submit a request through the following form for assistance.