NewSQL-tietokantojen skaalautuvuus

Yksi relaatiotietokantojen heikkouksista on sen skaalautuvuus. Relaatiotietokannat skaalautuvat pystysuoraan, mikä on kallista. NoSQL-tie\-to\-kan\-to\-jen skaalaaminen on edullisempaa, mutta sen seurauksena ACID-periaatteen mukaisista eheyden vaatimuksista joudutaan luopumaan. NewSQL-tietokantojen...

Full description

Bibliographic Details
Main Author: Tuulivuori, Annika
Other Authors: Informaatioteknologian tiedekunta, Faculty of Information Technology, Informaatioteknologia, Information Technology, Jyväskylän yliopisto, University of Jyväskylä
Format: Bachelor's thesis
Language:fin
Published: 2023
Subjects:
Online Access: https://jyx.jyu.fi/handle/123456789/86821
_version_ 1826225800004763648
author Tuulivuori, Annika
author2 Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology Jyväskylän yliopisto University of Jyväskylä
author_facet Tuulivuori, Annika Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology Jyväskylän yliopisto University of Jyväskylä Tuulivuori, Annika Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology Jyväskylän yliopisto University of Jyväskylä
author_sort Tuulivuori, Annika
datasource_str_mv jyx
description Yksi relaatiotietokantojen heikkouksista on sen skaalautuvuus. Relaatiotietokannat skaalautuvat pystysuoraan, mikä on kallista. NoSQL-tie\-to\-kan\-to\-jen skaalaaminen on edullisempaa, mutta sen seurauksena ACID-periaatteen mukaisista eheyden vaatimuksista joudutaan luopumaan. NewSQL-tietokantojen avulla pyritään tarjoamaan NoSQL-tietokantojen skaalautuvuus sekä perinteisten relaatiotietokantojen ACID-periaatteen mukaiset takuut transaktioille. Tämän tutkimuksen tarkoituksena on selvittää, mitä tarkoitetaan tietokannan skaalautuvuudella sekä miten se näkyy NewSQL-tietokannoissa. Lopuksi tutkitaan eri kategoriaan kuuluvien NewSQL-tietokantojen skaalautuvuutta. One of the weaknesses of relational databases is its scalability. Relational databases scale vertically, which is expensive. On the other hand, scaling NoSQL databases is more affordable, but as a result the consistency requirements have to be waived. The aim of NewSQL databases is to provide the scalability of NoSQL and ACID properties from relational databases for transactions. The purpose of this study is to find out what database scalability is and how it is reflected in NewSQL databases.
first_indexed 2023-05-09T20:01:28Z
format Kandityö
free_online_boolean 1
fullrecord [{"key": "dc.contributor.advisor", "value": "Lakanen, Antti-Jussi", "language": "", "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Tuulivuori, Annika", "language": "", "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2023-05-09T08:54:06Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2023-05-09T08:54:06Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2023", "language": "", "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/86821", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Yksi relaatiotietokantojen heikkouksista on sen skaalautuvuus. Relaatiotietokannat skaalautuvat pystysuoraan, mik\u00e4 on kallista. NoSQL-tie\\-to\\-kan\\-to\\-jen skaalaaminen on edullisempaa, mutta sen seurauksena ACID-periaatteen mukaisista eheyden vaatimuksista joudutaan luopumaan. NewSQL-tietokantojen avulla pyrit\u00e4\u00e4n tarjoamaan NoSQL-tietokantojen skaalautuvuus sek\u00e4 perinteisten relaatiotietokantojen ACID-periaatteen mukaiset takuut transaktioille. T\u00e4m\u00e4n tutkimuksen tarkoituksena on selvitt\u00e4\u00e4, mit\u00e4 tarkoitetaan tietokannan skaalautuvuudella sek\u00e4 miten se n\u00e4kyy NewSQL-tietokannoissa. Lopuksi tutkitaan eri kategoriaan kuuluvien NewSQL-tietokantojen skaalautuvuutta.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "One of the weaknesses of relational databases is its scalability. Relational databases scale vertically, which is expensive. On the other hand, scaling NoSQL databases is more affordable, but as a result the consistency requirements have to be waived. The aim of NewSQL databases is to provide the scalability of NoSQL and ACID properties from relational databases for transactions. The purpose of this study is to find out what database scalability is and how it is reflected in NewSQL databases.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by Paivi Vuorio (paelvuor@jyu.fi) on 2023-05-09T08:54:06Z\nNo. of bitstreams: 0", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2023-05-09T08:54:06Z (GMT). No. of bitstreams: 0\n Previous issue date: 2023", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "19", "language": "", "element": "format", "qualifier": "extent", "schema": "dc"}, {"key": "dc.language.iso", "value": "fin", "language": null, "element": "language", "qualifier": "iso", "schema": "dc"}, {"key": "dc.rights", "value": "In Copyright", "language": "en", "element": "rights", "qualifier": null, "schema": "dc"}, {"key": "dc.subject.other", "value": "skaalautuvuus", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "NoSQL-tietokanta", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "NewSQL-tietokanta", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "tietokannan hallintaj\u00e4rjestelm\u00e4", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "NewSQL-tietokantojen skaalautuvuus", "language": "", "element": "title", "qualifier": null, "schema": "dc"}, {"key": "dc.type", "value": "bachelor thesis", "language": null, "element": "type", "qualifier": null, "schema": "dc"}, {"key": "dc.identifier.urn", "value": "URN:NBN:fi:jyu-202305092904", "language": "", "element": "identifier", "qualifier": "urn", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Bachelor's thesis", "language": "en", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Kandidaatinty\u00f6", "language": "fi", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.contributor.faculty", "value": "Informaatioteknologian tiedekunta", "language": "fi", "element": "contributor", "qualifier": "faculty", "schema": "dc"}, {"key": "dc.contributor.faculty", "value": "Faculty of Information Technology", "language": "en", "element": "contributor", "qualifier": "faculty", "schema": "dc"}, {"key": "dc.contributor.department", "value": "Informaatioteknologia", "language": "fi", "element": "contributor", "qualifier": "department", "schema": "dc"}, {"key": "dc.contributor.department", "value": "Information Technology", "language": "en", "element": "contributor", "qualifier": "department", "schema": "dc"}, {"key": "dc.contributor.organization", "value": "Jyv\u00e4skyl\u00e4n yliopisto", "language": "fi", "element": "contributor", "qualifier": "organization", "schema": "dc"}, {"key": "dc.contributor.organization", "value": "University of Jyv\u00e4skyl\u00e4", "language": "en", "element": "contributor", "qualifier": "organization", "schema": "dc"}, {"key": "dc.subject.discipline", "value": "Tietotekniikka", "language": "fi", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "dc.subject.discipline", "value": "Mathematical Information Technology", "language": "en", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "yvv.contractresearch.funding", "value": "0", "language": "", "element": "contractresearch", "qualifier": "funding", "schema": "yvv"}, {"key": "dc.type.coar", "value": "http://purl.org/coar/resource_type/c_7a1f", "language": null, "element": "type", "qualifier": "coar", "schema": "dc"}, {"key": "dc.rights.accesslevel", "value": "openAccess", "language": null, "element": "rights", "qualifier": "accesslevel", "schema": "dc"}, {"key": "dc.type.publication", "value": "bachelorThesis", "language": null, "element": "type", "qualifier": "publication", "schema": "dc"}, {"key": "dc.subject.oppiainekoodi", "value": "602", "language": "", "element": "subject", "qualifier": "oppiainekoodi", "schema": "dc"}, {"key": "dc.subject.yso", "value": "tietokannat", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "relaatiotietokannat", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.rights.url", "value": "https://rightsstatements.org/page/InC/1.0/", "language": null, "element": "rights", "qualifier": "url", "schema": "dc"}]
id jyx.123456789_86821
language fin
last_indexed 2025-02-18T10:54:53Z
main_date 2023-01-01T00:00:00Z
main_date_str 2023
online_boolean 1
online_urls_str_mv {"url":"https:\/\/jyx.jyu.fi\/bitstreams\/3ac2edac-2bfd-4ef2-a5a3-ef60b356d20d\/download","text":"URN:NBN:fi:jyu-202305092904.pdf","source":"jyx","mediaType":"application\/pdf"}
publishDate 2023
record_format qdc
source_str_mv jyx
spellingShingle Tuulivuori, Annika NewSQL-tietokantojen skaalautuvuus skaalautuvuus NoSQL-tietokanta NewSQL-tietokanta tietokannan hallintajärjestelmä Tietotekniikka Mathematical Information Technology 602 tietokannat relaatiotietokannat
title NewSQL-tietokantojen skaalautuvuus
title_full NewSQL-tietokantojen skaalautuvuus
title_fullStr NewSQL-tietokantojen skaalautuvuus NewSQL-tietokantojen skaalautuvuus
title_full_unstemmed NewSQL-tietokantojen skaalautuvuus NewSQL-tietokantojen skaalautuvuus
title_short NewSQL-tietokantojen skaalautuvuus
title_sort newsql tietokantojen skaalautuvuus
title_txtP NewSQL-tietokantojen skaalautuvuus
topic skaalautuvuus NoSQL-tietokanta NewSQL-tietokanta tietokannan hallintajärjestelmä Tietotekniikka Mathematical Information Technology 602 tietokannat relaatiotietokannat
topic_facet 602 Mathematical Information Technology NewSQL-tietokanta NoSQL-tietokanta Tietotekniikka relaatiotietokannat skaalautuvuus tietokannan hallintajärjestelmä tietokannat
url https://jyx.jyu.fi/handle/123456789/86821 http://www.urn.fi/URN:NBN:fi:jyu-202305092904
work_keys_str_mv AT tuulivuoriannika newsqltietokantojenskaalautuvuus