Database Utilization in Embedded Software Development
Tauriainen, Emma (2023)
2023
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-202301271692
https://urn.fi/URN:NBN:fi:amk-202301271692
Tiivistelmä
The topic of this thesis was database utilization in embedded software development and it was commissioned by Nordic Semiconductor. This work was intended to develop and improve software quality and performance metrics tracking applications by implementing a database with the most suitable features into use.
To find the best choice, five different databases, two SQL-based and three NoSQL-based, were taken into comparison. The databases to be compared were selected based on their popularity and comments from the IT support of the company. When comparing them, their properties were presented and discussed in relation to the requirements of the company. For database transaction model, ACID-model was selected, which left two databases for comparison, PostgreSQL, and MS SQL Server. These two were compared by benchmarking of which MS SQL Server was selected. The database was created to the company’s server and database handler script was implemented using Python programming language. The structure of the database handler was planned and implemented to be as generic and scalable as possible. Table structure of the database was designed as efficient and clear as possible as well.
The result of this thesis was a successful entity which consisted of MS SQL Server, its handler script, and an application used to make queries to the database with. For further development a web user interface and interactive visualization web application were discussed.
To find the best choice, five different databases, two SQL-based and three NoSQL-based, were taken into comparison. The databases to be compared were selected based on their popularity and comments from the IT support of the company. When comparing them, their properties were presented and discussed in relation to the requirements of the company. For database transaction model, ACID-model was selected, which left two databases for comparison, PostgreSQL, and MS SQL Server. These two were compared by benchmarking of which MS SQL Server was selected. The database was created to the company’s server and database handler script was implemented using Python programming language. The structure of the database handler was planned and implemented to be as generic and scalable as possible. Table structure of the database was designed as efficient and clear as possible as well.
The result of this thesis was a successful entity which consisted of MS SQL Server, its handler script, and an application used to make queries to the database with. For further development a web user interface and interactive visualization web application were discussed.