ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

Column-oriented database management systems

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

Download (1134Kb)


    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: 56
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    doc. dr. Damjan Vavpotič286Mentor
    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