SQL extension for interval data

IEEE Transactions on Knowledge and Data Engineering

Volumn 9, Issue 3, 1997, Pages 480-499

  Lorentzos, Nikos A ^a   Mitsopoulos, Yannis G ^a  

^a AGRICULTURAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

Data model; Interval data; Query language; Spatial data; Temporal data

Indexed keywords

COMPUTATIONAL LINGUISTICS; COMPUTER HARDWARE DESCRIPTION LANGUAGES; COMPUTER SIMULATION; DECISION THEORY; INFORMATION MANAGEMENT; QUERY LANGUAGES;

INTERVAL DATA; STANDARD QUERY LANGUAGE;

DATA STRUCTURES;

EID: 0031147567     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/69.599935     Document Type: Article

References (32)

1. "The International Organization for Standardization," Database Language SQL. ISO 9075:1992(E), 1992.
2. S.J. Cannan and G.A.M. Otten, SQL: The Standard Handbook. McGraw-Hill, 1993.
3. C. Dyreson, F. Grandi, W. Kater, N. Kline, N. Lorentzos, Y. Mitsopoulos, A. Montanari, D. Nonen, E. Peressi, B. Pernici, J. Roddick, N. Sarda, M. Scalas, A. Segev, R. Snodgrass, M. Soo, A. Tansel, P. Tiberio, and G. Widerhold, "A Concensus Glossary of Temporal Database Concepts," C. Jensen, J. Clifford, R. Elmasri, S. Gadia, P. Hayes, and S. Jajodia, eds., SIGMOD Record, vol. 23, no. 1, pp. 52-64, Mar. 1994.
4. G. Ariav, "A Temporally Oriented Data Model," ACM Trans. Database Systems, vol. 11, no. 4, pp. 499-527, Dec. 1986.
5. J. Clifford and A. Croker, "The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans," Proc. Third Int'l Conf. Data Eng., pp. 528-537, Feb. 1987.
6. S.K. Gadia, "A Homogeneous Relational Model and Query Languages for Temporal Databases," ACM Trans. Database Systems, vol. 13, no. 4, pp. 418-448, Dec. 1988.
7. E. McKenzie and R. Snodgrass, "Supporting Valid Time: An Historical Algebra," Technical Report TR87-008, Computer Science Dept., Univ. of North Carolina, Chapel Hill, Aug. 1987.
8. S.B. Navathe and R. Ahmed, "Temporal Extensions to the Relational Model and SQL," Temporal Databases Theory, Design, and Implementation. J. Clifford and R. Snodgrass et al., eds., Benjamin Cummings, pp. 92-109, 1993.
9. N.L. Sarda, "Extensions to SQL for Historical Databases," IEEE Trans. Knowledge and Data Eng., vol. 2, no. 2, pp. 220-230, June 1990.
10. R.T. Snodgrass, I. Ahn, G. Ariav, D. Batory, J. Clifford, C.E. Dyreson, R. Elmasri, F. Grandi, C.S. Jensen, W. Kafer, N. Kline, K. Kulkarni, T.Y.C. Leung, N. Lorentzos, J.F. Roddick, A. Segev, M.D. Soo, and S.M. Spirada, The TSQL2 Temporal Query Language. R.T. Snodgrass, ed., Kluwer Academic Publishers, 1995.
11. A.U. Tansel, "A Historical Query Language," Information Sciences, vol. 53, pp. 101-133, 1991.
12. N.A. Lorentzos, "The Interval Extended Relational Model and Its Application to Valid Time Databases," Temporal Databases: Theory, Design, and Implementation. J. Clifford and R. Snodgrass, eds., pp. 67-91. Benjamin Cummings, 1993.
13. C.H. Salvator and A. Munoz, "TDBMS, User Requirements," ORES Deliverable B2, Dec. 1993.
14. N.A. Lorentzos, "Semantics in Databases with Interval Support," technical report, Informatics Laboratory, Agricultural Univ. of Athens, Sept. 1993.
15. R.T. Snodgrass, "The Temporal Query Language TQUEL," ACM Trans. Database Systems, vol. 12, no. 2, pp. 247-298, July 1987.
16. K.K. Al-Taha, R.T. Snodgrass and M.D. Soo, "Bibliography on Spatiotemporal Databases," SIGMOD Record, vol. 22, no. 1, pp. 59-67, Mar. 1993.
17. E.F. Codd, "A Relational Model of Data for Large Shared Data Banks," Comm. ACM, vol. 13, no. 6, pp. 377-387, June 1970.
18. N.A. Lorentzos, A. Poulovassilis, and C. Small, "Manipulation Operations for an Interval-Extended Relational Model," Data and Knowledge Engineering, vol. 17, pp. 1-29, 1995.
19. N.A. Lorentzos and R.G. Johnson, "TRA: Model for a Temporal Relational Algebra," Proc. Temporal Aspects in Information Systems, Sophia-Antipolis, France, May 1987. (in Temporal Aspects in Information Systems, C. Rolland, F. Bodart, and M. Leonard, eds., pp. 203-215, North Holland, 1988.
20. 2 Relations: An Integrated View on Flat Tables and Hierarchies," Proc. ACM SIGMOD '86 Int'l Conf. Management of Data, May 1986.
21. G. Ozsoyoglou, Z.M. Ozsoyoglou, and V. Matos, "Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions," ACM Trans. Database Systems, vol. 12, no. 4, pp. 566-592, Dec. 1987.
22. A. Segev, and A. Shoshani, "Logical Modeling of Temporal Data," Proc. ACM SIGMOD Int'l Conf. Management of Data, San Francisco, pp. 454-466, 1987.
23. J. Clifford, A. Croker, and A. Tuzhilin, "On Completeness of Historical Relational Query Languages," ACM Trans. Database Systems, vol. 19, no. 1, pp. 64-116, Mar. 1994.
24. M.A. Roth, H.F. Korth, and D.S. Batory, "SQL/ NF: A Query Language for Non-1NF Relational Databases," Information Systems, vol. 12, no. 1, pp. 99-114, 1987.
25. "Database Language SQL (SQL3)," ISO-NSI Working Draft. X3H2-93-091 and YOK-003, May 1993.
26. S.K. Gadia and G. Bhargava, "SQL-Like Seamless Query of Temporal Data," Proc. Int'l Workshop An Infrastructure for Temporal Databases, Arlington, Texas, June 1993.
27. N.A. Lorentzos, "DBMS Support for Non-Metric Measurement Systems," IEEE Trans. Knowledge and Data Eng., vol. 6, no. 6, pp. 945-953, Dec. 1994.
28. N.A. Lorentzos, "DBMS Support for Time and Totally Ordered Compound Data Types," Information Systems, vol. 17, no. 5, pp. 347-358, Sept. 1992.
29. N.A. Lorentzos, A. Poulovassilis, and C. Small, "Implementation of Update Operations for Interval Relations," Computer J., vol. 37, no. 3, pp. 163-176, 1994.
30. N.A. Lorentzos and Y. Manolopoulos, "Efficient Management of 2-d Interval Relations," Proc. Fifth Int'l Conf., DEXA '94, in Database and Expert Systems and Applications, D. Karagiannis, ed., pp. 72-82, Springler-Verlag, Sept. 1994.
31. C. Vassilakis, N.A. Lorentzos, P. Georgiadis, and Y.G. Mitsopoulos, "ORES: Design and Implementation of a Temporal DBMS," technical report, Dept. of Informatics, Univ. of Athens, 1994.
32. N.A. Lorentzos and Y.G. Mitsopoulos, "Specification of Valid Time SQL," ORES Deliverable D2, Sept. 1993.