| fullrecord |
[{"key": "dc.contributor.author", "value": "Lusua, Janne", "language": null, "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2009-04-28T13:10:16Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2009-04-28T13:10:16Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2009", "language": null, "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/19975", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "\u00a0\u00a0Lusua, Janne Petteri Indeksit ja niiden k\u00e4ytt\u00f6 MySQL- ja SQL Server -tietokantatuotteissa / Janne Lusua Jyv\u00e4skyl\u00e4: Jyv\u00e4skyl\u00e4n yliopisto, 2009 35 s. Kandidaatintutkielma Tietokantojen koon yh\u00e4 kasvaessa on syntynyt tarve j\u00e4rjest\u00e4\u00e4 tieto siten, ett\u00e4 se on mahdollisimman nopeasti saatavilla. T\u00e4h\u00e4n ongelmaan on ratkaisuna indeksit, joita voidaan verrata kirjan sis\u00e4llysluetteloon. T\u00e4ss\u00e4 tutkielmassa tarkastellaan, mink\u00e4 tyyppisi\u00e4 indeksej\u00e4 on olemassa ja miten niit\u00e4 hy\u00f6dynnet\u00e4\u00e4n kahdessa suositussa tietokannan hallintaj\u00e4rjestelm\u00e4ss\u00e4, MySQL:ss\u00e4 ja Microsoft SQL Serveriss\u00e4. Aihetta k\u00e4yd\u00e4\u00e4n tutkielmassa l\u00e4pi esittelem\u00e4ll\u00e4 ensin eri indeksityypit. T\u00e4m\u00e4n j\u00e4lkeen kuvataan tarkempaan tarkasteluun valitut tietokantatuotteet perus-tasolla ja keskityt\u00e4\u00e4n niihin osa-alueisiin, jotka liittyv\u00e4t indekseihin. Lopuksi vertaillaan samantyyppisten indeksien toteutusta valituissa tietokanta-tuotteissa. T\u00e4m\u00e4n kirjallisuuskatsauksen perusteella voidaan todeta, ett\u00e4 erilaisia indeksityyppej\u00e4 on paljon ja niiden m\u00e4\u00e4ritelm\u00e4t vaihtelevat hieman l\u00e4hteest\u00e4 riippuen. Vertailun perusteella voidaan my\u00f6s todeta, ett\u00e4 samantyyppisten indeksien toteutuksessa on havaittavissa teknisi\u00e4 eroavaisuuksia eri tietokantatuotteiden v\u00e4lill\u00e4.\r\n\u00a0\u00a0", "language": "en", "element": "description", "qualifier": "abstract", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Submitted by Seija Paananen (sepaanan@jyu.fi) on 2009-04-28T13:10:16Z\r\nNo. of bitstreams: 2\r\nJanne.Lusua.pdf: 902505 bytes, checksum: 0718e81e76a962e432df0d90764b70b5 (MD5)\r\nlicense.xml: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2009-04-28T13:10:16Z (GMT). No. of bitstreams: 2\r\nJanne.Lusua.pdf: 902505 bytes, checksum: 0718e81e76a962e432df0d90764b70b5 (MD5)\r\nlicense.xml: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "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": "tietokannan tehokkuus", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "indeksit", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "tietokannan hallintaj\u00e4rjestelm\u00e4", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "Indeksit ja niiden k\u00e4ytt\u00f6 MySQL- ja SQL Server -tietokantatuotteissa", "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-200904281522", "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": "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": "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"}]
|