Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin

Relaatiomalli on pitkään ollut hallitseva tietokantamalli tietokannanhallintajärjestelmien alalla. Tietokantoja kohtaan muuttuneet tarpeet etenkin massadatan suhteen ovat luoneet vaatimuksia, joita relationaaliset tietokannanhallintajärjestelmät eivät pysty palvelemaan tehokkaasti. Vaihtoehtoisien t...

Täydet tiedot

Bibliografiset tiedot
Päätekijä: Laine, Artturi
Muut tekijät: Informaatioteknologian tiedekunta, Faculty of Information Technology, Informaatioteknologia, Information Technology, Jyväskylän yliopisto, University of Jyväskylä
Aineistotyyppi: Kandityö
Kieli:fin
Julkaistu: 2024
Aiheet:
Linkit: https://jyx.jyu.fi/handle/123456789/98408
_version_ 1826225807862792192
author Laine, Artturi
author2 Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology Jyväskylän yliopisto University of Jyväskylä
author_facet Laine, Artturi Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology Jyväskylän yliopisto University of Jyväskylä Laine, Artturi Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology Jyväskylän yliopisto University of Jyväskylä
author_sort Laine, Artturi
datasource_str_mv jyx
description Relaatiomalli on pitkään ollut hallitseva tietokantamalli tietokannanhallintajärjestelmien alalla. Tietokantoja kohtaan muuttuneet tarpeet etenkin massadatan suhteen ovat luoneet vaatimuksia, joita relationaaliset tietokannanhallintajärjestelmät eivät pysty palvelemaan tehokkaasti. Vaihtoehtoisien tietokantamallien suosion nousun myötä relaatiomallin aseman oikeellisuutta suosituimpana tietokantamallina on mahdollista kyseenalaistaa. Tässä tutkielmassa tarkastellaan relaatiomallin, NoSQL:n ja NewSQL:n ominaisuuksia ja vertaillaan niitä keskenään. Keskeisenä havaintona huomattiin, että eri tietokantamallit täydentävät toisiaan korvaamisen sijaan. Tutkielman toteutuksesta teki haasteellista se, että monia tietokannanhallintajärjestelmiä on haastavaa, ellei jopa mahdotonta kategorisoida yhteen tietokantamalliin. The relational model has been the leading database model within database management systems for a long time. The evolving needs for databases, especially regarding big data, have created requirements that relational database management systems can’t fulfill efficiently. The rise of the alternative database models’ popularity may raise doubt about the rightfulness of the relational model’s position as the most popular database model. In this thesis, the features of the relational model, NewSQL and NoSQL are explained, and then compared with each other. A notable finding was that these database models complement each other instead of replacing. Carrying out this thesis was made challenging by the fact that a lot of database management systems are difficult if not impossible to categorise as a single database model.
first_indexed 2024-11-14T21:00:55Z
format Kandityö
free_online_boolean 1
fullrecord [{"key": "dc.contributor.advisor", "value": "Kuusio, Ari", "language": "", "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Laine, Artturi", "language": "", "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2024-11-14T07:23:38Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2024-11-14T07:23:38Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2024", "language": "", "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/98408", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Relaatiomalli on pitk\u00e4\u00e4n ollut hallitseva tietokantamalli tietokannanhallintaj\u00e4rjestelmien alalla. Tietokantoja kohtaan muuttuneet tarpeet etenkin massadatan suhteen ovat luoneet vaatimuksia, joita relationaaliset tietokannanhallintaj\u00e4rjestelm\u00e4t eiv\u00e4t pysty palvelemaan tehokkaasti. Vaihtoehtoisien tietokantamallien suosion nousun my\u00f6t\u00e4 relaatiomallin aseman oikeellisuutta suosituimpana tietokantamallina on mahdollista kyseenalaistaa. T\u00e4ss\u00e4 tutkielmassa tarkastellaan relaatiomallin, NoSQL:n ja NewSQL:n ominaisuuksia ja vertaillaan niit\u00e4 kesken\u00e4\u00e4n. Keskeisen\u00e4 havaintona huomattiin, ett\u00e4 eri tietokantamallit t\u00e4ydent\u00e4v\u00e4t toisiaan korvaamisen sijaan. Tutkielman toteutuksesta teki haasteellista se, ett\u00e4 monia tietokannanhallintaj\u00e4rjestelmi\u00e4 on haastavaa, ellei jopa mahdotonta kategorisoida yhteen tietokantamalliin.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "The relational model has been the leading database model within database management systems for a long time. The evolving needs for databases, especially regarding big data, have created requirements that relational database management systems can\u2019t fulfill efficiently. The rise of the alternative database models\u2019 popularity may raise doubt about the rightfulness of the relational model\u2019s position as the most popular database model. In this thesis, the features of the relational model, NewSQL and NoSQL are explained, and then compared with each other. A notable finding was that these database models complement each other instead of replacing. Carrying out this thesis was made challenging by the fact that a lot of database management systems are difficult if not impossible to categorise as a single database model.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by Miia Hakanen (mihakane@jyu.fi) on 2024-11-14T07:23:38Z\nNo. of bitstreams: 0", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2024-11-14T07:23:38Z (GMT). No. of bitstreams: 0\n Previous issue date: 2024", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "34", "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": "NoSQL", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "NewSQL", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "tietokantamallit", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "tietokannanhallintaj\u00e4rjestelm\u00e4t", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "relaatiomalli", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin", "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-202411147251", "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": "Tietoj\u00e4rjestelm\u00e4tiede", "language": "fi", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "dc.subject.discipline", "value": "Information Systems Science", "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": "601", "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.subject.yso", "value": "SQL", "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_98408
language fin
last_indexed 2025-02-18T10:56:35Z
main_date 2024-01-01T00:00:00Z
main_date_str 2024
online_boolean 1
online_urls_str_mv {"url":"https:\/\/jyx.jyu.fi\/bitstreams\/82cc7e7f-cce6-4b1a-951d-b07408bd04c5\/download","text":"URN:NBN:fi:jyu-202411147251.pdf","source":"jyx","mediaType":"application\/pdf"}
publishDate 2024
record_format qdc
source_str_mv jyx
spellingShingle Laine, Artturi Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin NoSQL NewSQL tietokantamallit tietokannanhallintajärjestelmät relaatiomalli Tietojärjestelmätiede Information Systems Science 601 tietokannat relaatiotietokannat SQL
title Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
title_full Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
title_fullStr Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
title_full_unstemmed Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
title_short Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
title_sort relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
title_txtP Relaatiomallin vertailua vaihtoehtoisiin tietokantamalleihin
topic NoSQL NewSQL tietokantamallit tietokannanhallintajärjestelmät relaatiomalli Tietojärjestelmätiede Information Systems Science 601 tietokannat relaatiotietokannat SQL
topic_facet 601 Information Systems Science NewSQL NoSQL SQL Tietojärjestelmätiede relaatiomalli relaatiotietokannat tietokannanhallintajärjestelmät tietokannat tietokantamallit
url https://jyx.jyu.fi/handle/123456789/98408 http://www.urn.fi/URN:NBN:fi:jyu-202411147251
work_keys_str_mv AT laineartturi relaatiomallinvertailuavaihtoehtoisiintietokantamalleihin