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

Highly scalable NewSQL database management system CockroachDB

Matjaž Mav (2018) Highly scalable NewSQL database management system CockroachDB. EngD thesis.

Download (590Kb)


    The thesis deals with a NewSQL database called CockroachDB. The aim of the thesis is to describe key concepts used in NewSQL databases and then evaluate and compare performance of the new database CockroachDB and the well-established PostgreSQL database. NewSQL databases are built for distributed environments and integrate the properties of both SQL and NoSQL databases. NewSQL databases use the standard SQL query language for interaction with a database. They use ACID transactions that guarantee high data consistency. They enable easier horizontal scaling, replication, high availability and automatic failover. The results of simple queries showed that CockroachDB achieves on average 5 times lower throughput and 3 times higher latency compared to PostgreSQL on three node cluster. Furthermore, CockroachDB provides only basic support for join operations.

    Item Type: Thesis (EngD thesis)
    Keywords: databases, scalability, SQL, NewSQL, CockroachDB, PostgreSQL, Citus, YCSB
    Number of Pages: 63
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    izr. prof. dr. Matjaž Kukar267Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=51012&select=(ID=1537910467)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 4188
    Date Deposited: 10 Sep 2018 14:39
    Last Modified: 20 Sep 2018 13:03
    URI: http://eprints.fri.uni-lj.si/id/eprint/4188

    Actions (login required)

    View Item