ESQL: An Extended SQL with Object and Deductive Capabilities

  • Georges Gardarin
  • Patrick Valduriez


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.


Complex Object Query Optimization Deductive Database Object Identifier Abstract Data Type 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Bancilhon88]
    F. Bancilhon, “Object-Oriented Database Systems”, Int. Symp. on PODS, Austin, Texas, March 1988.Google Scholar
  2. [Beech88]
    D. Beech, “A Foundation for Evolution from Relational to Object Databases”, Int. Conf. on EDBT, Venice, Italy, March 1988.Google Scholar
  3. [Carey88]
    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. [Danforth88]
    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. [Gardarin89a]
    Gardarin89al G. Gardarin, P. Valduriez, “Relational Databases and Knowledge Bases”, Book, Addison-Wesley, 1989.Google Scholar
  6. [Gardarin89b]
    G. Gardarin et al., “Managing Complex Objects in an Extended Relational DBMS”, Int. Conf. on VLDB, Amsterdam, August 1989.Google Scholar
  7. [Gardarin90]
    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. [Guttag77]
    J. Guttag, “Abstract Data Types and the Development of Data Structures”, Comm. of ACM, Vol. 20, No. 6, June 1977.Google Scholar
  9. [IS086]
    ISO ANSI, “Database Language SQL”, ISO/DIS 9075, International Standard, 1986.Google Scholar
  10. [Khoshafian86]
    S. Khoshafian, G. Copeland, “Object Identity”, Int. Conf. on OOPSLA, Portland, Oregon, September 1986.Google Scholar
  11. [Khoshafian87]
    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. [Melton89]
    J. Melton, “ Database Language SQL2 and SQL3”, ISO-ANSI working draft, ISO DBL CAN-2b, May, 1989.Google Scholar
  13. [Ozsoyoglu87]
    Z.M. Ozsoyoglu, L-Y. Yuan, “A New Normal Form for Nested Relations”, ACM TODS, Vol. 12, No. 1, March 1987.Google Scholar
  14. [Schek88]
    H. Schek, “Nested Relations, a Step Forward or Backward”, IEEE Data Engineering, Vol. 11, No. 3, September 1988.Google Scholar
  15. [Stonebraker83]
    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. [Stonebraker86]
    M. Stonebraker, L.A. Rowe, “The Design of POSTGRES”, ACM-SIGMOD Int. Conf., Washington, D.C., May 1986.Google Scholar
  17. [Valduriez89a]
    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. [Valduriez89b]
    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. [Valduriez89c]
    P. Valduriez, S. Danforth, “Query Optimization in Database Programming Languages”, Int. Conf. on Deductive and Object Oriented Databases, Kyoto, Dec. 1989.Google Scholar

Copyright information

© Springer-Verlag/Wien 1990

Authors and Affiliations

  • Georges Gardarin
    • 1
  • Patrick Valduriez
    • 1
  1. 1.INRIALe Chesnay-CédexFrance

Personalised recommendations