SQL2XMI: Reverse Engineering of UML-ER Diagrams from Relational Database Schemas

Manar H. Alalfi, James R. Cordy, Thomas Dean

2008 · 33 citations · 9 references

Concepts

TL;DR

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.

Abstract

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.

References

9