Column-oriented database management systems

David Možina (2013) Column-oriented database management systems. EngD thesis.

Preview

Abstract

In the following thesis I will present column-oriented database. Among other things, I will answer on a question why there is a need for a column-oriented database. In recent years there have been a lot of attention regarding a column-oriented database, even if the existence of a columnar database management systems dates back in the early seventies of the last century. I will compare both systems for a database management – a colum-oriented database system and a row-oriented database system and describe key features of the column-oriented database that allow faster query execution. In the practical part I will introduce two different techniques that can be used to implement a columnar-oriented database design in row-oriented database management system. This two techniques are Vertical partitioning and Index organized table (IOT). I will compare the performance of previous two techniques, row-store and a column-store and show that the row-store performance is significaly slower on analytical queries then a column-store.

Item Type:

Thesis (EngD thesis)

Keywords:

Column-oriented database, comparison, database, row-oriented database, analytical query, data warehouse, DBMS

Number of Pages:

Language of Content:

Slovenian

Mentor / Comentors:

Name and Surname	ID	Function
doc. dr. Damjan Vavpotič	286	Mentor

Link to COBISS:

http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=10162004)

Institution:

University of Ljubljana

Department:

Faculty of Computer and Information Science

Item ID:

2179

Date Deposited:

19 Sep 2013 16:26

Last Modified:

03 Oct 2013 09:23

URI:

http://eprints.fri.uni-lj.si/id/eprint/2179

Actions (login required)

View Item