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