Melola Discovery

← Melola Discovery

Jurnal SINTA 3

Optimization of data integration using schema matching of linguistic-based and constraint-based in the university database

Matrix: Jurnal Manajemen Teknologi dan Informatika · Vol. 11 No. 3 (2021) · hlm. 119–129

DOI
10.31940/matrix.v11i3.119-129
ISSN
2580-5630, 2088-284X
Terbit
2021-11-28
Penerbit
Unit Publikasi Ilmiah, P3M, Politeknik Negeri Bali
Bahasa
eng

Abstrak

University requires the integration of data from one system with other systems as needed. This is because there are still many processes to input the same data but with different information systems. The application of data integration generally has several obstacles, one of which is due to the diversity of databases used by each information system. Schema matching is one method that can be used to overcome data integration problems caused by database diversity. The schema matching method used in this research is linguistic and constraint. The results of the matching scheme are used as material for optimizing data integration at the database level. The optimization process shows a change in the number of tables and attributes in the database that is a decrease in the number of tables by 13 tables and 492 attributes. The changes were caused by some tables and attributes were omitted and normalized. This research shows that after optimization, data integration becomes better because the data was connected and used by other systems has increased by 46.67% from the previous amount. This causes the same data entry on different systems can be reduced and also data inconsistencies caused by duplication of data on different systems can be minimized.

Kata kunci

Jaringan kolaborasi para penulis

10 penulis · 23 tautan kepenulisan bersama · 6 lintas organisasi

Arahkan kursor atau ketuk sebuah nama untuk menyorot rekan penulisnya. Klik dua kali untuk membuka halaman penulis.

  • Universitas Bumigora
  • Institut Shanti Bhuana
  • STMIK Palangkaraya
  • Afiliasi tidak diketahui
  • Organisasi berbeda
  • Organisasi sama
  • Afiliasi tidak diketahui
  • Garis lebih tebal = lebih banyak artikel bersama · lingkaran lebih besar = lebih banyak artikel
Tampilkan sebagai tabel
Rekan penulisOrganisasiArtikel bersama
Andi Sofyan AnasUniversitas Bumigora2
FatimatuzzahraAfiliasi tidak diketahui2
Nanang SamudraUniversitas Bumigora2
Veny Cahya HarditaSTMIK Palangkaraya2
M Thoric Panca MuktiUniversitas Bumigora2

Afiliasi berasal dari OpenAlex; metadata OAI-PMH jurnal tidak memuatnya. Penulis tanpa ID OpenAlex dicocokkan berdasarkan nama, sehingga dua orang bisa tergabung atau satu orang bisa terpisah.

Sumber metadata: OAI-PMH (metadata jurnal) https://ojs2.pnb.ac.id/index.php/MATRIX/oai, pertama di-harvest 19 Nov 2026, terakhir terlihat 19 Nov 2026.
Metadata asli (oai_dc)
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/  http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
	<dc:title xml:lang="en-US">Optimization of data integration using schema matching of  linguistic-based and constraint-based in the university  database</dc:title>
	<dc:creator>Rifqi Hammad</dc:creator>
	<dc:creator>Azriel Christian Nurcahyo</dc:creator>
	<dc:creator>Ahmad Zuli Amrullah</dc:creator>
	<dc:creator>Pahrul Irfan</dc:creator>
	<dc:creator>Kurniadin Abd. Latif</dc:creator>
	<dc:subject xml:lang="en-US">university</dc:subject>
	<dc:subject xml:lang="en-US">data integration</dc:subject>
	<dc:subject xml:lang="en-US">schema matching</dc:subject>
	<dc:subject xml:lang="en-US">linguistic</dc:subject>
	<dc:subject xml:lang="en-US">constraint</dc:subject>
	<dc:description xml:lang="en-US">University requires the integration of data from one system with other systems as needed. This is because there are still many processes to input the same data but with different information systems. The application of data integration generally has several obstacles, one of which is due to the diversity of databases used by each information system. Schema matching is one method that can be used to overcome data integration problems caused by database diversity. The schema matching method used in this research is linguistic and constraint. The results of the matching scheme are used as material for optimizing data integration at the database level. The optimization process shows a change in the number of tables and attributes in the database that is a decrease in the number of tables by 13 tables and 492 attributes. The changes were caused by some tables and attributes were omitted and normalized. This research shows that after optimization, data integration becomes better because the data was connected and used by other systems has increased by 46.67% from the previous amount. This causes the same data entry on different systems can be reduced and also data inconsistencies caused by duplication of data on different systems can be minimized.</dc:description>
	<dc:publisher xml:lang="en-US">Unit Publikasi Ilmiah, P3M, Politeknik Negeri Bali</dc:publisher>
	<dc:date>2021-11-28</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:type xml:lang="en-US">Peer-reviewed Article</dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://ojs2.pnb.ac.id/index.php/MATRIX/article/view/38</dc:identifier>
	<dc:identifier>10.31940/matrix.v11i3.119-129</dc:identifier>
	<dc:source xml:lang="en-US">Matrix : Jurnal Manajemen Teknologi dan Informatika; Vol. 11 No. 3 (2021): Matrix: Jurnal Manajemen Teknologi dan Informatika; 119-129</dc:source>
	<dc:source>2580-5630</dc:source>
	<dc:source>2088-284X</dc:source>
	<dc:source>10.31940/matrix.v11i3</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://ojs2.pnb.ac.id/index.php/MATRIX/article/view/38/30</dc:relation>
	<dc:relation>10.62960/dmmmsu.v6i.31.g30</dc:relation>
	<dc:rights xml:lang="en-US">Copyright (c) 2021 Matrix : Jurnal Manajemen Teknologi dan Informatika</dc:rights>
	<dc:rights xml:lang="en-US">https://scholar.google.co.id/citations?user=NDE5gXYAAAAJ&amp;hl=id</dc:rights>
</oai_dc:dc>