Podatkovne baze NewSQLin njihova uporaba na primeru baze MemSQL

diplomsko delo

Janez Martin Kričej (Author), Lili Nemec (Mentor), Luka Hrgarek (Co-mentor)

Abstract

Diplomska delo opisuje primerjavo podatkovne baze tipa NewSQL z relacijskimi podatkovnimi bazami in NoSQL podatkovnimi bazami. V prvem delu predstavimo relacijski sistem podatkovnih baz, ki za povpraševanja uporabljajo SQL. Nadaljujemo z opisom nerelacijskih oziroma NoSQL podatkovnih baz. Sledi obsežnejši opis NewSQL podatkovnih baz, ki predstavlja moderniziran pristop relacijske strukture in zmožnost obdelovanja večjih količin podatkov. Vse tri vrste podatkovnih baz primerjamo in povzamemo ugotovitve. V nadaljevanju namestimo in testiramo eno izmed NewSQL podatkovnih baz MemSQL, ki se je preimenovala v SingleStore. Napredek SingleStore podatkovne baze primerjamo na podatkovni množici TPC-H, kjer čase poizvedbe primerjamo s podatkovno bazo SQL MariaDB.

Keywords

podatkovna baza SQL;podatkovna baza NoSQL;podatkovna baza NewSQL;podatkovna baza MemSQL;baza SingleStore;diplomske naloge;

Data

Language:	Slovenian
Year of publishing:	2022
Typology:	2.11 - Undergraduate Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[J. M. Kričej]
UDC:	004.65(043.2)
COBISS:	136962563
Views:	66
Downloads:	8
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	NewSQL databases and their use in a use case of MemSQL
Secondary abstract:	The thesis describes the comparison of NewSQL databases with relational databases and NoSQL databases. In the first part, we introduce the relational database system, which uses SQL for queries. We continue with a description of non-relational or NoSQL databases. This is followed by a more extensive description of NewSQL databases, which represent a modernized approach to relational structure and the ability to process large amounts of data. We compare all three types of databases and summarize our findings. Next, we install and test one of the NewSQL databases, MemSQL, which has been renamed SingleStore. We compare the progress of the SingleStore database on the TPC-H dataset, where query times are compared with the SQL MariaDB database
Secondary keywords:	SQL;NoSQL;NewSQL;MemSQL;SingleStore;
Type (COBISS):	Bachelor thesis/paper
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko, Informatika in tehnologije komuniciranja
Pages:	1 spletni vir (1 datoteka PDF I(X, 40 f.))
ID:	16385256