An ontological approach to describe the SQL:2003 object-relational features

C. Calero, F. Ruiz, A. Baroni, F. Brito e Abreu, M. Piattini

Research output: Contribution to journalArticlepeer-review

17 Citations (Scopus)


The SQL (Structured Query Language) is currently available in most database management systems and is the focus of an intense standardization process resulting in the latest version of the SQL:2003 standard. Standards are fundamental, but often they are difficult to use, due to their lack of understandability and the occurrence of inconsistencies. An ontology is useful for clarifying the elements of a standard, along with their interrelationships, as well as for detecting inconsistencies. In this paper we propose an ontology for the object-relational features of the new SQL:2003 standard, formalized with UML 2.0 class diagrams and OCL well-formedness rules. The ontology is instantiated with an example in which most of the new object-relational features of the SQL:2003 standard are presented.

Original languageEnglish
Pages (from-to)695-713
Number of pages19
JournalComputer Standards and Interfaces
Issue number6
Publication statusPublished - 1 Sept 2006


  • CWM
  • Databases
  • Object-Relational Features
  • OCL
  • Ontology
  • SQL:2003 Standard
  • UML


Dive into the research topics of 'An ontological approach to describe the SQL:2003 object-relational features'. Together they form a unique fingerprint.

Cite this