Automated Data Integration of Biodiversity with OLAP and OLTP

Arie Vatresia, Asahar Johar, Ferzha Putra Utama, Sinta Iryani

Abstract


Biodiversity is one of emerging issue over decades; many have performed research to map and to document the data over the world. This issue is very important due to the event of extinction have been accelerating happening because of human extinction. Bengkulu, as one of the province lied in one of 19 hotspots in the world, Sundanese, has experienced the degradation of flora and fauna over the case of forest degradation and habitat loss. Although many application and software has been developed to solve the case, the existences of data standardization still become an issue over this problem. In this research, study of data integration had been developed to make the process of biodiversity data acquisition can be more effective and efficient. The system proposed the integration based on OLAP and OLTP that will be connected to IUCN, as one of the biggest center for monitoring the loss of biodiversity all around the world. This application had been built with web based using UML design and followed SDLC to provide the best fit of the need. This research had also succeeded to build the automated integration to show the record of dynamic number over biodiversity existences in Bengkulu. The application had been tested using black box and has the perfect performance (100%) over the testing that can help the monitoring process over biodiversity data.

Keywords


Bengkulu, Flora & Fauna, OLAP & OLTP, Data Integration

Full Text:

PDF

References


Diskominfotik, “Sekilas Bengkulu,” 2020. [Online]. Available: https://bengkuluprov.go.id/sekilas-bengkulu/.

W. Darwis, “Konservasi Hayati,” J. Ilim., vol. 08, no. 01, pp. 1–55, 2012.

I. Status, “Mendukung Penelitian Doktor UCSD,” no. September 2015, pp. 1–14, 2015.

Softbless, “Data Integration,” PT Softbless Solutions, 2016. [Online]. Available: https://www.softbless.com/Data-Integration.

M. Hasanudin et al., “PERANCANGAN MODEL DATA WAREHOUSE PENJUALAN,” pp. 34–41, 2019.

A. Johar, A. Vatresia, and L. Martasari, “Aplikasi Business Intelligence ( Bi ) Data Pasien Rumah Sakit M .Yunus Menggunakan Metode Olap ( Online Analytical

Processing ),” Rekursif, vol. 3, no. Bisnis Intelijen, pp. 12–22, 2015.

S. P. Adithama, “RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE BERBASIS WEB UNTUK SUBJEK KEGIATAN AKADEMIK PADA UNIVERSITAS,” vol. 2014, no. Sentika, 2014.

Rianto and Cucu Hadis, “Perancangan Data Warehouse Pada Rumah Sakit ( Studi Kasus : BLUD RSU Kota Banjar ),” Sains dan Teknolgi, vol. 3, no. 2, pp. 214–221, 2017.

P. Ponniah, DATA WAREHOUSING FUNDAMENTALS Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals. Paulraj Ponniah DATA WAREHOUSING FUNDAMENTALS A Comprehensive Guide for IT Professionals PAULRAJ PONNIAH, vol. 6. 2001.

Y. Firdaus, S. B. Premapasha, and S. Yulias, “Analisis dan Perancangan Sistem Online Transaction Processing ( OLTP ) Menggunakan SCRUM ( Studi Kasus Rumah Sakit Puti Bungsu ) Analytics and Development Online Transaction Processing ( OLTP ) System Using SCRUM ( Case Study in Puti Busngsu Hospital ),” e Proceeding Eng., vol. 4, no. 2, pp. 3130–3137, 2017.

E. Iswandy, D. S. T. M. I. Komputer, and S. J. Padang, “Sistem Penunjang Keputusan Untuk Menentukan Dan Santunan Sosial Anak Nagari Dan Penyaluran Bagi Mahasiswa Dan Pelajar Kurang Mampu,” J. TEKNOIF, vol. 3, no. 2, 2015.

E. Z. Henry Februariyanti, “Rancang Bangun Sistem Perpustakaan untuk Jurnal Elektronik,” J. Teknol. Inf. Din., vol. 17, no. 2, pp. 124–132, 2012.

E. W. Hidayat, “Pengembangan Sistem Manajemen Jurusan Dan Laboratorium TI Universitas Siliwangi berbasis Framework,” Semin. Nas. Apl. Teknol. Inf., vol. 2011, no. Snati, pp. 19–23, 2011.

S. Tyowati and R. Irawan, “Implementasi Framework Codeignter Untuk Pengembangan Website Pada Dinas Perkebunan Provinsi Kalimantan Tengah,” J. SAINTEKOM, vol. 7, no. 1, p. 67, 2017.

O. T. K, M. Irfan, and A. Nurpianti, “Pdf (218 Kb),” Ed. Juli 2013 Vol., vol. VII, no. 1, pp. 33–52, 2013.

S. Santoso and R. Nurmalina, “Perencanaan dan Pengembangan Aplikasi Absensi Mahasiswa Menggunakan Smart Card Guna Pengembangan Kampus Cerdas (Studi Kasus Politeknik Negeri Tanah Laut),” J. Integr., vol. 9, no. 1, pp. 84–91, 2017.

Suendri, “Implementasi Diagram UML (Unified Modelling Language) Pada Perancangan Sistem Informasi Remunerasi Dosen Dengan Database Oracle (Studi Kasus: UIN Sumatera Utara Medan),” J. Ilmu Komput. dan Inform., vol. 3, no. 1, pp. 1–9, 2018.

Haviluddin, “Memahami Penggunaan UML ( Unified Modelling Language ),” Memahami Pengguna. UML (Unified Model. Lang., vol. 6, no. 1, pp. 1–15, 2011.




DOI: https://doi.org/10.24167/sisforma.v7i2.2817

Refbacks

  • There are currently no refbacks.


Bookmark and Share


SISFORMA: Journal of Information Systems | p-ISSN: 2355-8253 | e-ISSN: 2442-7888 | View My Stats

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.