A UML-based approach to forward engineering of SQLite database

Abstract

An approach to automated forward engineering of SQLite database is presented in this paper. The proposed approach is completely based on the standard UML notation, which is used for conceptual modeling and for representation of the target relational database schema, as well. Unlike the existing approaches using specialized notation (UML profiles) for representation of relational database schema, in this paper standard UML class diagram is used. Finally, the automatic generation of the target SQLite database is performed by using Acceleo transformation program. In this way, a simple and more efficient forward engineering of SQLite database is achieved. The proposed approach is illustrated by a simple model in forward engineering of SQLite database in an open source Eclipse-based tool chain.