Skip to main content

LUP Student Papers

LUND UNIVERSITY LIBRARIES

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}},
  language     = {{eng}},
  note         = {{Student Paper}},
  series       = {{1650-2884}},
  title        = {{Optimizing Business Intelligence Extraction Speed from an ERP-System’s Database}},
  year         = {{2015}},
}