Examensarbeten och uppsatser / Final Theses
Framläggningar på IDA / Presentations at IDA
Se även framläggningar annonserade hos ISY och ITN i Norrköping / See also presentations announced at ISY and ITN in Norrköping (in Swedish)
If nothing is stated about the presentation language then the presentation is in Swedish.
WExUpp - kommande framläggningar
| 2024-05-16 - ADIT |
Analys, design och utvärdering av databasscheman i Azure Data Explorer
Angelica Ferlin, Linn Petersson
Avancerad (30hp)
kl 13:00, Babbage (In English)
[Abstract]Data warehouses are today used to store large amounts of data. This thesis investigates the impact different database schema designs have on query execution time within the cloud platform Azure Data Explorer. It is a relatively new platform, and limited research exists on how the database schema should be designed in Azure Data Explorer. Further, the design of the database schema has a direct impact on the query execution times. The design should also align with the use case of the data warehouse. This thesis conducts a requirements analysis, determines the use case, and designs three database schemas. The three database schemas are implemented and evaluated through a performance test. Schema 1 is designed utilizing results tables from stored functions, while schema 2 utilizes sub-functions divided by different departments or products aimed to minimize the data accessed per query. Finally, schema 3 uses the results tables from the sub-functions found in schema 2. The conclusion from the performance test shows that schema 3 has the best overall improvement in terms of query execution time compared to the other designs and the original design. The findings emphasize the critical role of database schema design in influencing query performance. Additionally, a conclusion is drawn that using more than one approach to enhance query performance is increasing the potential query performance. |
Page responsible: Final Thesis Coordinator
Last updated: 2022-06-03
Swedish web site
