Development of Application for Entity-Relationship Diagram Conversion to Logical Schema of NoSQL Column Oriented

The increasing usage of column-oriented NoSQL drives people to define methods to model the data structure of this technology. The data modelling methods require the support of tools or applications to make the modelling process faster and more accurate. In this research, we develop an application for converting conceptual data model depicted in Entity Relationship Diagram (ERD) to logical schema of column-oriented NoSQL and conversion of the logical schema to a data definition language for column-oriented NoSQL. First, we analyze how to convert data models drawn in the ERD to the logical model of column-oriented NoSQL based on an existing work. We provide an algorithm to perform the conversion from the ER model to the logical model of the NoSQL and produces a data definition language in the form of Cassandra Query Language (CQL), one of the column-oriented NoSQL database. The application is then built based on the analysis result and the algorithm. We employed software analysis models to design of the application. The testing of the application shows that the conversion from ERD to logical schema of column-oriented database as well as generation of data definition language to CQL are successfully carried out by the application. The test is done on various scenarios which cover various aspects of the ERD to show the broad capability of the application.