A Flexible Approach for Database Design based on SQL:2003

GOLOBISKY, MARÍA FERNANDA; VECCHIETTI, ALDO RODOMIRO

Santa Fe, Argentina

Congreso; 34 Conferencia Latinoamericana de Informática; 2008

CLEI (Centro Latinoamericano de Estudios en Informática) - SADIO (Sociedad Argentina de Informática e Investigación Operativa)

In this paper we address the issues involved in the development of a flexible approach for database design based on SQL:2003 standard. The goal of this work is to present the steps and system architecture involved in the transformation of a database conceptual design in the form of UML class diagram, into database schema compliant with SQL:2003 standard. The mapping is founded on the MDA directive and is composed by three mapping layers. Flexibility of the approach is achieved in two different ways; first, developers can select the mapping rules such that final design can comply with relational or object-relational specifications, both included in the SQL:2003 standard; second, the system architecture proposed, based on metamodels and its implementation into XML Schemas allows an easy definition and modification of mapping rules.