Pemetaan Tabel Relationship dalam Visualisasi Diagram Relasi untuk Eksplorasi Data Pada Database

Siti Julaeha; Nunu Kustian; Dudi Parulian

doi:10.30998/string.v5i2.6653

Pemetaan Tabel Relationship dalam Visualisasi Diagram Relasi untuk Eksplorasi Data Pada Database

Siti Julaeha^(1*), Nunu Kustian⁽²⁾, Dudi Parulian⁽³⁾

(1) UNIVERSITAS INDRAPRASTA PGRI
(2) Universitas Indraprasta PGRI
(3) Universitas Indraprasta PGRI
(*) Corresponding Author

Abstract

Visualization is a tool that makes it easy to understand the information presented in charts and graphs. The purpose is to facilitate data exploration. Therefore, the authors use relationship diagrams as Mathematical Modeling to explore data that has a relationship between tables. The purpose of the study is to map the dataset, which found out a possibility that some errors when entering data. In the mapping process, we use the composition of relations, thus making the number of possible relationships in the mapping. Because of the problem, the table mapping use into a binary relationship diagram based on the number of attributes in a table. The conclusion obtained when using a binary relation diagram is that the more column in a table, the more mapping relationship diagrams must be drawn. Although the relationship diagram becomes very complex, it handled if the tables are correctly normalized.

Keywords

Visualization; Data Exploration; Relationship Diagram; Relationship Table; Database

Full Text:

PDF

References

N. A. Syaripul and A. M. Bachtiar, “Visualisasi Data Interaktif Data Terbuka Pemerintah Provinsi Dki Jakarta: Topik Ekonomi Dan Keuangan Daerah,” J. Sist. Inf., vol. 12, no. 2, p. 82, Nov. 2016.

E. W. Ambarsari, A. Ar Rakhman Awaludin, A. Suryana, P. M. Hartuti, and R. Rahim, “Basic Concept Pythagoras Tree for Construct Data Visualization On Decision Tree Learning,” J. Appl. Eng. Sci., vol. 17, no. 4, pp. 468–472, 2019.

E. W. Fridayanthie and T. Mahdiati, “Rancang Bangun Sistem Informasi Permintaan Atk Berbasis Intranet (Studi Kasus: Kejaksaan Negeri Rangkasbitung),” J. Khatulistiwa Inform., vol. 4, no. 2, pp. 126–138, 2016.

S. Khotijah, “Perancangan Database E-Learning Manajemen System untuk Pembelajaran pada Sekolah Menengah Pertama,” STRING (Satuan Tulisan Ris. dan Inov. Teknol., vol. 1, no. 1, pp. 65–73, 2016.

I. Solikhin, M. Sobri, and R. Saputra, “Sistem Informasi Pendataan Pengunjung Perpustakaan (Studi kasus : SMKN 1 Palembang),” J. Ilm. Betrik, vol. 9, no. 03, pp. 140–151, Nov. 2018.

M. Septiani, N. Afni, and R. L. Andharsaputri, “Perancangan Sistem Informasi Penyewaan Alat Berat,” JUSIM (Jurnal Sist. Inf. Musirawas), vol. 4, no. 02, pp. 127–135, 2019.

A. Aswani, N. Ransi, and R. Ramadhan, “Penerapan Operasi Himpunan Dan Fungsi Agregasi Pada Perancangan Basis Data Alumni Universitas Halu Oleo,” semanTIK, vol. 4, no. 1, pp. 7–12, May 2018.

E. W. Ambarsari and H. Herlinda, “Pythagoras Tree Applied For Determined Instagram Usage Habit Decision,” SinkrOn, vol. 4, no. 2, pp. 56–61, 2020.

L. Mukhlisulfatih, “Pendekatan Database untuk Manajemen Data dalam Meningkatkan Kemampuan Mahasiswa Mengaplikasikan Konsep Basisdata,” in Konvensi Nasional Asosiasi Pendidikan Teknologi dan Kejuruan Indonesia (APTEKINDO), 2010, pp. 231–238.

D. Puspita and Erlin, “Sistem Silsilah Keturunan Menggunakan Metode Komposisi Relasi,” SATIN - Sains dan Teknol. Inf., vol. 2, no. 2, pp. 9–16, 2013.

M. Ratuanik, “Pemahaman Siswa Kelas VIII B SMP Santo Aloysius Turi Tentang Relasi dan Fungsi Setelah Penerapan PMRI,” in PRISMA., prosiding seminar nasional matematika, 2019, vol. 2, pp. 813–820

DOI: http://dx.doi.org/10.30998/string.v5i2.6653