MySQL- ja MongoDB-tietokantojen suorituskykyvertailu

Datan määrä ja rakenne on muuttunut vuosikymmenien saatossa huimasti, ja tiedonkäsittely kokee uusia haasteita jatkuvasti. Perinteiset relaatiotietokannat eivät välttämättä enää sovellu ratkaisemaan näitä ongelmia. 2000-luvun puolella vaihtoehdoksi ovat tulleet NoSQL-tietokannat, joiden tavoitteena...

Full description

Bibliographic Details
Main Author: Haverinen, Henri
Other Authors: Informaatioteknologian tiedekunta, Faculty of Information Technology, Informaatioteknologia, University of Jyväskylä, Jyväskylän yliopisto
Format: Master's thesis
Language:fin
Published: 2018
Subjects:
Online Access: https://jyx.jyu.fi/handle/123456789/57731
_version_ 1828193088849313792
author Haverinen, Henri
author2 Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia University of Jyväskylä Jyväskylän yliopisto
author_facet Haverinen, Henri Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia University of Jyväskylä Jyväskylän yliopisto Haverinen, Henri Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia University of Jyväskylä Jyväskylän yliopisto
author_sort Haverinen, Henri
datasource_str_mv jyx
description Datan määrä ja rakenne on muuttunut vuosikymmenien saatossa huimasti, ja tiedonkäsittely kokee uusia haasteita jatkuvasti. Perinteiset relaatiotietokannat eivät välttämättä enää sovellu ratkaisemaan näitä ongelmia. 2000-luvun puolella vaihtoehdoksi ovat tulleet NoSQL-tietokannat, joiden tavoitteena on tarjota ratkaisukeinoja näihin uusiin haasteisiin. Tässä tutkielmassa käsitellään relaatio- ja NoSQL-tietokantojen taustoja ja eroavaisuuksia. Erityisesti tutkielmassa keskitytään tietokantojen suorituskykyyn. Tutkielmassa mitattiin ja vertailtiin MySQL ja MongoDB tietokantojen suorituskykyä, jotka edustavat vastaavasti relaatio- ja NoSQL-tietokantoja. Suorituskykytesteihin käytettiin avoimen lähdekoodin Yahoo! Cloud Serving Benchmark -työkalua. MongoDB suoriutui suorituskykytesteistä paremmin kuin MySQL-tietokanta, mutta tuloksiin vaikuttavat monet tekijät, eikä vastaus ole kokonaisuudessaan näin yksinkertainen. The amount of data and it's structure has changed dramatically in the past years, and thus data processing faces new challenges constantly. Traditional relational databases might not be a valid solution for these problems anymore. In the 21st century NoSQL databases have emerged as an alternative solution. This master thesis covers the basics and differences between relational and NoSQL databases. Especially performance is taken into account. In this thesis performance of two different databases, MySQL which represents traditional relational database and MongoDB which represents NoSQL database, were tested and compared. Open source tool Yahoo! Cloud Serving Benchmark was used to carry out these tests. MongoDB got better results compared to MySQL database, but it is important to remember that many elements affects to the results and thus the validity of the results is not that straightforward.
first_indexed 2023-03-22T09:59:59Z
format Pro gradu
free_online_boolean 1
fullrecord [{"key": "dc.contributor.advisor", "value": "Kaijanaho, Antti-Juhani", "language": null, "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Haverinen, Henri", "language": null, "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2018-04-23T16:22:46Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2018-04-23T16:22:46Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2018", "language": null, "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.other", "value": "oai:jykdok.linneanet.fi:1869321", "language": null, "element": "identifier", "qualifier": "other", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/57731", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Datan m\u00e4\u00e4r\u00e4 ja rakenne on muuttunut vuosikymmenien saatossa huimasti, ja tiedonk\u00e4sittely kokee uusia haasteita jatkuvasti. Perinteiset relaatiotietokannat eiv\u00e4t v\u00e4ltt\u00e4m\u00e4tt\u00e4 en\u00e4\u00e4 sovellu ratkaisemaan n\u00e4it\u00e4 ongelmia. 2000-luvun puolella vaihtoehdoksi ovat tulleet NoSQL-tietokannat, joiden tavoitteena on tarjota ratkaisukeinoja n\u00e4ihin uusiin haasteisiin. T\u00e4ss\u00e4 tutkielmassa k\u00e4sitell\u00e4\u00e4n relaatio- ja NoSQL-tietokantojen taustoja ja eroavaisuuksia. Erityisesti tutkielmassa keskityt\u00e4\u00e4n tietokantojen suorituskykyyn. Tutkielmassa mitattiin ja vertailtiin MySQL ja MongoDB tietokantojen suorituskyky\u00e4, jotka edustavat vastaavasti relaatio- ja NoSQL-tietokantoja. Suorituskykytesteihin k\u00e4ytettiin avoimen l\u00e4hdekoodin Yahoo! Cloud Serving Benchmark -ty\u00f6kalua. MongoDB suoriutui suorituskykytesteist\u00e4 paremmin kuin MySQL-tietokanta, mutta tuloksiin vaikuttavat monet tekij\u00e4t, eik\u00e4 vastaus ole kokonaisuudessaan n\u00e4in yksinkertainen.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "The amount of data and it's structure has changed dramatically in the past years, and thus data processing faces new challenges constantly. Traditional relational databases might not be a valid solution for these problems anymore. In the 21st century NoSQL databases have emerged as an alternative solution. This master thesis covers the basics and differences between relational and NoSQL databases. Especially performance is taken into account. In this thesis performance of two different databases, MySQL which represents traditional relational database and MongoDB which represents NoSQL database, were tested and compared. Open source tool Yahoo! Cloud Serving Benchmark was used to carry out these tests. MongoDB got better results compared to MySQL database, but it is important to remember that many elements affects to the results and thus the validity of the results is not that straightforward.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted using Plone Publishing form by Henri Haverinen (hesahave) on 2018-04-23 16:22:45.993148. Form: Pro gradu -lomake (https://kirjasto.jyu.fi/julkaisut/julkaisulomakkeet/pro-gradu-lomake). JyX data: [jyx_publishing-allowed (fi) =True]", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by jyx lomake-julkaisija (jyx-julkaisija.group@korppi.jyu.fi) on 2018-04-23T16:22:46Z\nNo. of bitstreams: 2\nURN:NBN:fi:jyu-201804232340.pdf: 958126 bytes, checksum: d90f568c000f256137d55f68f282f008 (MD5)\nlicense.html: 4812 bytes, checksum: 8744336950c45d2ac75744d47335cf50 (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2018-04-23T16:22:46Z (GMT). No. of bitstreams: 2\nURN:NBN:fi:jyu-201804232340.pdf: 958126 bytes, checksum: d90f568c000f256137d55f68f282f008 (MD5)\nlicense.html: 4812 bytes, checksum: 8744336950c45d2ac75744d47335cf50 (MD5)\n Previous issue date: 2018", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "1 verkkoaineisto (57 sivua)", "language": null, "element": "format", "qualifier": "extent", "schema": "dc"}, {"key": "dc.format.mimetype", "value": "application/pdf", "language": null, "element": "format", "qualifier": "mimetype", "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": null, "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "MySQL", "language": null, "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "MongoDB", "language": null, "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "YCSB", "language": null, "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "MySQL- ja MongoDB-tietokantojen suorituskykyvertailu", "language": null, "element": "title", "qualifier": null, "schema": "dc"}, {"key": "dc.type", "value": "master thesis", "language": null, "element": "type", "qualifier": null, "schema": "dc"}, {"key": "dc.identifier.urn", "value": "URN:NBN:fi:jyu-201804232340", "language": null, "element": "identifier", "qualifier": "urn", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Pro gradu -tutkielma", "language": "fi", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Master\u2019s thesis", "language": "en", "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.organization", "value": "University of Jyv\u00e4skyl\u00e4", "language": "en", "element": "contributor", "qualifier": "organization", "schema": "dc"}, {"key": "dc.contributor.organization", "value": "Jyv\u00e4skyl\u00e4n yliopisto", "language": "fi", "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": "dc.date.updated", "value": "2018-04-23T16:22:46Z", "language": null, "element": "date", "qualifier": "updated", "schema": "dc"}, {"key": "yvv.contractresearch.funding", "value": "0", "language": null, "element": "contractresearch", "qualifier": "funding", "schema": "yvv"}, {"key": "dc.type.coar", "value": "http://purl.org/coar/resource_type/c_bdcc", "language": null, "element": "type", "qualifier": "coar", "schema": "dc"}, {"key": "dc.rights.accesslevel", "value": "openAccess", "language": "fi", "element": "rights", "qualifier": "accesslevel", "schema": "dc"}, {"key": "dc.type.publication", "value": "masterThesis", "language": null, "element": "type", "qualifier": "publication", "schema": "dc"}, {"key": "dc.subject.oppiainekoodi", "value": "602", "language": null, "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": "SQL", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "suorituskyky", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.format.content", "value": "fulltext", "language": null, "element": "format", "qualifier": "content", "schema": "dc"}, {"key": "dc.rights.url", "value": "https://rightsstatements.org/page/InC/1.0/", "language": null, "element": "rights", "qualifier": "url", "schema": "dc"}, {"key": "dc.type.okm", "value": "G2", "language": null, "element": "type", "qualifier": "okm", "schema": "dc"}]
id jyx.123456789_57731
language fin
last_indexed 2025-03-31T20:02:24Z
main_date 2018-01-01T00:00:00Z
main_date_str 2018
online_boolean 1
online_urls_str_mv {"url":"https:\/\/jyx.jyu.fi\/bitstreams\/d0db6f1f-a9f8-4239-92c1-ace399041727\/download","text":"URN:NBN:fi:jyu-201804232340.pdf","source":"jyx","mediaType":"application\/pdf"}
publishDate 2018
record_format qdc
source_str_mv jyx
spellingShingle Haverinen, Henri MySQL- ja MongoDB-tietokantojen suorituskykyvertailu NoSQL MySQL MongoDB YCSB Tietotekniikka Mathematical Information Technology 602 tietokannat SQL suorituskyky
title MySQL- ja MongoDB-tietokantojen suorituskykyvertailu
title_full MySQL- ja MongoDB-tietokantojen suorituskykyvertailu
title_fullStr MySQL- ja MongoDB-tietokantojen suorituskykyvertailu MySQL- ja MongoDB-tietokantojen suorituskykyvertailu
title_full_unstemmed MySQL- ja MongoDB-tietokantojen suorituskykyvertailu MySQL- ja MongoDB-tietokantojen suorituskykyvertailu
title_short MySQL- ja MongoDB-tietokantojen suorituskykyvertailu
title_sort mysql ja mongodb tietokantojen suorituskykyvertailu
title_txtP MySQL- ja MongoDB-tietokantojen suorituskykyvertailu
topic NoSQL MySQL MongoDB YCSB Tietotekniikka Mathematical Information Technology 602 tietokannat SQL suorituskyky
topic_facet 602 Mathematical Information Technology MongoDB MySQL NoSQL SQL Tietotekniikka YCSB suorituskyky tietokannat
url https://jyx.jyu.fi/handle/123456789/57731 http://www.urn.fi/URN:NBN:fi:jyu-201804232340
work_keys_str_mv AT haverinenhenri mysqljamongodbtietokantojensuorituskykyvertailu