Primerjava relacijskih, NoSQL in NewSQL podatkovnih baz : diplomsko delo

Mikuletič, Marko (author), Šajn, Luka (mentor)

Diplomsko delo obravnava najnovej�se podro�cje podatkovnih baz, to so Ne-wSQL podatkovne baze. Cilj diplomskega dela je opisati No SQL in NewSQL podatkovne baze in jih primerjati z relacijsko podatkovno bazo. NewSQL podatkovne baze uporabljajo isti jezik SQL kot relacijske podatkovne baze, imajo isto ACID podporo transakcij kot relacijske podatkovne baze, medtem ko NoSQL podatkovne baze sledijo teoremu CAP v skladu z na�celom BASE. NewSQL podatkovne baze so prav tako kot NoSQL podatkovne baze horizontalno skalabilne. V prvem poglavju je predstavljen uvod v diplomsko delo, sledi uvod v podatkovne baze in opis relacijskih podatkovnih baz. V tretjem in �cetrtem poglavju so predstavljene NoSQL in NewSQL podatkovne baze. Predstavili smo, kaj so te baze, njihove zna�cilnosti, kategorizacijo in opisali primere NewSQL podatkovnih baz. Naredili smo primerjavo med relacijskimi, NoSQL in NewSQL podatkovnimi bazami. Zadnji dve poglavji opisujeta pripravo na testiranje podatkovnih baz in testiranje oz. merjenje �casa izvajanja podatkovnih baz. Zaklju�cno poglavje predstavi sklepne ugotovitve o obravnavanih podatkovnih bazah in obete za njihovo prihodnost.

• Language: Slovenian
• Keywords: relacijska podatkovna baza, SQL, NoSQL, NewSQL, ACID, CAP, BASE, računalnik, računalništvo, visokošolski strokovni študij, računalništvo in informatika, diplomske naloge
• Work type: Bachelor thesis/paper
• Typology: 2.11 - Undergraduate Thesis
• Organization: FRI - Faculty of Computer and Information Science
• Publisher: [M. Mikuletič]
• Year: 2015
• Number of pages: 58 str.
• PID: 20.500.12556/RUL-70114
• UDC: 004.65(043.2)
• COBISS.SI-ID: 1536247491
• Publication date in RUL: 10.07.2015

Secondary language

• Language: English
• Title: Comparison of relational, NoSQL and NewSQL databases

Abstract

The thesis deals with the newest area of databases that are NewSQL database. The aim of the thesis is to describe NoSQL and NewSQL databases and compare them with relational database. NewSQL database is using the same language SQL as relational databases, with ACID support for transactions same as a relational database, while NoSQL database follow the CAP theorem, in accordance with the principle of BASE. NewSQL database also as NoSQL database are horizontally scalable. The �rst chapter is an introduction to the study, followed by an introduction to databases and description of relational databases. The third and the fourth chapter presents NoSQL and NewSQL database. We presented what these bases, their characteristics, categorize and describe examples of NewSQL databases. We made a comparison between the relational, NoSQL and NewSQL databases. The last two chapters describe the preparation of test databases and testing respectively measurement runtime of databases. The �nal section presents conclusions about the studied databases and makes some predictions about their future.

• Keywords: relational database, SQL, NoSQL, NewSQL, ACID, CAP, BASE, computer, computer science, computer and information science, diploma