SciELO - Scientific Electronic Library Online

 
vol.10 issue18Evolution strategies as an option for optimizing non linear functions with restrictions author indexsubject indexarticles search
Home Pagealphabetic serial listing  

Services on Demand

Journal

Article

Indicators

Related links

  • On index processCited by Google
  • Have no similar articlesSimilars in SciELO
  • On index processSimilars in Google

Share


Revista Ingenierías Universidad de Medellín

Print version ISSN 1692-3324On-line version ISSN 2248-4094

Abstract

ZAPATA JARAMILLO, Carlos Mario; GONZALEZ CALDERON, Guillermo  and  CHAVERRA MOJICA, John Jairo. Automatic generation of entity-relationship diagram and its representation in SQL from a controlled language (UN-LENCEP). Rev. ing. univ. Medellín [online]. 2011, vol.10, n.18, pp.127-136. ISSN 1692-3324.

Entity-relationship diagram (ERD) is one of the used in modelling the domain information. Several proposals have emerged for speeding up and improving the software development process by either automatically or semi-automatically obtain the ERD. Natural language, controlled languages, and intermediate representations have been used in such a task. The stakeholders (people with some concern in application development), when untrained, are incapable to understand several of such representations. As a consequence, stakeholder active participation in software development is highly restricted. Trying to solve these problems, a set of heuristic rules for automatically obtaining ERD and its SQL-based equivalence is proposed in this paper. The starting point is UN-Lencep, a controlled language already used for generating other artefacts belonging to software application development.

Keywords : UN-Lencep; entity relationship; SQL.

        · abstract in Spanish     · text in Spanish     · Spanish ( pdf )

 

Creative Commons License All the contents of this journal, except where otherwise noted, is licensed under a Creative Commons Attribution License