Open main menu
Home
Random
Recent changes
Special pages
Community portal
Preferences
About Wikipedia
Disclaimers
Incubator escapee wiki
Search
User menu
Talk
Dark mode
Contributions
Create account
Log in
Editing
Temporal database
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
==Features== Temporal databases support managing and accessing temporal data by providing one or more of the following features:<ref name="SQL2011"/><ref name="DB2"/> * A time period datatype, including the ability to represent time periods with no end (infinity or forever) * The ability to define valid and transaction time period attributes and bitemporal relations * System-maintained transaction time * Temporal [[primary keys]], including non-overlapping period constraints * Temporal constraints, including non-overlapping uniqueness and [[referential integrity]] * Update and deletion of temporal records with automatic splitting and coalescing of time periods * Temporal queries at current time, time points in the past or future, or over durations * Predicates for querying time periods, often based on [[Allen's interval algebra#Relations|Allen's interval relations]]
Edit summary
(Briefly describe your changes)
By publishing changes, you agree to the
Terms of Use
, and you irrevocably agree to release your contribution under the
CC BY-SA 4.0 License
and the
GFDL
. You agree that a hyperlink or URL is sufficient attribution under the Creative Commons license.
Cancel
Editing help
(opens in new window)