Synonyms
Rollback operator; State query
Definition
The valid-timeslice operator may be applied to any temporal relation that captures valid time. Given also a valid-time element as a parameter, it returns the argument relation reduced in the valid-time dimension to just those time(s) specified by the valid-time element. The transaction timeslice operator is defined similarly, with the exception that the argument relation must capture transaction time.
Key Points
Several types of timeslice operators are possible. Some may restrict the time parameter to intervals or instants. Some operators may, given an instant parameter, return a conventional relation or a transaction-time relation when applied to a valid-time or a bitemporal relation, respectively; other operators may always return a result relation of the same type as the argument relation.
Oracle supports timeslicing through its flashback queries. Such queries can retrieve all the versions of a row between two transaction times (a...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Jensen CS, Dyreson CE. A consensus glossary of temporal database concepts – February 1998 version. In: Etzion O, Jajodia S, Sripada S, editors.Temporal databases: research and practice. Berlin: Springer-Verlag; 1998. p. 367–405. LNCS 1399.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Jensen, C.S., Snodgrass, R.T. (2018). Timeslice Operator. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_1426
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1426
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering