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 journalArticle

15 Citations (Scopus)

Abstract

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
Volume28
Issue number6
DOIs
Publication statusPublished - 1 Sep 2006

Keywords

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

Fingerprint 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