Volume 6 Number 4 (Aug. 2014)
Home > Archive > 2014 > Volume 6 Number 4 (Aug. 2014) >
IJCEE 2014 Vol.6(4): 365-368 ISSN: 1793-8163
DOI: 10.7763/IJCEE.2014.V6.854

AutoTest: Automation to Test Tabular Data Quality

Süleyman Eken, Ahmet Sayar, and Kürşat Topçuoğlu
Abstract—Data can take various forms and types such as numbers, symbols, words, images, and graphics. All these data are significant resources in companies’ operating process. So, if data has any quality problems (e.g. poor schema design, data entry errors, misspelling, inconsistency, and etc.), it will very risky for companies. On the other hand, high quality data can increase opportunities dependent on performance issues. This study introduces an automation tool enabling data quality tests of data warehouse applications. Also with this tool, historical changes of a dataset are analyzed with linear regression algorithm and, thus, outlier variables of data trend are reported to application users. The efficiency of the proposed automation tool is also tested and results are evaluated.

Index Terms—Data quality, data integrity, test automation, data warehouse, data statistics, data filtering.

Süleyman Eken and Ahmet Sayar are with Kocaeli University, Department of Computer Engineering, Kocaeli, Turkey (e-mail: suleyman.eken@kocaeli.edu.tr; ahmet.sayar@kocaeli.edu.tr).
Kürşat Topçuoğlu is with Turkcell Technology R&D, Kocaeli, Turkey (e-mail: kursattopcuoglu@gmail.com).

Cite:Süleyman Eken, Ahmet Sayar, and Kürşat Topçuoğlu, "AutoTest: Automation to Test Tabular Data Quality," International Journal of Computer and Electrical Engineering vol. 6, no. 4, pp. 365-368, 2014.

General Information

ISSN: 1793-8163 (Print)
Abbreviated Title: Int. J. Comput. Electr. Eng.
Frequency: Quarterly
Editor-in-Chief: Prof. Yucong Duan
Abstracting/ Indexing: INSPEC, Ulrich's Periodicals Directory, Google Scholar, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcee@iap.org

What's New

  • Jun 03, 2019 News!

    IJCEE Vol. 9, No. 2 - Vol. 10, No. 2 have been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • May 13, 2020 News!

    IJCEE Vol 12, No 2 is available online now   [Click]

  • Mar 04, 2020 News!

    IJCEE Vol 12, No 1 is available online now   [Click]

  • Dec 11, 2019 News!

    The dois of published papers in Vol 11, No 4 have been validated by Crossref

  • Oct 11, 2019 News!

    IJCEE Vol 11, No 4 is available online now   [Click]

  • Read more>>