PENGEMBANGAN BASIS DATA SISTEM INFORMASI AKADEMIK PERGURUAN TINGGI BERBASIS SCHEMA MATCHING LINGUISTIC, CONSTRAINT DAN INSTANCE

Authors

  • Pahrul Irfan Universitas Bumigora Mataram
  • Rifqi Hammad Universitas Bumigora Mataram
  • Naufal Rifqi Zuhrian Universitas Bumigora Mataram
  • Anjas Ardiyan Azhari Universitas Bumigora Mataram

DOI:

https://doi.org/10.33020/saintekom.v12i2.279

Keywords:

University, Schema Matching, Linguistic, Constrain, Instances

Abstract

Universities currently need information systems to support their activities. Bumigora University is one of the universities that implements information systems such as Siska and E-Learning. Both the system and the database of the two systems are still independent. So that the same data input is still happening on different systems. Based on these problems, it is necessary to develop a database that can connect information from Siska and E-Learning. The method used in this research is Schema Matching. The Schema Matching method used is the Linguistic, Constraint, and Instance Schema Matching method. The results showed that there were several table pairs with true positive and false positive values so that the precision, recall, and F-measure values obtained were 0.8, 1, and 0.89. The F-measure value obtained is 0.89 which is greater than 0.5 so it can be said that the scheme matching process is running quite well.

Downloads

Download data is not yet available.

References

Alwan, A. A., Nordin, A., Lumpur, K., Alzeber, M. M., Abedallah, M., & Abualkishik, Z. (2017). A Survey of Schema Matching Research using Database Schemas and Instances. (IJACSA) International Journal of Advanced Computer Science and Applications, 8(10), 102–111. www.ijacsa.thesai.org

Aswati, S., Mulyani, N., Siagian, Y., & Syah, A. Z. (2015). Peranan Sistem Informasi Dalam Perguruan Tinggi. Jurnal Teknologi Dan Sistem Informasi, 1(2), 79–86.

Bellahsene, Z., Bonifati, A., & Rahm, E. (2011). Schema Matching and Mapping, Data-Centric Systems and Applications. Springe.

Hammad, R., Nurcahyo, A. C., Amrullah, A. Z., Irfan, P., & Latif, K. A. (2021). Optimization of data integration using schema matching of linguistic-based and constraint-based in the university database. Jurnal Manajemen Teknologi Dan Informatik, 11(3), 119–129.

Hammad, R., Utami, E., & Raharjo, S. (2019). Analisis Integrasi Data Pada Relasional Basis Data Dengan Menggunakan Metode Schema Matching. 9(1), 1–14.

Homaidi, A. (2016). Sistem Informasi Akademik AMIK IBRAHIMY Berbasis Web. Jurnal Imiah Informatika, 1(1), 17–23.

Martono, G. H., & SN, A. (2017). Review Implementation of Linguistic Approach in Schema Matching. International Journal of Advances in Intelligent Informatics, 3(1), 1. https://doi.org/10.26555/ijain.v3i1.75

Mehdi, O. A., Ibrahim, H., & Affendey, L. S. (2014). Instance Based Schema Matching Framework Utilizing Google Similarity and Regular Expression. Proceedings of 3rd International Conference on Data Management Technologies and Applications, 213–222.

Murtadho, M. A., & Wahid, F. (2016). Permasalahan Implementasi Sistem Informasi Di Perguruan Tinggi Swasta. Register: Jurnal Ilmiah Teknologi Sistem Informasi, 2(1), 17–21. http://www.journal.unipdu.ac.id/index.php/register/article/view/441

Permanasari, A. E., Satyaprabha, H. P., Suwastono, A., & Mulyani, G. T. (2019). Pengembangan Basis Data Sistem Informasi Manajemen Rumah Sakit Berbasis Linguistic-based Schema Matching. Jurnal Nasional Teknik Elektro Dan Teknologi Informasi Universitas Gadjah Mada, 8(2), 101–106.

Sahay, T., Mehta, A., & Jadon, S. (2020). Schema Matching using Machine Learning. 7th International Conference on Signal Processing and Integrated Networks (SPIN), 359–366. https://doi.org/10.1109/SPIN48934.2020.9071272.

Sutanta, E., Nurnawati, E. K., & Kumalasanti, R. A. (2019). The Mathematical Model of Hybrid Schema Matching based on Constraints and Instances Similarity. (IJACSA) International Journal of Advanced Computer Science and Applications, 10(6), 459–464.

Downloads

PlumX Metrics

Published

30-09-2022

How to Cite

Irfan, Pahrul, Rifqi Hammad, Naufal Rifqi Zuhrian, and Anjas Ardiyan Azhari. 2022. “PENGEMBANGAN BASIS DATA SISTEM INFORMASI AKADEMIK PERGURUAN TINGGI BERBASIS SCHEMA MATCHING LINGUISTIC, CONSTRAINT DAN INSTANCE”. Jurnal Saintekom : Sains, Teknologi, Komputer Dan Manajemen 12 (2):115-25. https://doi.org/10.33020/saintekom.v12i2.279.

Issue

Vol. 12 No. 2 (2022): September 2022

Section

Articles

License

Copyright (c) 2022 Pahrul Irfan, Rifqi Hammad, Naufal Rifqi Zuhrian, Anjas Ardiyan Azhari

Creative Commons License

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

Copyright :
By submitting manuscripts to Jurnal Saintekom : Sains, Teknologi, Komputer dan Manajemen, the author agrees with this policy. No specific document approval is required.

  1. The copyright in each article belongs to the author.
  2. Authors retain all their rights to the published work, not limited to the rights set forth in this page.
  3. Authors acknowledge that Saintekom Journal: Science, Technology, Computers and Management as the first to publish under the Creative Commons Attribution 4.0 International license (CC BY-SA).
  4. The author may submit the paper separately, arrange for non-exclusive distribution of the manuscript that has been published in this journal into other versions (e.g. sent to the author's institutional respository, publication into a book, etc.), by acknowledging that the manuscript has been first published Jurnal Saintekom : Sains, Teknologi, Komputer dan Manajemen;
  5. The author warrants that the article is original, written by the named author, has not been previously published, contains no unlawful statements, does not infringe the rights of others, is subject to copyright exclusively held by the author.
  6. If the article is jointly prepared by more than one author, each author submitting the manuscript warrants that he or she has been authorized by all co-authors to agree to copyright and license notices (agreements) on their behalf, and agrees to inform co-authors of the terms of this policy. Jurnal Saintekom : Sains, Teknologi, Komputer dan Manajemen will not be held liable for anything that may arise due to internal author disputes.

Lisensi :
Jurnal Saintekom : Sains, Teknologi, Komputer dan Manajemen  is published under the terms of the Creative Commons Attribution 4.0 International License (CC BY-SA). This license permits anyone to:.

  1. Share - copy and redistribute this material in any form or format;
  2. Adaptation - modify, alter, and create derivatives of this material for any purpose.
  3. Attribution - you must give appropriate credit, include a link to the license, and state that changes have been made. You may do this in any appropriate manner, but it does not imply that the licensor endorses you or your use.
  4. Similar Sharing - If you modify, alter, or create a derivative of this material, you must distribute your contribution under the same license as the original material.