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

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

doi:10.1016/j.csi.2005.09.002

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 journal › Article › peer-review

17 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 language	English
Pages (from-to)	695-713
Number of pages	19
Journal	Computer Standards and Interfaces
Volume	28
Issue number	6
DOIs	https://doi.org/10.1016/j.csi.2005.09.002
Publication status	Published - 1 Sept 2006

Keywords

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

Access to Document

10.1016/j.csi.2005.09.002

Cite this

@article{0837a412da2c40a48c521fc5e2437f9a,

title = "An ontological approach to describe the SQL:2003 object-relational features",

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.",

keywords = "CWM, Databases, Object-Relational Features, OCL, Ontology, SQL:2003 Standard, UML",

author = "C. Calero and F. Ruiz and A. Baroni and {Brito e Abreu}, F. and M. Piattini",

year = "2006",

month = sep,

day = "1",

doi = "10.1016/j.csi.2005.09.002",

language = "English",

volume = "28",

pages = "695--713",

journal = "Computer Standards and Interfaces",

issn = "0920-5489",

publisher = "Elsevier",

number = "6",

}

TY - JOUR

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

AU - Calero, C.

AU - Ruiz, F.

AU - Baroni, A.

AU - Brito e Abreu, F.

AU - Piattini, M.

PY - 2006/9/1

Y1 - 2006/9/1

N2 - 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.

AB - 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.

KW - CWM

KW - Databases

KW - Object-Relational Features

KW - OCL

KW - Ontology

KW - SQL:2003 Standard

KW - UML

UR - http://www.scopus.com/inward/record.url?scp=33746261252&partnerID=8YFLogxK

U2 - 10.1016/j.csi.2005.09.002

DO - 10.1016/j.csi.2005.09.002

M3 - Article

AN - SCOPUS:33746261252

SN - 0920-5489

VL - 28

SP - 695

EP - 713

JO - Computer Standards and Interfaces

JF - Computer Standards and Interfaces

IS - 6

ER -

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

Abstract

Keywords

Access to Document

Other files and links

Fingerprint

Cite this