Skip to main content
Springer Nature Link
Log in

A gateway from DBPL to ingres

  • Conference paper
  • First Online:
Applications of Databases (ADB 1994)

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

Included in the following conference series:

  • 281 Accesses

Abstract

A gateway from DBPL (being a superset of Modula-2) to the commercial database system Ingres is described. DBPL extends Modula-2 by a new bulk data type constructor “relation”, persistence, and high-level relational expressions (queries) based on the predicate calculus, thereby maintaining the basic concepts of the language like strong typing and orthogonality. The gateway enables the user to write normal DBPL programs for accessing Ingres databases. This is in contrast to typical implementations that embed SQL statements into a programming language and results in a fully transparent interface for DBPL programmers. DBPL queries and statements referring to Ingres tables are automatically converted into corresponding SQL statements, are evaluated by the Ingres database server and the results are transferred back under the control of the DBPL program. This procedure also resolves queries referring to both Ingres and DBPL tables. The design assumptions of the gateway and the used implementation methods are presented as well as design and implementation difficulties.

This research was supported by ESPRIT Basic Research (FIDE)

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. F. Bancilhon. Understanding Object-Oriented Database Systems. Advances in Database Technology — EDBT '92, Proc. of 3rd International Conference on Extending Database Technology, Vienna, Austria, March 1992, Springer LNCS 580, pp.1–9, 1992

    Book  Google Scholar 

  2. C.J. Date. A Guide to Ingres. Addison-Wesley 1987.

    Google Scholar 

  3. J. Eder, A. Rudloff, F. Matthes, J.W. Schmidt. Data Construction with Recursive Set Expressions. Next Generation Information System Technology. Proc. of 1st East/West Database Workshop, Kiev, USSR, Oct. 1990, Springer LNCS 504, 1991, pp.271–293

    Google Scholar 

  4. C. Fratarcangeli. Technique for Universal Quantification in SQL. SIGMOD RECORD Vol.20, No.3, Sep. 1991, pp.16–24

    Article  Google Scholar 

  5. Ingres/SQL Command Summary for the UNIX and VMS Operating Systems. Release 6, Relational Technology Inc., August 1989

    Google Scholar 

  6. Ingres/SQL Reference Manual. Release 6, Relational Technology Inc., August 1989

    Google Scholar 

  7. Language Reference Manual for INGRES/Windows 4GL for the UNIX and VMS Operating Systems. INGRES Release 6, Ingres Corporation, August 1990.

    Google Scholar 

  8. PL/SQL, User Guide and Reference, Version 1.0, June 1991, Oracle Corporation 1991.

    Google Scholar 

  9. F. Matthes, A. Rudloff, J.W. Schmidt, K. Subieta. The Database Programming Language DBPL, User and System Manual. FIDE, ESPRIT BRA Project 3070, Technical Report Series, FIDE/92/47, 1992

    Google Scholar 

  10. J.W. Schmidt, F. Matthes. The Rationale behind DBPL. 3rd Symposium on Mathematical Fundamentals of Database and Knowledge Base Systems, Springer LNCS 495, 1991.

    Google Scholar 

  11. J.W. Schmidt, F. Matthes. The Database Programming Language DBPL, Rationale and Report. FIDE, ESPRIT BRA Project 3070, Technical Report Series, FIDE/92/46, 1992

    Google Scholar 

  12. J.W. Schmidt, F. Matthes. Lean Languages and Models: Towards an Interoperable Kernel for Persistent Object Systems. Proceedings if the IEEE International Workshop on Research Issues in Data Engineering RIDE'93 Vienna, Austria, April 1993

    Google Scholar 

  13. M. Stonebraker, L.A. Rowe, B. Lindsay, J. Gray, M. Carey, M. Brodie, P. Bernstein, D. Beech: The Committee for Advanced DBMS Function. Third-Generation Data Base System Manifesto. ACM SIGMOD Record 19(3), pp.31–44, 1990.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science, University of Hamburg, Vogt-Kölln-Straße 30, D-22527, Hamburg, Germany

    Florian Matthes, Andreas Rudloff & Joachim W. Schmidt

  2. Institute of Computer Science, Polish Academy of Sciences, Ordona 21, PL-01-237, Warszawa, Poland

    Kazimierz Subieta

Authors
  1. Florian Matthes
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Andreas Rudloff
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Joachim W. Schmidt
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Kazimierz Subieta
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Witold Litwin Tore Risch

Rights and permissions

Reprints and permissions

Copyright information

© 1994 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Matthes, F., Rudloff, A., Schmidt, J.W., Subieta, K. (1994). A gateway from DBPL to ingres. In: Litwin, W., Risch, T. (eds) Applications of Databases. ADB 1994. Lecture Notes in Computer Science, vol 819. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58183-9_60

Download citation

  • DOI: https://doi.org/10.1007/3-540-58183-9_60

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-58183-3

  • Online ISBN: 978-3-540-48473-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics