Database design for complex information systems: An approach based on XML Schemas

GOLOBISKY, MARÍA FERNANDA; VECCHIETTI, ALDO RODOMIRO

Punta Arenas, Chile.

Congreso; Jornadas Chilenas de Computación (JCC 2008); 2008

Sociedad Chilena de Ciencia de la Computación (SCCC)

In this paper we define a tool architecture for database design, based on SQL:2003 standard to manage the complex data of the current business information systems. Starting with an UML class diagram, the tool is able to generate database scripts based on SQL:2003. Transformation rules are needed to go from UML conceptual diagrams to objects and tables compliant wit the standard. The tool is based on metamodels, its implementation into XML Schemas and the definition of mapping rules between them. Each metamodel involved is instantiated from the XML Schema as a XML document and transformed into another XML document by the mapping rules defined using XSLT. Flexibility, modifiability and usability are pursued in the tool generation.