AUTOMATIC ERROR DETECTING IN DATABASES, BASED ON CLUSTERING AND NEAREST NEIGHBOR

Q: How can I download an article?

To download an article from SID, first log in to the site, search for the article title, and click on the 'Download Article' option.

Q: How can I download an ISI article?

To download an ISI article on SID, enter the keyword or article title in the search bar, view the relevant results, click on the desired article, and select the 'Download Article' option.

Q: How can I access the SID database?

To access the SID database, visit SID.ir, create an account, and log in to access scientific resources.

Q: Is downloading articles from SID free?

Some articles on SID are available for free, while others require payment. Details are specified on the article's page.

ATAEYAN M.; DANESHPOUR N.

مرکز اطلاعات علمی Scientific Information Database (SID) - Trusted Source for Research and Academic Resources

Journal Paper

Paper Information

Journal: NASHRIYYAH -I MUHANDISI -I BARQ VA MUHANDISI -I KAMPYUTAR -I IRAN, B- MUHANDISI -I KAMPYUTAR Year:2017 | Volume:14 | Issue:4 Page(s): 349-356

Download Full-Text

Persian Verion

View:

1,157

Download:

Cites:

Information Journal Paper

Title

AUTOMATIC ERROR DETECTING IN DATABASES, BASED ON CLUSTERING AND NEAREST NEIGHBOR

Author(s)

ATAEYAN M. | DANESHPOUR N. | Issue Writer Certificate

Keywords

DATA CLEANINGQ2

AUTOMATIC ERROR DETECTIONQ2

CLUSTERINGQ2

K-MEANSQ2

Abstract

Data quality affects on companies decision making, so that decisions based on data without quality incur companies high costs. Data quality has various dimensions and accuracy is the most important of these dimensions. Error detection is needed for DATA CLEANING. Due to the huge volume of data, an automatic system is needed to perform this process without user interaction. In this paper an approach is proposed based on K-MEANS CLUSTERING for error detection. Firstly data are clustered for each attribute. Then for each data in each cluster a method similar to k-nearest neighbor is used for detecting errors. The proposed method is able to detect multiple errors in one record. Also this approach is able to detect errors in fields with various attribute types. Experimental results show that this approach can detect 91% of errors in data on average. Also the proposed approach is compared with an automatic method which detects errors based on rule in various attribute types. Experimental results show that the proposed approach has on average 25%better performance to detect errors.

Cites

No record.

References

SAMPLING FROM REPAIRS OF CONDITIONAL FUNCTIONAL DEPENDENCY VIOLATIONS

Cite

APA: Copy

ATAEYAN, M., & DANESHPOUR, N.. (2017). AUTOMATIC ERROR DETECTING IN DATABASES, BASED ON CLUSTERING AND NEAREST NEIGHBOR. NASHRIYYAH -I MUHANDISI -I BARQ VA MUHANDISI -I KAMPYUTAR -I IRAN, B- MUHANDISI -I KAMPYUTAR, 14(4), 349-356. SID. https://sid.ir/paper/228503/en

Vancouver: Copy

ATAEYAN M., DANESHPOUR N.. AUTOMATIC ERROR DETECTING IN DATABASES, BASED ON CLUSTERING AND NEAREST NEIGHBOR. NASHRIYYAH -I MUHANDISI -I BARQ VA MUHANDISI -I KAMPYUTAR -I IRAN, B- MUHANDISI -I KAMPYUTAR[Internet]. 2017;14(4):349-356. Available from: https://sid.ir/paper/228503/en

IEEE: Copy

M. ATAEYAN, and N. DANESHPOUR, “AUTOMATIC ERROR DETECTING IN DATABASES, BASED ON CLUSTERING AND NEAREST NEIGHBOR,” NASHRIYYAH -I MUHANDISI -I BARQ VA MUHANDISI -I KAMPYUTAR -I IRAN, B- MUHANDISI -I KAMPYUTAR, vol. 14, no. 4, pp. 349–356, 2017, [Online]. Available: https://sid.ir/paper/228503/en

Related Journal Papers