2008 · 33 citations · 9 references
ComputingComputer ScienceInformation SystemsDatabasesSoftware EngineeringSystems ModelingData ModelingModel TransformationModel-driven DevelopmentModel-driven Software EngineeringSoftware ModelingStructured Query LanguageData Schema MappingDatabase Schema TranslationModel-driven DesignSchema MappingSoftware Reverse EngineeringUml ModelingXml Data Models
Data modeling is essential to software development, yet unlike UML for application modeling, there is no open standard for data modeling. The authors propose an approach and tool to bridge the gap between application and data modeling using source transformation technology. SQL2XMI automatically converts an SQL schema into a UML‑ER model expressed in XMI 2.1. This integration enables both data and application models to be manipulated with the same UML‑based tools.
Data modeling is an essential part of the software development process, and together with application modeling forms the core of the model-driven approach to software engineering. While UML is considered the standard for application modeling, there is really no corresponding open standard for data modeling. In this paper, we propose an approach and a tool to help bridge the gap between application and data modeling based on source transformation technology. The tool, called SQL2XMI, automatically transforms an SQL schema into a UML-ER model expressed in XML meta interchange (XMI) 2.1. By bringing the data model to the UML world, both data and application models can be manipulated using the same UML-based tools.
9
The TXL source transformation language
James R. Cordy · Science of Computer Programming · 2006 · 358 citations