Database architecture design and performance evaluation for Quality of Service measurements: Master's thesis

Pekka Ruottinen

Research output: ThesisMaster's thesisTheses

Abstract

Measuring and analysing the quality of experience and the quality of service are important assisting methods when optimizing network capacity, and providing the best possible user experience. They also present methods for finding and dealing with problems caused by the ever-growing internet data traffic and its number of users. Qosmet, developed at VTT Technical Research Centre of Finland Ltd, is a powerful solution for this type of network analysis. Considering that long term storage of quality of service measurement data is all numerical, this enables an efficient and well optimised database solution, one that performs well in either writing data or reading it for analysis. The purpose of this thesis is to ascertain the optimal database architecture for quality of service measurements. An important outcome of this project is the interface between Qosmet and the implemented database. Part of the work consists also in identifying the characteristics for database optimization. In order to achieve these goals, three database architecture schemas were designed and analysed with the help of exhaustive writing and reading performance tests. Schema 1 has one, schema 2 two and schema 3 have respectively three database tables, in which the data is distributed according to its assumed frequency of use. Following the analysis and comparison of these three database architecture schemas, the one with two tables appeared to be the best one. It achieved writing throughput of around 7,500 lines per second, and the reading performance was the second best, actually very close to the best performance. Schemas 1 and 2 were about 33 percent faster than schema 3 in writing performance. Schemas 2 and 3 performed about 20 percent better than schema 1 in reading tests. Performance analysis gave a good understanding of database optimization and features affecting its efficiency, as well as hardware requirements, bottlenecks and limits on high utilization situations. This work resulted in an efficient and verified database, which can be used in the future as part of the Qosmet solution.
Original languageEnglish
QualificationMaster Degree
Awarding Institution
  • University of Oulu
Supervisors/Advisors
  • Katz, Marcos, Supervisor, External person
  • Röning, Juha, Advisor, External person
Place of PublicationOulu
Publisher
Publication statusPublished - 2015
MoE publication typeG2 Master's thesis, polytechnic Master's thesis

Fingerprint

Quality of service
Electric network analysis
Throughput
Internet
Hardware

Keywords

  • database
  • DBMS
  • MySQL
  • optimization
  • qosmet
  • quality of service

Cite this

@phdthesis{f0e1c5fb658b44c4a7c6de5eeea14067,
title = "Database architecture design and performance evaluation for Quality of Service measurements: Master's thesis",
abstract = "Measuring and analysing the quality of experience and the quality of service are important assisting methods when optimizing network capacity, and providing the best possible user experience. They also present methods for finding and dealing with problems caused by the ever-growing internet data traffic and its number of users. Qosmet, developed at VTT Technical Research Centre of Finland Ltd, is a powerful solution for this type of network analysis. Considering that long term storage of quality of service measurement data is all numerical, this enables an efficient and well optimised database solution, one that performs well in either writing data or reading it for analysis. The purpose of this thesis is to ascertain the optimal database architecture for quality of service measurements. An important outcome of this project is the interface between Qosmet and the implemented database. Part of the work consists also in identifying the characteristics for database optimization. In order to achieve these goals, three database architecture schemas were designed and analysed with the help of exhaustive writing and reading performance tests. Schema 1 has one, schema 2 two and schema 3 have respectively three database tables, in which the data is distributed according to its assumed frequency of use. Following the analysis and comparison of these three database architecture schemas, the one with two tables appeared to be the best one. It achieved writing throughput of around 7,500 lines per second, and the reading performance was the second best, actually very close to the best performance. Schemas 1 and 2 were about 33 percent faster than schema 3 in writing performance. Schemas 2 and 3 performed about 20 percent better than schema 1 in reading tests. Performance analysis gave a good understanding of database optimization and features affecting its efficiency, as well as hardware requirements, bottlenecks and limits on high utilization situations. This work resulted in an efficient and verified database, which can be used in the future as part of the Qosmet solution.",
keywords = "database, DBMS, MySQL, optimization, qosmet, quality of service",
author = "Pekka Ruottinen",
note = "BA1146 Project code: 75001 Project code: 83978 Project code: 72815",
year = "2015",
language = "English",
publisher = "University of Oulu",
address = "Finland",
school = "University of Oulu",

}

