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, CNKI, Google Scholar, Crossref, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcce@iap.org
  • Dec 29, 2021 News!

    IJCCE Vol. 10, No. 1 - Vol. 10, No. 2 have been indexed by Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Mar 17, 2022 News!

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

  • Dec 29, 2021 News!

    The dois of published papers in Vol. 9, No. 3 - Vol. 10, No. 4 have been validated by Crossref.

  • Dec 29, 2021 News!

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

  • Sep 16, 2021 News!

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

  • Read more>>