• Aug 25, 2016 News!Vol.4, No.3 has been published with online version. 15 peer reviewed articles from 3 specific areas are published in this issue.   [Click]
  • May 03, 2016 News!Vol. 3, No. 3 has been indexed by EI (Inspec).   [Click]
  • May 03, 2016 News!Vol. 3, No. 2 has been indexed by EI (Inspec).   [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), DOAJ, Electronic Journals Library, Engineering & Technology Digital Library, Ulrich's Periodicals Directory, International Computer Science Digital Library (ICSDL), ProQuest and Google Scholar.
    • E-mail: lnse@ejournal.net
Editor-in-chief
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 ).

[PDF]

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