Tietokannat ja versionhallinta

Tämän tutkielman taustalla on työelämässä havaitut ongelmat tietokantojen rakenteiden ylläpitoon. Tavoitteena on löytää ratkaisumalli, joka mahdollisimman hyvin ratkaisisi havaitut ongelmat. Tietokannan rakennetta muokkaavien SQL–lauseiden järjestelmällinen tallentaminen version hallintaan näyttää r...

Full description

Bibliographic Details
Main Author: Vahteala, Ville-Pekka
Other Authors: Informaatioteknologian tiedekunta, Faculty of Information Technology, Informaatioteknologia, Information Technology, University of Jyväskylä, Jyväskylän yliopisto
Format: Bachelor's thesis
Language:fin
Published: 2015
Subjects:
Online Access: https://jyx.jyu.fi/handle/123456789/46380
_version_ 1828193215315968000
author Vahteala, Ville-Pekka
author2 Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology University of Jyväskylä Jyväskylän yliopisto
author_facet Vahteala, Ville-Pekka Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology University of Jyväskylä Jyväskylän yliopisto Vahteala, Ville-Pekka Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology University of Jyväskylä Jyväskylän yliopisto
author_sort Vahteala, Ville-Pekka
datasource_str_mv jyx
description Tämän tutkielman taustalla on työelämässä havaitut ongelmat tietokantojen rakenteiden ylläpitoon. Tavoitteena on löytää ratkaisumalli, joka mahdollisimman hyvin ratkaisisi havaitut ongelmat. Tietokannan rakennetta muokkaavien SQL–lauseiden järjestelmällinen tallentaminen version hallintaan näyttää ratkaisevan ongelmia, vaikkakin rinnakkaisen kehitystyön osalta kaikkia ongelmia ei saaturatkaistua. This study is based on problems acknowledged during development work of databases. Study tries to find solutions to these problems. It seems that storing database structure altering SQL batches into version controlling system will solve some of the problems. However parallel development of database still has some issues.
first_indexed 2024-09-11T08:52:15Z
format Kandityö
free_online_boolean 1
fullrecord [{"key": "dc.contributor.advisor", "value": "M\u00f6nk\u00f6l\u00e4, Sanna", "language": null, "element": "contributor", "qualifier": "advisor", "schema": "dc"}, {"key": "dc.contributor.author", "value": "Vahteala, Ville-Pekka", "language": null, "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2015-06-22T08:20:49Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2015-06-22T08:20:49Z", "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.uri", "value": "https://jyx.jyu.fi/handle/123456789/46380", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "T\u00e4m\u00e4n tutkielman taustalla on ty\u00f6el\u00e4m\u00e4ss\u00e4 havaitut ongelmat tietokantojen rakenteiden yll\u00e4pitoon. Tavoitteena on l\u00f6yt\u00e4\u00e4 ratkaisumalli, joka mahdollisimman hyvin ratkaisisi havaitut ongelmat. Tietokannan rakennetta muokkaavien SQL\u2013lauseiden j\u00e4rjestelm\u00e4llinen tallentaminen version hallintaan n\u00e4ytt\u00e4\u00e4 ratkaisevan ongelmia, vaikkakin rinnakkaisen kehitysty\u00f6n osalta kaikkia ongelmia ei saaturatkaistua.", "language": "fi", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.abstract", "value": "This study is based on problems acknowledged during development work of databases. Study tries to find solutions to these problems. It seems that storing database structure altering SQL batches into version controlling system will solve some of the problems. However parallel development of database still has some issues.", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted using Plone Publishing form by Ville-Pekka Vahteala (vahtis) on 2015-06-22 08:20:48.855675. Form: Kandidaatintutkielma -lomake (https://kirjasto.jyu.fi/julkaisut/julkaisulomakkeet/kandin-tutkielma-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 2015-06-22T08:20:49Z\nNo. of bitstreams: 2\nURN:NBN:fi:jyu-201506222401.pdf: 217979 bytes, checksum: 1f70598f04cdca1980c4f1099f62ab22 (MD5)\nlicense.html: 4787 bytes, checksum: 806d7fc349d2a05dfe86c09c9deaef59 (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2015-06-22T08:20:49Z (GMT). No. of bitstreams: 2\nURN:NBN:fi:jyu-201506222401.pdf: 217979 bytes, checksum: 1f70598f04cdca1980c4f1099f62ab22 (MD5)\nlicense.html: 4787 bytes, checksum: 806d7fc349d2a05dfe86c09c9deaef59 (MD5)\n Previous issue date: 2015", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "20", "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": "Tietokanta", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "versionhallinta", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "Tietokannat ja versionhallinta", "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-201506222401", "language": null, "element": "identifier", "qualifier": "urn", "schema": "dc"}, {"key": "dc.type.dcmitype", "value": "Text", "language": "en", "element": "type", "qualifier": "dcmitype", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Kandidaatintutkielma", "language": "fi", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Bachelor's 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.department", "value": "Information Technology", "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": "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": "2015-06-22T08:20:49Z", "language": null, "element": "date", "qualifier": "updated", "schema": "dc"}, {"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": "fi", "element": "rights", "qualifier": "accesslevel", "schema": "dc"}, {"key": "dc.type.publication", "value": "bachelorThesis", "language": null, "element": "type", "qualifier": "publication", "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_46380
language fin
last_indexed 2025-03-31T20:03:26Z
main_date 2015-01-01T00:00:00Z
main_date_str 2015
online_boolean 1
online_urls_str_mv {"url":"https:\/\/jyx.jyu.fi\/bitstreams\/64d06ef4-ad57-440d-a539-ec08b0f3d3af\/download","text":"URN:NBN:fi:jyu-201506222401.pdf","source":"jyx","mediaType":"application\/pdf"}
publishDate 2015
record_format qdc
source_str_mv jyx
spellingShingle Vahteala, Ville-Pekka Tietokannat ja versionhallinta Tietokanta versionhallinta Tietotekniikka Mathematical Information Technology
title Tietokannat ja versionhallinta
title_full Tietokannat ja versionhallinta
title_fullStr Tietokannat ja versionhallinta Tietokannat ja versionhallinta
title_full_unstemmed Tietokannat ja versionhallinta Tietokannat ja versionhallinta
title_short Tietokannat ja versionhallinta
title_sort tietokannat ja versionhallinta
title_txtP Tietokannat ja versionhallinta
topic Tietokanta versionhallinta Tietotekniikka Mathematical Information Technology
topic_facet Mathematical Information Technology Tietokanta Tietotekniikka versionhallinta
url https://jyx.jyu.fi/handle/123456789/46380 http://www.urn.fi/URN:NBN:fi:jyu-201506222401
work_keys_str_mv AT vahtealavillepekka tietokannatjaversionhallinta