• Dec 18, 2019 News!Vol.5, No.2 has been published with online version.   [Click]
  • Jul 03, 2019 News!Vol.5, No.1 has been published with online version.   [Click]
  • Dec 20, 2018 News!Vol.4, No.2 has been published with online version.   [Click]
General Information
    • ISSN: 2382-6185
    • Abbreviated Title: Int. J. Knowl. Eng.
    • Frequency: Quarterly (2015-2016); semiyearly (Since 2017)
    • DOI: 10.18178/IJKE
    • Editor-in-Chief: Prof. Chen-Huei Chou
    • Executive Editor: Ms. Nina Lee
    • Indexed by: Google Scholar, Crossref, ProQuest
    • E-mail: ijke@ejournal.net
Editor-in-chief
Prof. Chen-Huei Chou
College of Charleston, SC, USA
It is my honor to be the editor-in-chief of IJKE. I will do my best to help develop this journal better.
IJKE 2019 Vol.5(2): 76-81 ISSN: 2382-6185
doi: 10.18178/ijke.2019.5.2.122

Improving Data Integrity within Relational Database Using Distinct Function

Eugene S. Valeriano and Rosanna A. Esquivel
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.

Copyright © 2008-2020. International Journal of Knowledge Engineering. All rights reserved.
E-mail: ijke@ejournal.net