Homework answers / question archive / The use of temporal database in the data management system Thank you in advance for the help! It contains built-in time aspects

The use of temporal database in the data management system Thank you in advance for the help! It contains built-in time aspects

Writing

Share With

The use of temporal database in the data management system Thank you in advance for the help! It contains built-in time aspects. To be more clear, the time aspect of the temporal data works on the transaction time and the valid time together forming bi-temporal data. Valid time ensures that the fact is correct with respect to what is happening in the world. Transition time, on the other hand, is the time taken while the fact is being stored in the database. However, the main essence of the temporal database remains to address the information, which particularly relates to the time aspect that may include past, present and the future. One example of the kind of data included in the temporal database includes the history of the stock market (the different prices of different stocks during a certain period) and the movement of employees within an organization. In this way, the temporal database allows the heads of the organization to understand the different trends (Patel, 2003).

There are different forms of temporal databases. The two bi-temporal databases, transition time and valid time help to distinguish between the different kinds of temporal database. A historical database is one, which stores data keeping valid time in mind. On the contrary, a rollback database stores data looking into the transaction time.

Database management systems known as DBMS are known for only storing a single state of the real world and this is the most recent state. Therefore, due to their short time, it is known as a snapshot database.

Another question that is worth considering is the reasons for the requirement of a temporal database. The reasons are quite simple. The relational data model has become popular in the last 20 years due to its simplicity and the tried and test mathematical foundation it possesses. Generally, the treatment of the changes in data is quite similar to the way ordinary data is treated. Most applications do require a temporal database.