Back to search

Institutional Repository of Vilnius University

Reliacinės ir kolonėlinės duomenų bazių palyginimas /

Abstract

dc:description

In this document two different types (relational and columnar) of databases will be compared by analysing differences between various data storage realisations in each type of selected databases, looking for the best data storage choice when saving particular type of data. The objective of this work is to overcome the performance issues when working with a big set of analytical data by selecting the best possible data storage format and database which implements selected structure the best. During the process the test was carried out. A big set of data was prepared for various agregation operations (such as calculation of averages). Results have showed that analysing(reading data from database) is done better by columnar type of database, especially when working with bigger sets of data. However, relational databases are easier to set up and perform almost the same or even better when working with little sets of data. The whole test was performed using Ruby programming language (no framework was used due to possibility of unwanted overhead which might make the results less accurate) and three databases: “Cassandra” as row-oriented columnar database, Druid as completely columnar database which is configured to work best when working with analytical data and “Postgresql” as relational database. Three tests were made in total, each of them had different data set size with the purpose of finding the point, when switching from one database to another is the best option.

Degree

thesis:*
Grantor dc:publisher
Institutional Repository of Vilnius University
Year dc:date
2016

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Matulevičius, Justinas,
Contributors dc:contributor
  • Adamonis, Andrius

Rights

dc:rights
Statement dc:rights
  • info:eu-repo/semantics/openAccess
Language dc:language
lit

Identifiers

dc:identifier.*

Chain of custody

source
Harvested from
Vilnius University
Base URL
epublications.vu.lt/oai
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Matulevičius, Justinas,. Reliacinės ir kolonėlinės duomenų bazių palyginimas /. Institutional Repository of Vilnius University, 2016. https://repository.vu.lt/VU:ELABAETD23223257&prefLang=en_US