Abstract—Relational Database Management System is being used for more than decades in a variety of applications. Due to the rising issue of duplication of data via entity resolution and record linkage, there are unnecessary data that makes a mess in the relational databases. Migrating of data from different sources and Data Warehousing causing data redundancy. Data Cleaning is one of the challenges to improve the quality of data within the databases. The Restaurant Dataset of (ZAGAT and FODORS) benchmark database was utilized with the goal of facilitating the effects on improving of data, cleaning and providing data quality. A new proposed method to enhanced data cleaning and consistency without compromising record loss was developed.
Index Terms—Data cleaning, data integrity, quality, record linkage.
Eugene S. Valeriano and Rosanna A. Esquivel are with the Tarlac Agricultural University, Graduate School, Angeles University Foundation, Philippines (e-mail: esvaleriano@tau.edu.ph).
[PDF]
Cite: Eugene S. Valeriano and Rosanna A. Esquivel, "Improving Data Integrity within Relational Database Using Distinct Function," International Journal of Knowledge Engineering vol. 5, no. 2, pp. 76-81, 2019.