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.
