RELATIONAL DATABASE STRUCTURE AND OPERATIONS ENGINEERING USING CLASS DIAGRAM AND ACTIVITY DIAGRAM

Abstract

Software system plays an important role especially
for processing large amounts of data. Currently, the operation of
a data is mostly done on the application layer, so the DBMS only
serves to store data processing results. Data processing on the
DBMS layer will make better performance, as it is closer to the
physical data. Application of constraints as well as data access
rights at the DBMS level will apply consistently to the system as a
whole so as to maintain data integrity. In this research, UMLbased approach is proposed to map the structure and operation
in a domain model into the structure and operation of relational
database. A software will be built using a driven architecture
model (MDA) to automate the transformation from UML to SQL
script. Class diagrams that describe the domain structure of the
model will be mapped into the table structure on the relational
database, while the Activity diagram that describes the
behavioral aspects of a domain model will be mapped into
procedure and function. It is expected that this research can
simplify the process of database schema development, increase
data processing speed and maintain data integrity.