Back to search

UNF Digital Commons

A Web-Enabled Temporal Database Human Resources Application

Abstract

dc:description.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.

Degree

thesis:*
Name thesis:degree_name
Master of Science in Computer and Information Sciences (MS)
Discipline thesis:degree_discipline
Computing
Grantor dc:publisher
UNF Digital Commons

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Brooke, Joseph A, III
Contributors dc:contributor
  • Dr. Jae Y. Lee

Subjects

dc:subject × 5

Rights

dc:rights

Identifiers

dc:identifier.*
Repository record dc:identifier
https://digitalcommons.unf.edu/etd/167

Chain of custody

source
Harvested from
University of North Florida
Base URL
digitalcommons.unf.edu/do/oai/
Last updated
2026-11-18
Source record
OAI-PMH GetRecord
citation

Brooke, Joseph A, III. A Web-Enabled Temporal Database Human Resources Application. UNF Digital Commons, https://digitalcommons.unf.edu/etd/167