Database architecture design and performance evaluation for Quality of Service measurements : Master's thesis. / Ruottinen, Pekka.

Oulu : University of Oulu, 2015. 54 p.

Research output: ThesisMaster's thesisTheses

TY - THES

T1 - Database architecture design and performance evaluation for Quality of Service measurements

T2 - Master's thesis

AU - Ruottinen, Pekka

N1 - BA1146 Project code: 75001 Project code: 83978 Project code: 72815

PY - 2015

Y1 - 2015

N2 - Measuring and analysing the quality of experience and the quality of service are important assisting methods when optimizing network capacity, and providing the best possible user experience. They also present methods for finding and dealing with problems caused by the ever-growing internet data traffic and its number of users. Qosmet, developed at VTT Technical Research Centre of Finland Ltd, is a powerful solution for this type of network analysis. Considering that long term storage of quality of service measurement data is all numerical, this enables an efficient and well optimised database solution, one that performs well in either writing data or reading it for analysis. The purpose of this thesis is to ascertain the optimal database architecture for quality of service measurements. An important outcome of this project is the interface between Qosmet and the implemented database. Part of the work consists also in identifying the characteristics for database optimization. In order to achieve these goals, three database architecture schemas were designed and analysed with the help of exhaustive writing and reading performance tests. Schema 1 has one, schema 2 two and schema 3 have respectively three database tables, in which the data is distributed according to its assumed frequency of use. Following the analysis and comparison of these three database architecture schemas, the one with two tables appeared to be the best one. It achieved writing throughput of around 7,500 lines per second, and the reading performance was the second best, actually very close to the best performance. Schemas 1 and 2 were about 33 percent faster than schema 3 in writing performance. Schemas 2 and 3 performed about 20 percent better than schema 1 in reading tests. Performance analysis gave a good understanding of database optimization and features affecting its efficiency, as well as hardware requirements, bottlenecks and limits on high utilization situations. This work resulted in an efficient and verified database, which can be used in the future as part of the Qosmet solution.

AB - Measuring and analysing the quality of experience and the quality of service are important assisting methods when optimizing network capacity, and providing the best possible user experience. They also present methods for finding and dealing with problems caused by the ever-growing internet data traffic and its number of users. Qosmet, developed at VTT Technical Research Centre of Finland Ltd, is a powerful solution for this type of network analysis. Considering that long term storage of quality of service measurement data is all numerical, this enables an efficient and well optimised database solution, one that performs well in either writing data or reading it for analysis. The purpose of this thesis is to ascertain the optimal database architecture for quality of service measurements. An important outcome of this project is the interface between Qosmet and the implemented database. Part of the work consists also in identifying the characteristics for database optimization. In order to achieve these goals, three database architecture schemas were designed and analysed with the help of exhaustive writing and reading performance tests. Schema 1 has one, schema 2 two and schema 3 have respectively three database tables, in which the data is distributed according to its assumed frequency of use. Following the analysis and comparison of these three database architecture schemas, the one with two tables appeared to be the best one. It achieved writing throughput of around 7,500 lines per second, and the reading performance was the second best, actually very close to the best performance. Schemas 1 and 2 were about 33 percent faster than schema 3 in writing performance. Schemas 2 and 3 performed about 20 percent better than schema 1 in reading tests. Performance analysis gave a good understanding of database optimization and features affecting its efficiency, as well as hardware requirements, bottlenecks and limits on high utilization situations. This work resulted in an efficient and verified database, which can be used in the future as part of the Qosmet solution.

KW - database

KW - DBMS

KW - MySQL

KW - optimization

KW - qosmet

KW - quality of service

M3 - Master's thesis

PB - University of Oulu

CY - Oulu

ER -