Design and implementation of graft database on MSME information system using Neo4j

Abstract

This study aims to implement a database of information systems for small and medium enterprises (MSME) using database graphs. In the conducted application development, the used database mostly uses the relational database. With the development of large amounts of data, the tendency of ever increasing data volume has an impact on the increasingly large table size and the number of merging data on the query (JOIN) has an impact on the time of accessing the query. This data speed is a problem in the relational database, and one solution is to use the noSQL database. In this research, the implementation of noSQL used a graph database and used the Neo4j application. The research methodology and database development carried out in this study is by collecting and analyzing, conceptual, logical, physical level databases on data related to the needs of MSME information systems such as MSME locations, MSME actors and MSME products. The data is then carried out conceptual level database design and proceed with logical level database design. This research resulted in a graft database that stored the MSME data. The results of the node from the graph database implementation were the nodes of city, sub-district MSME, and product and connector of the sub-district_entrance node which connecting the MSME location (sub-village) with the sub-district, the node connector of industrial_typed_entrance which connecting the MSME actors with the industry types.