Explore BrainMass

Explore BrainMass

    Temporal Databases

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

    © BrainMass Inc. brainmass.com October 10, 2019, 6:24 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.