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
Frequency: Semiyearly
Editor-in-Chief: Prof. Yucong Duan
Abstracting/ Indexing: EI (INSPEC, IET), Ulrich's Periodicals Directory, Google Scholar, EBSCO, Engineering & Technology Digital Library, ProQuest, and Electronic Journals Library
E-mail: ijcee@iap.org

What's New

  • Mar 24, 2016 News!

    IJCEE Vol. 7, No. 3 has been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Aug 31, 2016 News!

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

  • Jul 19, 2016 News!

    The dois of published papers in Vol. 8, No. 3 have been validated by Crossref.

  • Jul 06, 2016 News!

    IJCEE Vol. 8, No. 3 is available online now.   [Click]

  • May 09, 2016 News!

    The dois of published papers in Vol. 8, No. 2 have been validated by Crossref.

  • Read more>>