John F. Roddick
Skip Abstract Section
Abstract
The incorporation of a knowledge of time within database systems allows for temporally related information to be modelled more naturally and consistently. Adding this support to the metadatabase further enhances its semantic capability and allows elaborate interrogation of data. This paper presents SQL/SE, an SQL extension capable of handling schema evolution in relational database systems.
- 1. J.A. Bubenko. The temporal dimension in information modelling, in Architecture and Models in Data Base Management Systems, G. Nijssen (ed.), North-Holland Amsterdam, (1977).Google Scholar
- 2. A. Bolour, T.L. Anderson, L.J. Dekeyser and H.K.T. Wong. The role of time in information processing: A survey. SIGMOD RECORD, 12(3), (1982). Google ScholarDigital Library
- 3. E. McKenzie. Bibliography: temporal databases. SIGMOD RECORD, 40-52, (1986).Google Scholar
- 4. J. Clifford and G. Ariav. Temporal data management: models and systems, in New Directions for Database Systems Ch. 12, ABLEX Publishing Co., 168-185. (1986).Google Scholar
- 5. R.B. Stam and R. Snodgrass. A bibliography on temporal databases. Data Engineering, 7(4), 53-61, (1988).Google Scholar
- 6. D.H.O. Ling and D.A. Bell. Taxonomy of time models in databases. Information and Software Technology, 32(3), 215-224, (1990). Google ScholarDigital Library
- 7. J. Roddick and J. Patrick. Temporal semantics - a survey, Tech. Rep. 1/91, Deakin University, Victoria, (1991).Google Scholar
- 8. H. Laine, O. Maanavilja and E. Peltola. Grammatical database model. Information Systems, 4, 257-267, (1979).Google ScholarCross Ref
- 9. E. McKenzie and R. Snodgrass. Scheme evolution and the relational algebra. Information Systems, 15(2), 207-232, (1990). Google ScholarDigital Library
- 10. J.F. Roddick. Dynamically changing schemas within database models. Australian Computer Journal, 23(3), 105- 109, (1991). Google ScholarDigital Library
- 11. J. Banerjee, H.-T. Chou, J.F. Garza, W. Kim, D. Woelk and N. Ballou. Data model issues for object-oriented applications. ACM Transactions on Office Information Systems, 5(1), 3-26, (1987). Google ScholarDigital Library
- 12. J. Banerjee, H.-T. Chou, H.J. Kim and H.F. Korth. Semantics and implementation of schema evolution in object-oriented databases. ACM SIGMOD conference, San Francisco, CA, (1987). Google ScholarDigital Library
- 13. D.J. Penney and J. Stein. Class modification in the GemStone object-oriented DBMS. SIGPLAN Notices, 22, (1987). Google ScholarDigital Library
- 14. W. Kim and H.-T. Chou. Versions of schema for object-oriented databases. ACM SIGMOD Int. Conf. Very Large DataBases, (1988). Google ScholarDigital Library
- 15. S.L. Osborn. The role of polymorphism in schema evolution in an object-oriented database. IEEE Transactions on Knowledge and Data Engineering, l(3), 310-317, (1989). Google ScholarDigital Library
- 16. B.S. Lerner and A.N. Habermann. Beyond schema evolution to database reorganisation. SIGPLAN Notices, 25(10), 67-76, (1990). Google ScholarDigital Library
- 17. J. Melton. SQL2 (the sequel): a emerging standard. Database Programming and Design, 3(11), 24-32, (1990).Google Scholar
- 18. J. Clifford. A logical framework for the temporal semantics and natural language querying of historical databases, Ph.D. thesis, State University of New York at Stony Brook, (1982). Google ScholarDigital Library
- 19. S.K. Gadia and J. Vaishnav. A query language for a homogeneous temporal database. 4th Annual ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, Portland, Oregon, 51- 56, (1985). Google ScholarDigital Library
- 20. A.U. Tansel and M.E. Arkun. HQUEL, A query language for historical databases. 3rd International Workshop on Statistical and Scientific Database Management, Luxembourg, (1986). Google ScholarDigital Library
- 21. R. Snodgrass. The temporal query language TQUEL. ACM Transactions on Database Systems, 12(2), 247-298, (1987). Google ScholarDigital Library
- 22. S.K. Gadia. A homogeneous relational model and query languages for temporal databases. ACM Transactions on Database Systems, 13(4), (1988). Google ScholarDigital Library
- 23. S.B. Navathe and R. Ahmed. Temporal relational model and a query language. Information Sciences, 49, 147-175, (1989). Google ScholarDigital Library
- 24. N.L. Sarda. Algebra and query language for a historical data model. Computer Journal, 33(1), 11-18, (1990). Google ScholarDigital Library
- 25. J. Kim, H. Yoo and Y. Lee. Design and implementation of a temporal query language with abstract time. Information Systems, 15, 349-357, (1990). Google ScholarDigital Library
- 26. L. Marinos, M.P. Papazoglou and M. Norrie. Towards the design of an integrated environment for distributed databases, in Parallel Processing and Applications, E. Chiricozzi and A. D'Amico (ed.), Elsevier Science Publishers B.V. (North-Holland), 283-288. (1988).Google Scholar
- 27. R.H. Katz. Toward a unified framework for version modeling in engineering databases. ACM Computer Surveys, 22(4), 375-408, (1990). Google ScholarDigital Library
- 28. C.J. Date. A guide to the SQL standard, 2nd Ed., Addison-Wesley Publ. Co., (1989). Google ScholarDigital Library
- 29. J. Clifford and D.S. Warren. Formal semantics for time in databases. ACM Transactions on Database Systems, 8(2), 214-254, (1983). Google ScholarDigital Library
- 30. C. Zaniolo. Database relations with null values. Journal of Computer and System Sciences, 28, 142-166, (1984).Google ScholarCross Ref
- 31. M.A. Roth, H.F. Korth and A. Silberschatz. Null values in nested relational databases. Acta Informatica, 26, 615-642, (1989). Google ScholarDigital Library
- 32. C.J. Date. Null values in database management, in Relational database: selected writings, Addison-Wesley, (1986). Google ScholarDigital Library
Index Terms
- SQL/SE: a query language extension for databases supporting schema evolution
Comments