• Jan 04, 2024 News!IJKE will adopt Article-by-Article Work Flow. For the Biannually journal, each issue will be released at the end of the issue month.
  • Nov 28, 2023 News!Vol.9, No.2 has been published with online version.   [Click]
  • Jun 06, 2023 News!Vol.9, No.1 has been published with online version.   [Click]
General Information
    • ISSN: 2382-6185
    • Abbreviated Title: Int. J. Knowl. Eng.
    • Frequency: Semiyearly
    • DOI: 10.18178/IJKE
    • Editor-in-Chief: Prof. Chen-Huei Chou
    • Executive Editor: Ms. Shira,W.Lu
    • Indexed by: Google Scholar, Crossref, ProQuest
    • E-mail: ijke@ejournal.net
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
doi: 10.18178/ijke.2019.5.2.122

Improving Data Integrity within Relational Database Using Distinct Function

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).


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-2024   International Journal of Knowledge Engineering. All rights reserved.
E-mail: ijke@ejournal.net