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.
Type de document :
Rapport
[Research Report] RR-1648, INRIA. 1992
Liste complète des métadonnées

https://hal.inria.fr/inria-00074912
Contributeur : Rapport de Recherche Inria <>
Soumis le : mercredi 24 mai 2006 - 16:53:37
Dernière modification le : mercredi 21 novembre 2018 - 19:26:10
Document(s) archivé(s) le : mardi 12 avril 2011 - 20:04:22

Fichiers

Identifiants

  • HAL Id : inria-00074912, version 1

Collections

Citation

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

Partager

Métriques

Consultations de la notice

196

Téléchargements de fichiers

56