ESQL2 - extending SQL2 to support object-oriented ans deductive databases - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Reports (Research Report) Year : 1992

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

Patrick Valduriez


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.


Other [cs.OH]
Fichier principal
Vignette du fichier
RR-1648.pdf (2.09 Mo) Télécharger le fichier

Dates and versions

inria-00074912 , version 1 (24-05-2006)


  • 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⟩
114 View
26 Download


Gmail Facebook X LinkedIn More