Author:
Silachan Klaokanlaya,Intrarasombat Ouychai
Abstract
This research involves the development of a web model to transform data from an ecology dataset, specifically climate data, into a non-relational database format (NoSQL) in the form of a real-time document-based database. It consists of MongoDB nodes and CouchDB, comparing the speed of reading data from the database to select the bestperforming non-relational database for managing data values in the database. It is in a document-based format. It tests by loading the first 100 data sets, followed by 200, 300, 400, 500, 600, 800, and 1000 data sets. The experimental results show that the MongoDB server model has the best performance with an average value of 2,190,691.
Reference12 articles.
1. Abdelhedi F., Jemmali R., Zurfluh G. (2022). Relational Databases Ingestion into a NoSQL Data Warehouse.
2. Agapito G., Zucco C., Cannataro M. (2022). COVID-warehouse: a data warehouse of Italian COVID-19, Pollution, and Climate Data. International Journal of environmental research and public health.
3. Bouaziz S., Nabli A., Gargouri F. (2017). From Traditional Data Warehouse To Real Time Data Warehouse: Advances in Intelligent Systems and Computing.
4. Harvy I., Matitaputty G., Girsang A., Michael S., Isa S. (2019). The use of book store GIS data warehouse in implementing the analysis of most books selling. Proceedings of the 7th International Conference on Cyber and IT Service Management (CITSM), 1–5.
5. Optimizing the Performance of Data Warehouse by Query Cache Mechanism