Melola Discovery

← Melola Discovery

Journal 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) · pp. 119–129

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

Abstract

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.

Keywords

Collaboration network of the authors

10 authors · 23 co-authorship links · 6 across different organisations

Hover or tap a name to highlight its co-authors. Double-click to open the author's page.

  • Universitas Bumigora
  • Institut Shanti Bhuana
  • STMIK Palangkaraya
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
Andi Sofyan AnasUniversitas Bumigora2
FatimatuzzahraAffiliation unknown2
Nanang SamudraUniversitas Bumigora2
Veny Cahya HarditaSTMIK Palangkaraya2
M Thoric Panca MuktiUniversitas Bumigora2

Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.

Metadata source: OAI-PMH (metadata jurnal) https://ojs2.pnb.ac.id/index.php/MATRIX/oai, first harvested 19 Nov 2026, last seen 19 Nov 2026.
Original metadata (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>