Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Integration of an In-Memory Column-Oriented Database Engine as Back-End of a BI Application
KTH, School of Information and Communication Technology (ICT).
2014 (English)Independent thesis Advanced level (professional degree), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

The benefits of Business Intelligence (BI) activities are widely recognized and arouse more and more interest nowadays. In particular, self-service analytics is getting more and more popular. Enabling end users to process their data by themselves allow them to be more reactive to business changes by making better decisions faster. One of the challenges in this area is to provide tools easy to use with a high computational performance to enable end users who often aren’t developers to process their data by themselves in a simple and fast manner. The BI application that we will call BITX belongs to that category.

This thesis presents the integration of an in-memory columnoriented database engine that we will call DBEX as backend for this application. The purpose of this experiment is to optimize BITX’s performance by providing it with a lightweight back-end well adapted to BI analysis. The architecture and implementation of the driver developed for DBEX are detailed. The query execution mechanism and SQL functions representation in the engine are studied and performance optimizations for SQL functions implementation are proposed. The system performance is then analyzed following two axis: DBEX’s memory consumption and the respone time of the subsystem {DBEX+driver}.

Improvements made further to the performance evaluation

and speeding up some of the driver’s operations are presented.

Place, publisher, year, edition, pages
2014. , 70 p.
Series
TRITA-ICT-EX, 2014:101
National Category
Computer and Information Science
Identifiers
URN: urn:nbn:se:kth:diva-177204OAI: oai:DiVA.org:kth-177204DiVA: diva2:872000
Examiners
Available from: 2015-12-08 Created: 2015-11-17 Last updated: 2017-07-31Bibliographically approved

Open Access in DiVA

fulltext(1577 kB)15 downloads
File information
File name FULLTEXT01.pdfFile size 1577 kBChecksum SHA-512
0dbb93369728ca48c1990efc17d2145869d864e4ed6ba121c7761f356d5a19f018eb66acfa945077c4832ed17f57f7cf33cb4d1e20d10bd672fc077933e85bdc
Type fulltextMimetype application/pdf

By organisation
School of Information and Communication Technology (ICT)
Computer and Information Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 15 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 26 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf