INVESTIGATING THE PERFORMANCE OF ORM AND UML IN DATABASE MODELLING

ABSTRACT

Database modeling is the process of developing detailed data model for database application which is a blue print that guides how the model will be mapped into database system. This paper is a comparative study of the two modelling approaches Object Role Modelling (ORM) and the Unified Modeling Language (UML) as to determine best suited for approach for modelling complex database application, although both approaches are currently getting attention from customers, The research used Vision modeler and J developer for modelling the database applications with ORM and UML respectively. The findings of this study discover that ORM is better than UML in matters relating to Data Definition Language (DDL) and Table generated.

Keywords: Orm, Uml, Modelling, Table, Queries.