Presentation of thesis work basic level:

Evaluating Erlang database structures for building statistics in telecommunications

- Comparing non-relational and relational databases in Mnesia

LOU JÖNSSON

ANTON PTITSIN

Date: June 18th  2021, kl 13-14

Place: zoom Meeting ID: 650 3389 3703
https://kth-se.zoom.us/j/65033893703

Opponents: Oscar Persson and August Henning Bruce

Supervisor: Johan Montelius

Examiner: Thomas Sjöland

School of Electrical Engineering and Computer Science

Host company: Mobile Arts AB

Swedish title: Utvärdering av databasstrukturer i Erlang för att bygga statistik inom telekommunikation

Swedish subtitle: Jämförelse av icke-relations- och relations-databaser i Mnesia

Active listeners can participate without prior registration.

Abstract in english

Mobile subscriptions are steadily increasing, making it more relevant to collect data and make useful statistics. To handle these large data sets, robust databases must be built. Two important factors for databases are storing the information persistently and having an adequate read and write speed to the database. This thesis project will study two different database structures and implementations to fulfill these factors. The system will be written in the database management system Mnesia in the programming language Erlang. This study was conducted at Mobile Arts AB in Stockholm, Sweden. The company requested a file processor together with a script interpreter with a query language used to build relevant statistics. Large amounts of data should be processed through the file processor and stored in a database efficiently. A system based on two different database structures was built and compared to achieve the most efficient system among the two database structures. To measure the performance of the system and to compare the database structures, benchmarks were executed to determine the most efficient method. The results show that the non-relational database has a faster input processing speed compared to the relational one, while the relational database structure was faster in output processing. The conclusion is that the non-relational database works better for the system of this thesis project.

Keywords

Erlang, Mnesia, Data processing, Database models, Statistics