Skip to main content
SpringerLink
Log in

ESQL: An Extended SQL with Object and Deductive Capabilities

  • Chapter
Database and Expert Systems Applications

Abstract

ESQL is an SQL upward-compatible database language that integrates in a uniform and clean way the essential concepts of relational, object-oriented and deductive databases. ESQL is intended for traditional data processing applications as well as more complex applications such as large expert systems. Therefore, ESQL’s salient features are: a rich and extendible type system based on abstract data types (ADTs) implemented in various programming languages; complex objects with object sharing by combining generic ADTs and object identity; the capability of querying and updating relations containing simple or complex objects using SQL-compatible syntax and semantics; and a DATALOG-like deductive capability provided as an extension of the SQL view mechanism.

This work is sponsored by ESPRIT project EDS

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

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.

References

  1. F. Bancilhon, “Object-Oriented Database Systems”, Int. Symp. on PODS, Austin, Texas, March 1988.

    Google Scholar 

  2. D. Beech, “A Foundation for Evolution from Relational to Object Databases”, Int. Conf. on EDBT, Venice, Italy, March 1988.

    Google Scholar 

  3. M.J. Carey, D.J. DeWitt, S.L. Vandenberg, “A Data Model and Query Language for EXODUS”, ACM SIGMOD Int. Conf., Chicago, Illinois, June 1988.

    Google Scholar 

  4. S. Danforth, P. Valduriez, “The Data Model of FAD, a Database Programming Language, Rev.1”, MCC Technical Report ACA-ST-059–88, June 1988, to appear in Information Sciences.

    Google Scholar 

  5. Gardarin89al G. Gardarin, P. Valduriez, “Relational Databases and Knowledge Bases”, Book, Addison-Wesley, 1989.

    Google Scholar 

  6. G. Gardarin et al., “Managing Complex Objects in an Extended Relational DBMS”, Int. Conf. on VLDB, Amsterdam, August 1989.

    Google Scholar 

  7. G. Gardarin, P. Valduriez, “ESQL: an Extension of SQL Combining Deductive and Object-Oriented Capabilities”, Research Report No. 1185, INRIA, France, March 1990.

    Google Scholar 

  8. J. Guttag, “Abstract Data Types and the Development of Data Structures”, Comm. of ACM, Vol. 20, No. 6, June 1977.

    Google Scholar 

  9. ISO ANSI, “Database Language SQL”, ISO/DIS 9075, International Standard, 1986.

    Google Scholar 

  10. S. Khoshafian, G. Copeland, “Object Identity”, Int. Conf. on OOPSLA, Portland, Oregon, September 1986.

    Google Scholar 

  11. S. Khoshafian, P. Valduriez, “Persistence, Sharing and Object Orientation: a database perspective”, Int. Workshop on Database Programming Languages, Roscoff, France, September 1987.

    Google Scholar 

  12. J. Melton, “ Database Language SQL2 and SQL3”, ISO-ANSI working draft, ISO DBL CAN-2b, May, 1989.

    Google Scholar 

  13. Z.M. Ozsoyoglu, L-Y. Yuan, “A New Normal Form for Nested Relations”, ACM TODS, Vol. 12, No. 1, March 1987.

    Google Scholar 

  14. H. Schek, “Nested Relations, a Step Forward or Backward”, IEEE Data Engineering, Vol. 11, No. 3, September 1988.

    Google Scholar 

  15. M. Stonebraker, B. Rubenstein, A. Guttman, “Application of Abstract Data Types and Abstract Indices to CAD Databases”, ACM -SIGMOD Int. Conf, San Jose ( California ), May 1983.

    Google Scholar 

  16. M. Stonebraker, L.A. Rowe, “The Design of POSTGRES”, ACM-SIGMOD Int. Conf., Washington, D.C., May 1986.

    Google Scholar 

  17. P. Valduriez, S. Danforth, “Functional SQL (FSQL), an SQL Upward Compatible Database Programming Language”, MCC Technical Report ACA-ST-045–89, February 1989, to appear in Information Sciences.

    Google Scholar 

  18. P. Valduriez, S. Danforth, B. Hart, T. Briggs, M. Cochinwala, “Compiling FAD, a Database Programming Language”, Int. Workshop on Database Programming Languages, Portland, Oregon, June 1989.

    Google Scholar 

  19. P. Valduriez, S. Danforth, “Query Optimization in Database Programming Languages”, Int. Conf. on Deductive and Object Oriented Databases, Kyoto, Dec. 1989.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. INRIA, BP.105, 78153, Le Chesnay-Cédex, France

    Georges Gardarin & Patrick Valduriez

Authors
  1. Georges Gardarin
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Patrick Valduriez
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institut für Statistik und Informatik, Universität Wien, Vienna, Austria

    A. Min Tjoa

  2. Institut für Informatik, Johannes Kepler Universität Linz, Linz, Austria

    Roland Wagner

Rights and permissions

Reprints and permissions

Copyright information

© 1990 Springer-Verlag/Wien

About this chapter

Cite this chapter

Gardarin, G., Valduriez, P. (1990). ESQL: An Extended SQL with Object and Deductive Capabilities. In: Tjoa, A.M., Wagner, R. (eds) Database and Expert Systems Applications. Springer, Vienna. https://doi.org/10.1007/978-3-7091-7553-8_49

Download citation

  • DOI: https://doi.org/10.1007/978-3-7091-7553-8_49

  • Publisher Name: Springer, Vienna

  • Print ISBN: 978-3-211-82234-0

  • Online ISBN: 978-3-7091-7553-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation