Primerjava relacijskih, NoSQL in NewSQL podatkovnih baz

MIKULETIČ, MARKO (author), Šajn, Luka (mentor)

Diplomsko delo obravnava najnovejse podrocje 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, med- tem ko NoSQL podatkovne baze sledijo teoremu CAP v skladu z nacelom 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 znacilnosti, kategorizacijo in opisali primere NewSQL podatkovnih baz. Naredili smo primerjavo med re- lacijskimi, NoSQL in NewSQL podatkovnimi bazami. Zadnji dve poglavji opisujeta pripravo na testiranje podatkovnih baz in testiranje oz. merjenje casa izvajanja podatkovnih baz. Zakljucno poglavje predstavi sklepne ugo- tovitve o obravnavanih podatkovnih bazah in obete za njihovo prihodnost.

• Language: Slovenian
• Keywords: relacijska podatkovna baza, SQL, NoSQL, NewSQL, ACID, CAP, BASE, računalnik
• Work type: Bachelor thesis/paper
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2015
• PID: 20.500.12556/RUL-30580
• Publication date in RUL: 19.02.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 com- pare 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 the- orem, in accordance with the principle of BASE. NewSQL database also as NoSQL database are horizontally scalable. The rst chapter is an introduc- tion 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 compar- ison 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