Skip to main content

Implementing embedded valid time query languages

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1998)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1460))

Included in the following conference series:

  • 97 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. A. V. Aho, R. Sethi and J. Ullman, “Compilers: Principles, Techniques and Tools”, Addison-Wesley, 1985.

    Google Scholar 

  2. G. Ariav, “Information Systems for Managerial Planning and Control: A Conceptual Examination of their Temporal Structure”, Journal of MIS, vol. 8, 1992.

    Google Scholar 

  3. M. Bohlen, “Temporal Database System Implementations”, SIGMOD RECORD Vol. 24, No. 4, December 1995.

    Google Scholar 

  4. M. Bohlen, “TimeDB Software”, Department of Mathematics and Computer Science, Aalborg University, 1995.

    Google Scholar 

  5. 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.

    Google Scholar 

  6. 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.

    Google Scholar 

  7. 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.

    Google Scholar 

  8. 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.

    Google Scholar 

  9. C. J. Date and H. Darwen, “A Guide to the SQL Standard” (third edition), Reading, Massachusetts, Addison-Wesley, 1993.

    Google Scholar 

  10. C. J. Dale, “An Introduction to Database Systems” (sixth edition), Addison-Wesley Publishing Company Inc., 1995.

    Google Scholar 

  11. R. Hunter, “Compilers: Their Design and Construction Using Pascal”, Wiley and Sons, 1985.

    Google Scholar 

  12. Ingres Corporation, “Ingres SQL and ESQL Reference Manual” (for release 6.4), 1991.

    Google Scholar 

  13. 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.

    Article  Google Scholar 

  14. Oracle Corporation., “SQL Language Reference Manual” (for release 7), 1993.

    Google Scholar 

  15. Oracle Corporation, “ORACLE8 Time Series Cartridge User's Guide”, November 1997.

    Google Scholar 

  16. 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.

    Google Scholar 

  17. 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.

    Google Scholar 

  18. Sybase Inc., “Transact SQL User's Guide” (for release 10), 1994.

    Google Scholar 

  19. 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.

    Google Scholar 

  20. 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

    Google Scholar 

  21. 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

    Google Scholar 

  22. The TSQL2 Language Design Committee, “The TSQL2 Temporal Query Language”, Edited by R.T. Snodgrass, Kluwer Academic Publishers, 1995.

    Google Scholar 

  23. 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.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Gerald Quirchmayr Erich Schweighofer Trevor J.M. Bench-Capon

Rights and permissions

Reprints 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

Publish with us

Policies and ethics