Modeling Metadata and Data from Censuses and Surveys with GraphDatabases
Dublin Core
Title
Modeling Metadata and Data from Censuses and Surveys with GraphDatabases
Subject
graph database; database relational; database modelling
Description
Relational database users are switching to non-relational databases because non-relational databases are better able to handle
dynamic data storage. One of the institutions that require dynamic data storage is Statistics Indonesia (BPS). Currently, data
storage for census and survey activities at BPS is done using a relational database, even though there are metadata changes
in each activity. Accommodating metadata changes in each activity requires one database, which creates problems when
retrieving some raw data. There is an opportunity for convenience if the data collected is stored in a non-relational database,
one of which is a graph database. This research discusses the modeling of metadata and data from censuses and surveys at
BPS using a graph database. Followed by implementation on Neo4j DBMS and comparing the proposed model with the
relational model on Microsoft SQL Server DBMS. Then a comparison of the features and characteristics of each DBMS is
done, and finally, performance testing is done with Apache JMeter. Modeling has been able to handle dynamic data structure
changes, but Neo4j's performance is still lagging behind Microsoft SQL Server
dynamic data storage. One of the institutions that require dynamic data storage is Statistics Indonesia (BPS). Currently, data
storage for census and survey activities at BPS is done using a relational database, even though there are metadata changes
in each activity. Accommodating metadata changes in each activity requires one database, which creates problems when
retrieving some raw data. There is an opportunity for convenience if the data collected is stored in a non-relational database,
one of which is a graph database. This research discusses the modeling of metadata and data from censuses and surveys at
BPS using a graph database. Followed by implementation on Neo4j DBMS and comparing the proposed model with the
relational model on Microsoft SQL Server DBMS. Then a comparison of the features and characteristics of each DBMS is
done, and finally, performance testing is done with Apache JMeter. Modeling has been able to handle dynamic data structure
changes, but Neo4j's performance is still lagging behind Microsoft SQL Server
Creator
Alya Faradila, Lutfi Rahmatuti Maghfiroh
Source
http://jurnal.iaii.or.id
Publisher
Professional Organization Ikatan Ahli Informatika Indonesia (IAII)/Indonesian Informatics Experts Association
Date
October 2023
Contributor
Sri Wahyuni
Rights
ISSN Media Electronic: 2580-0760
Format
PDF
Language
English
Type
Text
Files
Collection
Citation
Alya Faradila, Lutfi Rahmatuti Maghfiroh, “Modeling Metadata and Data from Censuses and Surveys with GraphDatabases,” Repository Horizon University Indonesia, accessed January 12, 2026, https://repository.horizon.ac.id/items/show/10097.