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.

[1]  Mario Piattini,et al.  Defining Complexity Metrics for Object-Relational Databases , 2000, OOIS.

[2]  Susan Sales Harkins,et al.  Structured Query Language , 2002 .

[3]  Rajiv Kishore,et al.  A Helix-Spindle model for ontological engineering , 2004, CACM.

[4]  Anneke Kleppe,et al.  The Object Constraint Language: Getting Your Models Ready for MDA , 2003 .

[5]  Alan R. Simon,et al.  Sql: 1999 Understanding Relational Language Components , 2002 .

[6]  Ivar Jacobson,et al.  The unified modeling language reference manual , 2010 .

[7]  Ivar Jacobson,et al.  The Unified Modeling Language Reference Manual, Second Edition , 2005 .

[8]  Jim Melton,et al.  Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features , 2002 .

[9]  Tony Clark,et al.  Revised submission for MOF 2.0 query / views /transformations RFP. , 2003 .

[10]  Ivar Jacobson,et al.  Unified Modeling Language Reference Manual, The (2nd Edition) , 2004 .

[11]  Mario Piattini,et al.  An Ontology For The Management Of Software Maintenance Projects , 2004, Int. J. Softw. Eng. Knowl. Eng..

[12]  R GruberThomas.  Toward principles for the design of ontologies used for knowledge sharing , 1995 .

[13]  Asunción Gómez-Pérez,et al.  Ontological Engineering: With Examples from the Areas of Knowledge Management, e-Commerce and the Semantic Web , 2004, Advanced Information and Knowledge Processing.

[14]  C. J. Date.  Edgar F. Codd: a tribute and personal memoir , 2003, SGMD.

[15]  Christine W. Chan,et al.  Ontology Modeling Using UML , 2001, OOIS.

[16]  Coral Calero,et al.  Formalizing object-relational database metrics , 2004 .