Primerjava relacijskih, NoSQL in NewSQL podatkovnih baz : diplomsko delo

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

Diplomsko delo obravnava najnovejše področje 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čelom 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 četrtem poglavju so predstavljene NoSQL in NewSQL podatkovne baze. Predstavili smo, kaj so te baze, njihove značilnosti, 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 časa izvajanja podatkovnih baz. Zaključno 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-30580
• COBISS.SI-ID: 1536247491
• 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 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 final 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