Relaatiotietokantojen indeksointi

Datan määrän kasvaessa monet tietokannat ja näiden taulut ovat kasvaneet rivimäärältään eksponentiaalisesti. Datan haku suuria tauluja läpikäymällä on kaikki rivit lukevaa perinteistä menetelmää käyttäen tehotonta ja aikaa vievää. Tietokantaindeksit pyrkivät ratkaisemaan kyseisen ongelman tallentama...

Täydet tiedot

Bibliografiset tiedot
Päätekijä: Pirttimäki, Ville
Muut tekijät: Informaatioteknologian tiedekunta, Faculty of Information Technology, Informaatioteknologia, Information Technology, University of Jyväskylä, Jyväskylän yliopisto
Aineistotyyppi: Kandityö
Kieli:fin
Julkaistu: 2010
Aiheet:
Linkit: https://jyx.jyu.fi/handle/123456789/37697
_version_ 1828193216442138625
author Pirttimäki, Ville
author2 Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology University of Jyväskylä Jyväskylän yliopisto
author_facet Pirttimäki, Ville Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology University of Jyväskylä Jyväskylän yliopisto Pirttimäki, Ville Informaatioteknologian tiedekunta Faculty of Information Technology Informaatioteknologia Information Technology University of Jyväskylä Jyväskylän yliopisto
author_sort Pirttimäki, Ville
datasource_str_mv jyx
description Datan määrän kasvaessa monet tietokannat ja näiden taulut ovat kasvaneet rivimäärältään eksponentiaalisesti. Datan haku suuria tauluja läpikäymällä on kaikki rivit lukevaa perinteistä menetelmää käyttäen tehotonta ja aikaa vievää. Tietokantaindeksit pyrkivät ratkaisemaan kyseisen ongelman tallentamalla hakujen kannalta oleellista dataa. Tutkielma tarkastelee indeksoinnin perusmenetelmiä ja sopivan indeksointitavan valintaa.
first_indexed 2024-09-11T08:50:04Z
format Kandityö
free_online_boolean 1
fullrecord [{"key": "dc.contributor.author", "value": "Pirttim\u00e4ki, Ville", "language": null, "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2012-04-16T10:53:01Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2012-04-16T10:53:01Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2010", "language": null, "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/37697", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Datan m\u00e4\u00e4r\u00e4n kasvaessa monet tietokannat ja n\u00e4iden taulut ovat kasvaneet\nrivim\u00e4\u00e4r\u00e4lt\u00e4\u00e4n eksponentiaalisesti. Datan haku suuria tauluja l\u00e4pik\u00e4ym\u00e4ll\u00e4\non kaikki rivit lukevaa perinteist\u00e4 menetelm\u00e4\u00e4 k\u00e4ytt\u00e4en tehotonta ja aikaa viev\u00e4\u00e4.\nTietokantaindeksit pyrkiv\u00e4t ratkaisemaan kyseisen ongelman tallentamalla hakujen\nkannalta oleellista dataa. Tutkielma tarkastelee indeksoinnin perusmenetelmi\u00e4\nja sopivan indeksointitavan valintaa.", "language": null, "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted using Plone Publishing form by Ville Pirttim\u00e4ki (vipirtti) on 2012-04-16 10:52:59.812122. Form: Kandin tutkielma -lomake (1 tekij\u00e4) (https://kirjasto.jyu.fi/julkaisut/julkaisulomakkeet/kandin-tutkielma-lomake-1-tekijae). JyX data:", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by jyx lomake-julkaisija (jyx-julkaisija@noreply.fi) on 2012-04-16T10:53:01Z\nNo. of bitstreams: 2\nURN:NBN:fi:jyu-201204161538.pdf: 160343 bytes, checksum: a9c89f09aad4284d5f9aabd53e158928 (MD5)\nlicense.html: 4976 bytes, checksum: 84c9714ea90c19117bb8303846034c13 (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2012-04-16T10:53:01Z (GMT). No. of bitstreams: 2\nURN:NBN:fi:jyu-201204161538.pdf: 160343 bytes, checksum: a9c89f09aad4284d5f9aabd53e158928 (MD5)\nlicense.html: 4976 bytes, checksum: 84c9714ea90c19117bb8303846034c13 (MD5)\n Previous issue date: 2010", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.format.extent", "value": "24", "language": null, "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": "B-puu", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "bittikarttaindeksi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "indeksi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "indeksointi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "hajasipaisu", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "ryv\u00e4st\u00e4v\u00e4 indeksi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "QUBE", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "relaatiotietokanta", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "sarjasipaisu", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "sipaisu", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "yksik\u00e4sitteinen indeksi", "language": "", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "Relaatiotietokantojen indeksointi", "language": null, "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-201204161538", "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": "2012-04-16T10:53:02Z", "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_37697
language fin
last_indexed 2025-03-31T20:03:02Z
main_date 2010-01-01T00:00:00Z
main_date_str 2010
online_boolean 1
online_urls_str_mv {"url":"https:\/\/jyx.jyu.fi\/bitstreams\/7a9d3c27-0240-485f-a49b-edd3331be1ca\/download","text":"URN:NBN:fi:jyu-201204161538.pdf","source":"jyx","mediaType":"application\/pdf"}
publishDate 2010
record_format qdc
source_str_mv jyx
spellingShingle Pirttimäki, Ville Relaatiotietokantojen indeksointi B-puu bittikarttaindeksi indeksi indeksointi hajasipaisu ryvästävä indeksi QUBE relaatiotietokanta sarjasipaisu sipaisu yksikäsitteinen indeksi Tietotekniikka Mathematical Information Technology
title Relaatiotietokantojen indeksointi
title_full Relaatiotietokantojen indeksointi
title_fullStr Relaatiotietokantojen indeksointi Relaatiotietokantojen indeksointi
title_full_unstemmed Relaatiotietokantojen indeksointi Relaatiotietokantojen indeksointi
title_short Relaatiotietokantojen indeksointi
title_sort relaatiotietokantojen indeksointi
title_txtP Relaatiotietokantojen indeksointi
topic B-puu bittikarttaindeksi indeksi indeksointi hajasipaisu ryvästävä indeksi QUBE relaatiotietokanta sarjasipaisu sipaisu yksikäsitteinen indeksi Tietotekniikka Mathematical Information Technology
topic_facet B-puu Mathematical Information Technology QUBE Tietotekniikka bittikarttaindeksi hajasipaisu indeksi indeksointi relaatiotietokanta ryvästävä indeksi sarjasipaisu sipaisu yksikäsitteinen indeksi
url https://jyx.jyu.fi/handle/123456789/37697 http://www.urn.fi/URN:NBN:fi:jyu-201204161538
work_keys_str_mv AT pirttimäkiville relaatiotietokantojenindeksointi