Change search
ReferencesLink to record
Permanent link

Direct link
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.
TRITA-ICT-EX, 2014:101
National Category
Computer and Information Science
URN: urn:nbn:se:kth:diva-177204OAI: diva2:872000
Available from: 2015-12-08 Created: 2015-11-17 Last updated: 2015-12-08Bibliographically approved

Open Access in DiVA

No full text

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

Search outside of DiVA

GoogleGoogle Scholar
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

Total: 14 hits
ReferencesLink to record
Permanent link

Direct link