A tool for database testing and optimization
The result's identifiers
Result code in IS VaVaI
<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F61988987%3A17310%2F12%3AA13014VE" target="_blank" >RIV/61988987:17310/12:A13014VE - isvavai.cz</a>
Result on the web
—
DOI - Digital Object Identifier
—
Alternative languages
Result language
angličtina
Original language name
A tool for database testing and optimization
Original language description
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. 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 ontesting database of the university information system and possible optimization proposals for this database are suggested.
Czech name
—
Czech description
—
Classification
Type
J<sub>x</sub> - Unclassified - Peer-reviewed scientific article (Jimp, Jsc and Jost)
CEP classification
IN - Informatics
OECD FORD branch
—
Result continuities
Project
—
Continuities
S - Specificky vyzkum na vysokych skolach
Others
Publication year
2012
Confidentiality
S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů
Data specific for result type
Name of the periodical
International Journal of Computer and Communication Engineering
ISSN
2010-3743
e-ISSN
—
Volume of the periodical
1
Issue of the periodical within the volume
3
Country of publishing house
SG - SINGAPORE
Number of pages
4
Pages from-to
262-265
UT code for WoS article
—
EID of the result in the Scopus database
—