Advanced

Optimizing Business Intelligence Extraction Speed from an ERP-System’s Database

Söderberg, Alexander LU and Åberg, Max LU (2015) In 1650-2884 EDA920 20151
Department of Computer Science
Abstract
The popularity of cloud-based applications has increased the importance of performance optimized databases. In this thesis the database for a cloud-based ERP-system called BeX®Online is investigated with the goal to optimize the generation speed of reports in the business intelligence functionality in the case system. The result is a set of recommended solutions to bottlenecks and inefficiencies found during the analysis, as well as suggestions for architectural improvements. Improvements to the generation speed of the business intelli- gence reports could be made in query tuning, index fragmentation, mainte- nance planning and table partitioning. Although database optimization is a widely researched subject it remains a complex and time... (More)
The popularity of cloud-based applications has increased the importance of performance optimized databases. In this thesis the database for a cloud-based ERP-system called BeX®Online is investigated with the goal to optimize the generation speed of reports in the business intelligence functionality in the case system. The result is a set of recommended solutions to bottlenecks and inefficiencies found during the analysis, as well as suggestions for architectural improvements. Improvements to the generation speed of the business intelli- gence reports could be made in query tuning, index fragmentation, mainte- nance planning and table partitioning. Although database optimization is a widely researched subject it remains a complex and time consuming process, and the thesis concludes with a recommendation of areas that need to be fur- ther investigated. (Less)
Please use this url to cite or link to this publication:
author
Söderberg, Alexander LU and Åberg, Max LU
supervisor
organization
alternative title
Processoptimering av nyckeltalsskapande från affärssystemdatabas
course
EDA920 20151
year
type
H3 - Professional qualifications (4 Years - )
subject
keywords
MsSQL, ERP, BI-report, query tuning, index
publication/series
1650-2884
report number
LU-CS-EX 2015-18
ISSN
1650-2884
language
English
id
5471848
date added to LUP
2015-06-11 11:54:56
date last changed
2015-06-11 11:54:56
@misc{5471848,
  abstract     = {The popularity of cloud-based applications has increased the importance of performance optimized databases. In this thesis the database for a cloud-based ERP-system called BeX®Online is investigated with the goal to optimize the generation speed of reports in the business intelligence functionality in the case system. The result is a set of recommended solutions to bottlenecks and inefficiencies found during the analysis, as well as suggestions for architectural improvements. Improvements to the generation speed of the business intelli- gence reports could be made in query tuning, index fragmentation, mainte- nance planning and table partitioning. Although database optimization is a widely researched subject it remains a complex and time consuming process, and the thesis concludes with a recommendation of areas that need to be fur- ther investigated.},
  author       = {Söderberg, Alexander and Åberg, Max},
  issn         = {1650-2884},
  keyword      = {MsSQL,ERP,BI-report,query tuning,index},
  language     = {eng},
  note         = {Student Paper},
  series       = {1650-2884},
  title        = {Optimizing Business Intelligence Extraction Speed from an ERP-System’s Database},
  year         = {2015},
}