Issue |
E3S Web Conf.
Volume 448, 2023
The 8th International Conference on Energy, Environment, Epidemiology and Information System (ICENIS 2023)
|
|
---|---|---|
Article Number | 02062 | |
Number of page(s) | 6 | |
Section | Information System | |
DOI | https://doi.org/10.1051/e3sconf/202344802062 | |
Published online | 17 November 2023 |
Master Data Management using Record Linkage Toolkit for Integrating Lecturer Master Data
1 Department of Computer Engineering, Politeknik Negeri Sriwijaya, Palembang 30139, Indonesia
2 Department of Accounting, Politeknik Negeri Sriwijaya, Palembang 30139, Indonesia
* Corresponding author: miftakul_a@polsri.ac.id
Merging databases from different data sources is one of the important tasks in the data integration process. This study will integrate lecturer data from data sources in the application of academic information systems and research information systems at the Sriwijaya State Polytechnic. This integration of lecturer data will later be used as a single data as master data that can be used by other applications. Lecturer data in the academic section contains 444 records, while those from the p3m section contain 443 records. An important task in the database merging process is to eliminate duplicate records. One of the important libraries in the formation of this master data management uses the record linkage toolkit which is implemented in the python programming language. The steps taken are pre-processing, generating candidate record pairs, compare pairs, score pairs, and finally the data link to merge the two data sources. In this study, 5 fields, namely username, name, place of birth, date of birth, and gender, from each data source were used to measure the level of record similarity. The result of this research is the formation of lecturer master data from the merging of the two sources.
© The Authors, published by EDP Sciences, 2023
This is an Open Access article distributed under the terms of the Creative Commons Attribution License 4.0, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.
Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.
Initial download of the metrics may take a while.