World Scientific
Skip main navigation

Cookies Notification

We use cookies on this site to enhance your user experience. By continuing to browse the site, you consent to the use of our cookies. Learn More
×

System Upgrade on Tue, May 28th, 2024 at 2am (EDT)

Existing users will be able to log into the site and access content. However, E-commerce and registration of new users may not be available for up to 12 hours.
For online purchase, please visit us again. Contact us at customercare@wspc.com for any enquiries.

Modeling Valid Time: An Efficient Representation

    https://doi.org/10.1142/9789812819536_0038Cited by:0 (Source: Crossref)
    Abstract:

    The bitemporal conceptual data model proposed for handling time within the framework of relational data model can be effectively represented using valid-time and transaction-time intervals as time-stamps on tuples. We observe that in many real-world applications, valid-time interval for a fact is not known completely while entering the fact in a temporal database. The model provides 'open' interval, from some valid time v to 'forever' for time-stamping such facts. However, updating temporal validity of such facts, which invariably will be required, is not handled efficiently by this representation. We propose an alternative representation which can reduce storage cost by upto 50% and which also results in less I/O during updates. We define the conventional and temporal algebra operations for this representation, and also add a few useful operators for processing open intervals. We propose extensions to temporal SQL to support open-ended valid time intervals.