Volume 1 Number 3 (Sep. 2012)
Home > Archive > 2012 > Volume 1 Number 3 (Sep. 2012) >
IJCCE 2012 Vol.1(3): 262-265 ISSN: 2010-3743
DOI: 10.7763/IJCCE.2012.V1.67

A Tool for Database Testing and Optimization

Bogdan Walek and Cyril Klimeš
Abstract—The article deals with testing database against original requirements for its creation. Currently there are several tools for unit database testing, testing stored procedures and functions in database or performance and load testing of relational database. But there is no tool for testing logical model of the relational database against requirements for its creation. In the paper we propose a tool for testing logical model of the implemented database against original requirements for its creation. Proposed tool uses XML document for representation of the requiremensts and JDBC methods for loading logical model of the implemented database. Outputs of the proposed tool are tables with comparison of entities and tables, attributes and relationships. Finally, the tool generates possible database optimization proposals based on the tool´s outputs. At the end of the article proposed tool is shown on testing database of the university information system and possible optimization proposals for this database are suggested.

Index Terms—Relational database, testing, optimization, database testing.

The authors are with the Department of Informatics and Computers, University of Ostrava, Ostrava, Czech Republic (email: bogdan.walek@osu.cz,cyril.klimes@osu.cz ).


Cite: Bogdan Walek and Cyril Klimeš, "A Tool for Database Testing and Optimization," International Journal of Computer and Communication Engineering vol. 1, no. 3, pp. 262-265, 2012.

General Information

ISSN: 2010-3743 (Online)
Abbreviated Title: Int. J. Comput. Commun. Eng.
Frequency: Quarterly
Editor-in-Chief: Dr. Maode Ma
Abstracting/ Indexing: INSPEC, Google Scholar, Crossref, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcce@iap.org
  • Jun 20, 2019 News!

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

  • Sep 16, 2021 News!

    IJCCE Vol.10, No.4 is published with online version!   [Click]

  • Jun 10, 2021 News!

    IJCCE Vol.10, No.3 is published with online version!   [Click]

  • Mar 12, 2021 News!

    IJCCE Vol.10, No.2 is published with online version!   [Click]

  • Dec 09, 2020 News!

    IJCCE Vol.10, No.1 is published with online version!   [Click]

  • Read more>>