Explore BrainMass

Temporal Databases

Demonstrate how you would use a temporal database to keep track of dates.

© BrainMass Inc. brainmass.com August 14, 2018, 9:21 am ad1c9bdddf

Solution Preview

A temporal database is like a standard database, with one large exception: it understands and logs the passing of time. For example, if someone worked at a company from 2011 to 2020, the temporal database will be able to store both dates as when the time starts, and when it ends. A standard database can only show that the employee is hired, and his or her employee information would have to be deleted when the employee leaves the company, because standard databases only understand the present. This standard was created in 1993, and implemented in 1994. All temporal databases include a valid time and transaction time integer that shows when the time happened in real life, and when the database was modified to accept the change.

Databases, in their early format, were only made to store strings of text and numbers, and they did not recognize the passage of time.
To alleviate these problems, the database ...

Solution Summary

The solution demonstrates how you would use a temporal database to keep track of dates.