Querying Temporal Database System for University Staff Database

Abstract

A temporal database is a database with built-in time aspects or a temporal data model and a temporal version of structured query language. More specifically the temporal aspects usually include valid time and transaction time. These attributes go together to form bi-temporal data. Valid time denotes the time period during which a fact is true with respect to the real world. Transaction time is the time period during which a fact is stored in the database. Bi-temporal data combines both Valid and Transaction Time. In this system, university staff database management system using temporal database is used for university staff transfer, promotion, education, training, experience, salary and position history need to be maintained. The main task of the system is to record the time varying data about university staffs database. University has different departments and different roles of staff. This staff has owned different positions and different salary on time varying. This system can maintain and analyze the staff’s history, position status and salary. Thus, the executive of the University can review the staff’s condition accordingly with the staff transfer and promotion.