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
- 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-author | Organisation | Joint articles |
|---|---|---|
| Andi Sofyan Anas | Universitas Bumigora | 2 |
| Fatimatuzzahra | Affiliation unknown | 2 |
| Nanang Samudra | Universitas Bumigora | 2 |
| Veny Cahya Hardita | STMIK Palangkaraya | 2 |
| M Thoric Panca Mukti | Universitas Bumigora | 2 |
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.