HAL will be down for maintenance from Friday, June 10 at 4pm through Monday, June 13 at 9am. More information
Skip to Main content Skip to Navigation

ESQL2 - extending SQL2 to support object-oriented ans deductive databases

Georges Gardarin 1 Patrick Valduriez 1
1 RODIN - Database Systems
Inria Paris-Rocquencourt
Abstract : ESQL2 is an SQL2 upward-compatible database language that integrates in a uniform and clean way the essential concepts of relational, object-oriented and deductive databases. ESQL2 is intented 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) which can be implemented in various programming languages ; complex object with object sharing by combining generic ADTs and object identity ; the capability of querying and updating relations of values or classes of objects using extended SQL syntax and semantics ; a Datalog-like deductive capability provided as an extension of the SQL view mechanism ; and control statements for programming stored procedures and multi-statement queries. As ESQL2 is a rich language, a graphical representation of ESQL2 database schemas and queries is proposed to simplify query formulation. A database is represented using extended entity-relationship diagrams. A query is pictured as a database view where only relevent parts of diagrams are used, in addition, types may be constrained by predicates. This representation yields an algorithm to translate ESQL2 queries in Datalog extended with object identifiers, functions and sets, thereby defining the semantics of ESQL2 queries. Thus, ESQL2 may be perceived as a SQL-compatible syntax for expressing extended Datalog queries.
Document type :
Complete list of metadata

Contributor : Rapport de Recherche Inria Connect in order to contact the contributor
Submitted on : Wednesday, May 24, 2006 - 4:53:37 PM
Last modification on : Thursday, February 3, 2022 - 11:16:42 AM
Long-term archiving on: : Tuesday, April 12, 2011 - 8:04:22 PM


  • HAL Id : inria-00074912, version 1



Georges Gardarin, Patrick Valduriez. ESQL2 - extending SQL2 to support object-oriented ans deductive databases. [Research Report] RR-1648, INRIA. 1992. ⟨inria-00074912⟩



Record views


Files downloads