Open AccessDesign and Analysis of Database Clustering System of Micro, Small and Medium Enterprises (MSME) in Bantul Regency
Author(s) -
Rr. Yuliana Rachmawati,
Muhammad Sholeh,
Suraya
Publication year - 2019
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1413/1/012028
Subject(s) - table (database) , database , computer science , information system , process (computing) , geographic information system , data mining , geography , engineering , cartography , electrical engineering , operating system
Information system support is really important for the existence of MSME in economic competition today. The implementation of information system for MSME is expected to develop the competitiveness through the added value for products and services. One of the examples of the utilization of information system implemented for MSME is the geographical information system which informs the location and the potential MSME. In order to present the information of the potential of MSME optimally in the geographical information system, analysis and design should be made as complete as possible. In this research, the geographic-based information system is developed for the MSME businessmen in Bantul. The system design is started by building a database. The purpose of this research is to design a database that is designed to avoid duplication of data and simplify the storage process and when displaying data. The process of geographical information system database of MSME is detailed into tables. The database process of the MSMES geographic Information system is detailed into tables. By being detailed into some of these tables the duplication can be avoided. Table designed between MSMES table that stores SME master data such as latitude and longitude position, MSME detail table, video, gallery, Medkom and tables that store the location of the area, such as sub-district table, Village table, Dusun table and Clustered tables from MSMES. The implementation of database design is developed into geographical information system using PHP language and utilizing google map to display the geographical position of MSME businessmen. The next application development can be developed based on Android.