Abstract
The basic paradigm of conventional database systems is based on the current valid data processing. However, today's database systems should provide also management for historical and future valid data. Standard temporal model, using object level, stores the whole object data after the insert or update operation, although only some attributes changed their values. This paper deals with the principle of temporal data modelling based on the column level, not the whole object, describes the structure and principles of required methods, procedures, functions and triggers to provide functionality of the system. All designed and implemented solutions are compared with the existing solutions.
Highlights
Database systems are one of the most important parts of the information technology
Almost certainly it can be said that a database system is the basic part, the root of any information system
History management is very important in systems processing sensitive data; incorrect change would cause a great harm or in the systems requiring the possibility of restoring the previous states of the database
Summary
Database systems are one of the most important parts of the information technology. Almost certainly it can be said that a database system is the basic part, the root of any information system. If the valid time of the object is defined by a time interval, the transaction must include a time period - 2 time point values begin and end timestamps (or other data structure based on the granularity, like the date). The uni-temporal system uses the composite primary key – object identifier and the time interval defining the validity state characterizing the row. This uni-temporal structure model allows defining the historical and future valid data. The other systems with open left side representation have problem with the definition of the begin validity time point This method in comparison with the closedclosed representation does not have problem with changing granularity to smaller and does not need to update the table data to remove the undefined states. The principle and importance of the bi-temporal data modelling is described in [8 and 9]
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: Communications - Scientific letters of the University of Zilina
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
