University of Oulu

Designing, implementing and evaluating a database for a software testing team

Saved in:
Author: Matinolli, Ilari1
Organizations: 1University of Oulu, Faculty of Information Technology and Electrical Engineering, Department of Information Processing Science, Information Processing Science
Format: ebook
Version: published version
Access: open
Online Access: PDF Full Text (PDF, 1.8 MB)
Persistent link: http://urn.fi/URN:NBN:fi:oulu-201612033204
Language: English
Published: Oulu : I. Matinolli, 2016
Publish Date: 2016-12-07
Physical Description: 82 p.
Thesis type: Master's thesis
Tutor: Mäntylä, Mika
Reviewer: Siirtola, Antti
Mäntylä, Mika
Description:

Abstract

Databases have existed since 1960s. Relational databases came out in 1970s and they have been the most popular database technology ever since. However, non-relational databases came out in 2000s and have gathered popularity since then. This thesis studied different open-source database management systems including relational and non-relational systems. Prompt looks into data analytics and distributed databases were also taken.

The main purpose of this study was to design, implement and evaluate a new database for the needs of a software testing team. In order to do that it was needed to find out a database management system that met the requirements best given by the case company. It was also needed to find out which database design principles and techniques should be followed to achieve a well-performing and easily maintainable database.

After studying different database management system, MySQL was chosen for the database management system and a new database was designed, implemented and evaluated. It turned out that MySQL is still a relevant and successful database management system to meet the needs of a modern software testing team when optimization techniques such as indexing and normalization are applied.

In the future it would be beneficial to study how a non-relational database management system could be combined with a relational database management system to meet the needs of different software testing teams.

see all

Subjects:
Copyright information: © Ilari Matinolli, 2016. This publication is copyrighted. You may download, display and print it for your own personal use. Commercial use is prohibited.