Abstract
Application development on top of database systems is heavily based on the existence of embedded and 4GL languages. However, the issue of designing and implementing embedded or 4GL temporal languages has not been addressed insofar. In this paper, we present a design approach for implementing an embedded temporal language that supports valid time. Furthermore, we introduce implementation techniques that can be used for implementing any embedded temporal language that supports valid time on top of a DBMS.
Preview
Unable to display preview. Download preview PDF.
References
A. V. Aho, R. Sethi and J. Ullman, “Compilers: Principles, Techniques and Tools”, Addison-Wesley, 1985.
G. Ariav, “Information Systems for Managerial Planning and Control: A Conceptual Examination of their Temporal Structure”, Journal of MIS, vol. 8, 1992.
M. Bohlen, “Temporal Database System Implementations”, SIGMOD RECORD Vol. 24, No. 4, December 1995.
M. Bohlen, “TimeDB Software”, Department of Mathematics and Computer Science, Aalborg University, 1995.
R. Chandra and A. Segev, “Using Next Generation Databases to Develop Financial Applications”, Proceedings of the First International Conference on Application of Databases (ADB), Vadstena, Sweden, June 1994.
J. Clifford, C. Jensen. R. Snodgrass, M. Bohlen, H. Dewand and D. Schmidt. “Panel: The State-of-the-Art in Temporal Database Management: Perspectives from the Research and Financial Application Communities”, Proceedings of the VLDB International Workshop on Temporal Databases, Zurich 1995.
C. Combi, F. Pinciroli, G. Musazzi and C. Ponti, “Managing and Displaying Different Time Granularities of Clinical Information”, Eighteenth Annual Symposium on Computer Applications in Medical Care, Washington DC. U.S.A. 1994.
C. Combi, F. Pinciroli, M. Cavallaro and G. Cucchi. “Querying Temporal Clinical Databases with Different Time Granularities: The GCH-OSQL Language”, Nineteenth Annual Symposium on Computer Applications in Medical Care, New Orleans, U.S.A., 1995.
C. J. Date and H. Darwen, “A Guide to the SQL Standard” (third edition), Reading, Massachusetts, Addison-Wesley, 1993.
C. J. Dale, “An Introduction to Database Systems” (sixth edition), Addison-Wesley Publishing Company Inc., 1995.
R. Hunter, “Compilers: Their Design and Construction Using Pascal”, Wiley and Sons, 1985.
Ingres Corporation, “Ingres SQL and ESQL Reference Manual” (for release 6.4), 1991.
C. S. Jensen, J. Ciifford, R. Elmarsi et al. “A Consensus Glossary of Temporal Database Concepts”, SIGMOD Record, 23(1), pp. 52–64, March 1994.
Oracle Corporation., “SQL Language Reference Manual” (for release 7), 1993.
Oracle Corporation, “ORACLE8 Time Series Cartridge User's Guide”, November 1997.
ORES Project (ESPRIT III P7224) Deliverable D4.2: “Application Manual”, edited by 01 Pliroforiki. University of Athens, Agricultural University of Athens and Information Dynamics, 1993. Available at ftp://ftp.di.uoa.gr/pub/ores/rep/d4_2.ps.gz.
D. Schmidt and R. Mari, “Time Series, a Neglected Issue in Temporal Database Research?”, Proceedings of the VLDB International Workshop on Temporal Databases, Zurich 1995.
Sybase Inc., “Transact SQL User's Guide” (for release 10), 1994.
B. Theodoulidis, A. Ail-Braham and G. Karvelis, “The ORES Temporal DBMS and the ERT-SQL Query Language”, Proceedings of the 5th International Conference on Database and Expert System Applications, Athens 1994.
K. Torp, C. Jensen and M. Böhlen, “Layered Implementation of Temporal DBMSs-Concepts and Techniques”, TimeCenter Technical Report TR-2, 1997 available from http://www.cs.auc.dk/general/DBS/tdb/TimeCenter/publications.html
K. Torp, C. Jensen and R. T. Snodgrass, “Stratum Approaches to Temporal DBMS Implementations”, TimeCenter Technical Report TR-5, 1997, available from http://www.cs.auc.dk/general/DBS/tdb/TimeCenter/publications.html
The TSQL2 Language Design Committee, “The TSQL2 Temporal Query Language”, Edited by R.T. Snodgrass, Kluwer Academic Publishers, 1995.
C. Vassilakis, P. Georgiadis and A. Sotiropoulou, “A Comparative Study of Temporal DBMS Architectures”, Proceedings of the 7th International DEXA Workshop, pp. 153–164, Zurich, 1996.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vassilakis, C., Georgiadis, P., Sellis, T. (1998). Implementing embedded valid time query languages. In: Quirchmayr, G., Schweighofer, E., Bench-Capon, T.J. (eds) Database and Expert Systems Applications. DEXA 1998. Lecture Notes in Computer Science, vol 1460. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0054514
Download citation
DOI: https://doi.org/10.1007/BFb0054514
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64950-2
Online ISBN: 978-3-540-68060-4
eBook Packages: Springer Book Archive