• Dec 26, 2017 News!Vol. 4, No. 1-No.3 has been indexed by EI (Inspec).   [Click]
  • Dec 26, 2017 News!Vol. 3, No. 4 has been indexed by EI (Inspec).   [Click]
  • Dec 25, 2017 News!Welcome to 2018 7th International Conference on Software and Computing Technologies (ICSCT 2018), which will be held in Kuala Lumpur during April 7-9, 2018.   [Click]
General Information
    • ISSN: 2301-3559
    • Frequency: Quarterly
    • DOI: 10.18178/LNSE
    • Editor-in-Chief: Prof. Jemal Antidze
    • Executive Editor: Ms. Nina Lee
    • Abstracting/ Indexing: EI (INSPEC, IET), Electronic Journals Library,  Ulrich's Periodicals Directory, International Computer Science Digital Library (ICSDL), ProQuest and Google Scholar.
    • E-mail: lnse@ejournal.net
Prof. Jemal Antidze
I. Vekua Scientific Institute of Applied Mathematics
Tbilisi State University, Georgia
I'm happy to take on the position of editor in chief of LNSE. We encourage authors to submit papers concerning any branch of Software Engineering.

LNSE 2013 Vol.1(1): 26-30 ISSN:2301-3559
DOI: 10.7763/LNSE.2013.V1.6

A MDA Approach for Database Modeling

André Rosa, Italine Gonçalves, and Carlos E. Pantoja

Abstract—This paper proposes an approach for database modeling based on MDA, which aims to facilitate the database designer to choose between different conceptual modeling notations to use and automate the entire process, from conceptual modeling to code generation DDL, that will be compatible with ANSI SQL 92/99/2003 standards for implementation different DBMS. A meta-model that contains the characteristics necessary to be adherent to different notations as ER, IDEF1X and Crow’s Foot will be proposed and the transformation of the conceptual model for the DDL code will be made using the MOFM2T language, provided by the OMG.
A tool for the Eclipse development environment was constructed based on the approach; the meta-model was built using EMF and the transformations rules that generate SQL code was implemented in MOFM2T using Acceleo. It was instantiated a conceptual model based in ER notation that represents the factory organization database. After the transformations, we obtained the corresponding DDL code modeling instantiated which can be implemented in a DBMS that is standards compliant with SQL 92/99/2003.

Index Terms—Database modeling, model-driven architecture, model-to-text transformation.

The authors are with the CEFET/RJ - Uned Nova Friburgo Brazil. (e-mail: msc.pantoja@gmail.com ).


Cite: André Rosa, Italine Gonçalves, and Carlos E. Pantoja, "A MDA Approach for Database Modeling," Lecture Notes on Software Engineering  vol. 1, no. 1, pp. 26-30, 2013.

Copyright © 2008-2015. Lecture Notes on Software Engineering. All rights reserved.
E-mail: lnse@ejournal.net