Integrating a smart city data warehouse efficiently with a cloud infrastructure

Kankaan hanke on Jyväskylän kaupungin seuraavien vuosikymmenten tärkein aluekehityshanke. Kankaan alue muodostaa tulevaisuudessa fiksun kaupungin, mikä edellyttää muun muassa alueen tietovaraston toteuttamista. Ennen tietovaraston toteuttamista on kuitenkin tarpeen selvittää, miten fiksun kaupungin...

Full description

Bibliographic Details
Main Author: Paltto, Oula
Other Authors: Faculty of Information Technology, Informaatioteknologian tiedekunta, Tietojenkäsittelytieteiden laitos, Department of Computer Science and Information Systems, University of Jyväskylä, Jyväskylän yliopisto
Format: Master's thesis
Language:eng
Published: 2015
Subjects:
Online Access: https://jyx.jyu.fi/handle/123456789/45664
_version_ 1826225708487147520
author Paltto, Oula
author2 Faculty of Information Technology Informaatioteknologian tiedekunta Tietojenkäsittelytieteiden laitos Department of Computer Science and Information Systems University of Jyväskylä Jyväskylän yliopisto
author_facet Paltto, Oula Faculty of Information Technology Informaatioteknologian tiedekunta Tietojenkäsittelytieteiden laitos Department of Computer Science and Information Systems University of Jyväskylä Jyväskylän yliopisto Paltto, Oula Faculty of Information Technology Informaatioteknologian tiedekunta Tietojenkäsittelytieteiden laitos Department of Computer Science and Information Systems University of Jyväskylä Jyväskylän yliopisto
author_sort Paltto, Oula
datasource_str_mv jyx
description Kankaan hanke on Jyväskylän kaupungin seuraavien vuosikymmenten tärkein aluekehityshanke. Kankaan alue muodostaa tulevaisuudessa fiksun kaupungin, mikä edellyttää muun muassa alueen tietovaraston toteuttamista. Ennen tietovaraston toteuttamista on kuitenkin tarpeen selvittää, miten fiksun kaupungin tietovarasto voidaan integroida tehokkaasti pilvi-infrastruktuuriin ylipäänsä, mikä oli tämän tutkimuksen päätutkimuskysymys. Tätä varten luotiin yleistettävä, teoreettinen viitekehys, jonka avulla voidaan vastata esimerkiksi tähän kysymykseen. Viitekehyksen avulla voidaan tulkita, että fiksu kaupunki vaatii pilvi-infrastruktuurilta ainakin saatavuutta, autonomisuutta, skaalattavuutta, suorituskykyä, yhteentoimivuutta, vikasietoisuutta, yksityisyyttä ja turvallisuutta sekä käyttäjien osallistamista ja kestävää kehitystä. Viitekehyksen käyttöä demonstroitiin valitsemalla Kankaan alueen tietovaraston tärkeimmät vaatimukset: suorituskyky ja skaalattavuus. Näistä vaatimuksista suorituskyky operationalisoitiin, minkä jälkeen kahden tietovaraston ohjelmistokandidaatin, Stardogin ja Neo4j:n, suorituskyky testattiin. Ne asennettiin Eucalyptus-pilveen ja luotiin suorituskykytesti, joka lisäsi ja kyseli tietoa niistä. Neo4j suoriutui suorituskykytestistä paremmin kuin Stardog. Stardogia ja Neo4j:tä vertailtiin myös subjektiivisesti, mikä toi esille muun muassa, että Neo4j on kypsempi tuote kuin Stardog mutta että molempia tietokantoja voidaan potentiaalisesti hyödyntää Kankaan hankkeessa. Lopuksi viitekehystä itseään arvioitiin, mikä kertoi, että se toimii ohjenuorana melko hyvin, joskin sillä on myös joitakin heikkouksia. Se ei esimerkiksi tarjoa teknisiä tietoja. Tutkimus toteutettiin suunnittelutieteellisesti. The Kangas project is the main urban development project of the City of Jyväskylä for the next several decades. The Kangas area will form a smart city in the future, which requires implementing, among others, the data warehouse of the area. Before implementing the data warehouse, however, there is a need to know how a smart city data warehouse can be efficiently integrated with a cloud infrastructure in general, which was the main research question of this study. To this end, a generalizable, theoretical framework was created that can be used to answer e.g., to this question. With the help of the framework, it can be interpreted that a smart city requires of a cloud infrastructure at least availability, autonomicity, scalability, performance, interoperability, fault tolerance, privacy, and security, as well as user involvement and sustainability. The use of the framework was demonstrated by choosing the most important requirements for the data warehouse of the Kangas area: performance and scalability. Of these requirements, performance was operationalized, after which two candidates for the software of the data warehouse, Stardog and Neo4j, were tested for it. They were installed on a Eucalyptus cloud and a benchmark was created that inserted data into and queried it from them. Neo4j performed better than Stardog in the benchmark. Stardog and Neo4j were compared subjectively as well, which brought out, among others, that Neo4j is a more mature product than Stardog, but that both databases can potentially be utilized in the Kangas project. Finally, the framework itself was evaluated, which revealed that it functions as a guiding principle quite well, although it has also some weaknesses. E.g., it offers no specifications. The study was conducted as design science.
first_indexed 2024-09-11T08:49:02Z
format Pro gradu
free_online_boolean 1
fullrecord [{"key": "dc.contributor.advisor", "value": "Tyrv\u00e4inen, Pasi", "language": null, "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.advisor", "value": "Mazhelis, Oleksiy", "language": null, "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Paltto, Oula", "language": null, "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2015-04-18T20:25:44Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2015-04-18T20:25:44Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2015", "language": null, "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.other", "value": "oai:jykdok.linneanet.fi:1472410", "language": null, "element": "identifier", "qualifier": "other", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/45664", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Kankaan hanke on Jyv\u00e4skyl\u00e4n kaupungin seuraavien vuosikymmenten t\u00e4rkein\naluekehityshanke. Kankaan alue muodostaa tulevaisuudessa fiksun kaupungin,\nmik\u00e4 edellytt\u00e4\u00e4 muun muassa alueen tietovaraston toteuttamista. Ennen tietovaraston\ntoteuttamista on kuitenkin tarpeen selvitt\u00e4\u00e4, miten fiksun kaupungin\ntietovarasto voidaan integroida tehokkaasti pilvi-infrastruktuuriin ylip\u00e4\u00e4ns\u00e4,\nmik\u00e4 oli t\u00e4m\u00e4n tutkimuksen p\u00e4\u00e4tutkimuskysymys. T\u00e4t\u00e4 varten luotiin yleistett\u00e4v\u00e4,\nteoreettinen viitekehys, jonka avulla voidaan vastata esimerkiksi t\u00e4h\u00e4n\nkysymykseen. Viitekehyksen avulla voidaan tulkita, ett\u00e4 fiksu kaupunki vaatii\npilvi-infrastruktuurilta ainakin saatavuutta, autonomisuutta, skaalattavuutta,\nsuorituskyky\u00e4, yhteentoimivuutta, vikasietoisuutta, yksityisyytt\u00e4 ja turvallisuutta\nsek\u00e4 k\u00e4ytt\u00e4jien osallistamista ja kest\u00e4v\u00e4\u00e4 kehityst\u00e4. Viitekehyksen k\u00e4ytt\u00f6\u00e4\ndemonstroitiin valitsemalla Kankaan alueen tietovaraston t\u00e4rkeimm\u00e4t vaatimukset:\nsuorituskyky ja skaalattavuus. N\u00e4ist\u00e4 vaatimuksista suorituskyky\noperationalisoitiin, mink\u00e4 j\u00e4lkeen kahden tietovaraston ohjelmistokandidaatin,\nStardogin ja Neo4j:n, suorituskyky testattiin. Ne asennettiin Eucalyptus-pilveen\nja luotiin suorituskykytesti, joka lis\u00e4si ja kyseli tietoa niist\u00e4. Neo4j suoriutui\nsuorituskykytestist\u00e4 paremmin kuin Stardog. Stardogia ja Neo4j:t\u00e4 vertailtiin\nmy\u00f6s subjektiivisesti, mik\u00e4 toi esille muun muassa, ett\u00e4 Neo4j on kypsempi tuote\nkuin Stardog mutta ett\u00e4 molempia tietokantoja voidaan potentiaalisesti hy\u00f6dynt\u00e4\u00e4\nKankaan hankkeessa. Lopuksi viitekehyst\u00e4 itse\u00e4\u00e4n arvioitiin, mik\u00e4 kertoi,\nett\u00e4 se toimii ohjenuorana melko hyvin, joskin sill\u00e4 on my\u00f6s joitakin heikkouksia.\nSe ei esimerkiksi tarjoa teknisi\u00e4 tietoja. Tutkimus toteutettiin suunnittelutieteellisesti.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "The Kangas project is the main urban development project of the City of Jyv\u00e4skyl\u00e4\nfor the next several decades. The Kangas area will form a smart city in the\nfuture, which requires implementing, among others, the data warehouse of the\narea. Before implementing the data warehouse, however, there is a need to\nknow how a smart city data warehouse can be efficiently integrated with a\ncloud infrastructure in general, which was the main research question of this\nstudy. To this end, a generalizable, theoretical framework was created that can\nbe used to answer e.g., to this question. With the help of the framework, it can\nbe interpreted that a smart city requires of a cloud infrastructure at least availability,\nautonomicity, scalability, performance, interoperability, fault tolerance,\nprivacy, and security, as well as user involvement and sustainability. The use of\nthe framework was demonstrated by choosing the most important requirements\nfor the data warehouse of the Kangas area: performance and scalability.\nOf these requirements, performance was operationalized, after which two candidates\nfor the software of the data warehouse, Stardog and Neo4j, were tested\nfor it. They were installed on a Eucalyptus cloud and a benchmark was created\nthat inserted data into and queried it from them. Neo4j performed better than\nStardog in the benchmark. Stardog and Neo4j were compared subjectively as\nwell, which brought out, among others, that Neo4j is a more mature product\nthan Stardog, but that both databases can potentially be utilized in the Kangas\nproject. Finally, the framework itself was evaluated, which revealed that it functions\nas a guiding principle quite well, although it has also some weaknesses.\nE.g., it offers no specifications. The study was conducted as design science.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted using Plone Publishing form by Oula Paltto (oujopalt) on 2015-04-18 20:25:44.407503. 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@noreply.fi) on 2015-04-18T20:25:44Z\nNo. of bitstreams: 2\nURN:NBN:fi:jyu-201504181620.pdf: 1617560 bytes, checksum: f0102e241074075f856a31b40204f7ba (MD5)\nlicense.html: 4831 bytes, checksum: 6d6a67e9c4ecd052f990f680cdaa6963 (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2015-04-18T20:25:44Z (GMT). No. of bitstreams: 2\nURN:NBN:fi:jyu-201504181620.pdf: 1617560 bytes, checksum: f0102e241074075f856a31b40204f7ba (MD5)\nlicense.html: 4831 bytes, checksum: 6d6a67e9c4ecd052f990f680cdaa6963 (MD5)\n Previous issue date: 2015", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "1 verkkoaineisto (103 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": "eng", "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": "cloud computing", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "smart city", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "Eucalyptus", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "NoSQL", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "graph database", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "Stardog", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "Neo4j", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "Integrating a smart city data warehouse efficiently with a cloud infrastructure", "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-201504181620", "language": null, "element": "identifier", "qualifier": "urn", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Master\u2019s thesis", "language": "en", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Pro gradu -tutkielma", "language": "fi", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.contributor.faculty", "value": "Faculty of Information Technology", "language": "en", "element": "contributor", "qualifier": "faculty", "schema": "dc"}, {"key": "dc.contributor.faculty", "value": "Informaatioteknologian tiedekunta", "language": "fi", "element": "contributor", "qualifier": "faculty", "schema": "dc"}, {"key": "dc.contributor.department", "value": "Tietojenk\u00e4sittelytieteiden laitos", "language": "fi", "element": "contributor", "qualifier": "department", "schema": "dc"}, {"key": "dc.contributor.department", "value": "Department of Computer Science and Information Systems", "language": "en", "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": "Information Systems Science", "language": "en", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "dc.subject.discipline", "value": "Tietoj\u00e4rjestelm\u00e4tiede", "language": "fi", "element": "subject", "qualifier": "discipline", "schema": "dc"}, {"key": "dc.date.updated", "value": "2015-04-18T20:25:45Z", "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": null, "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": "601", "language": null, "element": "subject", "qualifier": "oppiainekoodi", "schema": "dc"}, {"key": "dc.subject.yso", "value": "pilvipalvelut", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "kaupunkisuunnittelu", "language": null, "element": "subject", "qualifier": "yso", "schema": "dc"}, {"key": "dc.subject.yso", "value": "tietovarastot", "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_45664
language eng
last_indexed 2025-02-18T10:56:13Z
main_date 2015-01-01T00:00:00Z
main_date_str 2015
online_boolean 1
online_urls_str_mv {"url":"https:\/\/jyx.jyu.fi\/bitstreams\/1a74547a-9ce3-4a0f-ae19-371874525b42\/download","text":"URN:NBN:fi:jyu-201504181620.pdf","source":"jyx","mediaType":"application\/pdf"}
publishDate 2015
record_format qdc
source_str_mv jyx
spellingShingle Paltto, Oula Integrating a smart city data warehouse efficiently with a cloud infrastructure cloud computing smart city Eucalyptus NoSQL graph database Stardog Neo4j Information Systems Science Tietojärjestelmätiede 601 pilvipalvelut kaupunkisuunnittelu tietovarastot
title Integrating a smart city data warehouse efficiently with a cloud infrastructure
title_full Integrating a smart city data warehouse efficiently with a cloud infrastructure
title_fullStr Integrating a smart city data warehouse efficiently with a cloud infrastructure Integrating a smart city data warehouse efficiently with a cloud infrastructure
title_full_unstemmed Integrating a smart city data warehouse efficiently with a cloud infrastructure Integrating a smart city data warehouse efficiently with a cloud infrastructure
title_short Integrating a smart city data warehouse efficiently with a cloud infrastructure
title_sort integrating a smart city data warehouse efficiently with a cloud infrastructure
title_txtP Integrating a smart city data warehouse efficiently with a cloud infrastructure
topic cloud computing smart city Eucalyptus NoSQL graph database Stardog Neo4j Information Systems Science Tietojärjestelmätiede 601 pilvipalvelut kaupunkisuunnittelu tietovarastot
topic_facet 601 Eucalyptus Information Systems Science Neo4j NoSQL Stardog Tietojärjestelmätiede cloud computing graph database kaupunkisuunnittelu pilvipalvelut smart city tietovarastot
url https://jyx.jyu.fi/handle/123456789/45664 http://www.urn.fi/URN:NBN:fi:jyu-201504181620
work_keys_str_mv AT palttooula integratingasmartcitydatawarehouseefficientlywithacloudinfrastructure