SQL extension for interval data
Nikos A. Lorentzos, Yannis Mitsopoulos · IEEE Transactions on Knowledge and Data Engineering · 1997
IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval data. Design decisions and implementation issues are also discussed.
Cited by 110 works. doi:10.1109/69.599935
Authors
References
- A relational model of data for large shared data banks
- International Organization for Standardization
- The temporal query language TQuel
- Temporal Databases: Theory, Design, and Implementation
- The TSQL2 Temporal Query Language
- A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies
- Logical modeling of temporal data
- A consensus glossary of temporal database concepts
- A homogeneous relational model and query languages for temporal databases
- The historical relational data model (HRDM) and algebra based on lifespans