| fullrecord |
[{"key": "dc.contributor.author", "value": "Autio, Janne", "language": null, "element": "contributor", "qualifier": "author", "schema": "dc"}, {"key": "dc.date.accessioned", "value": "2009-04-30T05:48:50Z", "language": null, "element": "date", "qualifier": "accessioned", "schema": "dc"}, {"key": "dc.date.available", "value": "2009-04-30T05:48:50Z", "language": null, "element": "date", "qualifier": "available", "schema": "dc"}, {"key": "dc.date.issued", "value": "2007", "language": null, "element": "date", "qualifier": "issued", "schema": "dc"}, {"key": "dc.identifier.uri", "value": "https://jyx.jyu.fi/handle/123456789/19998", "language": null, "element": "identifier", "qualifier": "uri", "schema": "dc"}, {"key": "dc.description.abstract", "value": "Jyv\u00e4skyl\u00e4: Jyv\u00e4skyl\u00e4n yliopisto, 2007.\r\n34 s.\r\nKandidaatintutkielma\r\nLyhenne PL/SQL muodostuu sanoista Prosedural Language / Structured Query\r\nLanguage. Kyseinen ohjelmointikieli on k\u00e4yt\u00e4nn\u00f6ss\u00e4 Oracle-sidonnainen,\r\nproseduraalinen kieli (prosedural language), toisin kuin sen taustalla oleva\r\nkuvaileva (declarative) SQL-kieli. PL/SQL-kielt\u00e4 alettiin kehitt\u00e4\u00e4, koska Oracletietokantasovelluksen\r\nyhteyteen tarvittiin t\u00e4sm\u00e4lleen sen tarpeita vastaava\r\nproseduraalinen lis\u00e4 SQL-kieleen. Tarkoituksena oli mahdollistaa\r\nproseduraalisen koodin suorittaminen, joka voisi sis\u00e4lt\u00e4\u00e4 muun muassa\r\nehdollisia, iteratiivisia ja jaksollisia k\u00e4skyj\u00e4. PL/SQL-kieli on kehitetty\r\nmonipuoliseksi v\u00e4lineeksi l\u00e4hinn\u00e4 Oracle-tietokannan k\u00e4ytt\u00f6\u00e4 varten, ja t\u00e4t\u00e4\r\nk\u00e4ytt\u00f6tarkoitusta varten sit\u00e4 k\u00e4ytet\u00e4\u00e4n ja kehitet\u00e4\u00e4n edelleen aktiivisesti. Siit\u00e4\r\nl\u00f6ytyy useita oliopiirteit\u00e4 kuten kapselointi, funktioiden kuormitus ja tiedon\r\npiilotus, my\u00f6hemmiss\u00e4 versioissa my\u00f6s esimerkiksi periytyminen.\r\nSyntaksiltaan, rakenteeltaan ja datatyypeilt\u00e4\u00e4n PL/SQL muistuttaa pitk\u00e4lti\r\nADA-ohjelmointikielt\u00e4, joka on vuonna 1979 kehitetty korkean tason kieli.\r\nOracle-tietokantaa voidaan www-ymp\u00e4rist\u00f6ss\u00e4 k\u00e4ytt\u00e4\u00e4 PL/SQL-kielell\u00e4 mutta\r\nmy\u00f6s Javalla ja esimerkiksi .NET-ymp\u00e4rist\u00f6n tukemalla koodilla, mik\u00e4\r\ntilanteena antaa aihetta vertailla eri tekniikoita niiden soveltuvuuden ja\r\netuisuuksin kannalta Oraclen k\u00e4ytt\u00f6\u00e4 ajatellen. T\u00e4m\u00e4n tutkielman osalta\r\ntarkasteltava tietokantatyyppi on Oracle, ja sen tukemia ohjelmointitekniikoita\r\ntarkastellaan l\u00e4hinn\u00e4 PL/SQL-kielen n\u00e4k\u00f6kulmasta. Tutkielmassa k\u00e4yd\u00e4\u00e4n l\u00e4pi\r\nPL/SQL-kielen perusn\u00e4k\u00f6kulmia sek\u00e4 sivutaan sen erityispiirteit\u00e4 ja Oracletietokannan\r\nhallintaj\u00e4rjestelm\u00e4\u00e4n sidoksissa olevia ominaisuuksia. Lukijalle\r\npyrit\u00e4\u00e4n tarjoamaan k\u00e4sitys siit\u00e4, jolloin sit\u00e4 voi olla hy\u00f6dyllist\u00e4 k\u00e4ytt\u00e4\u00e4\r\nyleisesti toteutusvaihtoehtona tai esimerkiksi Javan sijasta, mutta esille tulee\r\nmy\u00f6s sen asettamia haasteita www-palveluiden tuottamisessa.\r\nTutkimusongelmana on selvitt\u00e4\u00e4, mill\u00e4 tavalla PL/SQL-kielt\u00e4 tyypillisesti\r\nk\u00e4ytet\u00e4\u00e4n ominaisuuksiensa puolesta tietokannan k\u00e4sittelyss\u00e4 ja erityisesti\r\nwww-ymp\u00e4rist\u00f6ss\u00e4. Tutkielmassa esitell\u00e4\u00e4n kyseisen kielen rakennetta ja\r\ntiettyj\u00e4 ominaisuuksia sek\u00e4 Oracle-tietokannan ja PL/SQL-kielen piirteit\u00e4 wwwsovelluskehityksess\u00e4\r\nyleisesti.\r\n \u00a0\u00a0\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-24T07:21:05Z\r\nNo. of bitstreams: 2\r\nJanne.Autio.pdf: 280457 bytes, checksum: 6cd493d7fef94e10541c6c69a5847990 (MD5)\r\nlicense.xml: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Approved for entry into archive by Marja-Leena Harjuniemi(mharjuni@cc.jyu.fi) on 2009-04-30T05:48:50Z (GMT) No. of bitstreams: 2\r\nlicense.xml: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)\r\nJanne.Autio.pdf: 280457 bytes, checksum: 6cd493d7fef94e10541c6c69a5847990 (MD5)", "language": "en", "element": "description", "qualifier": "provenance", "schema": "dc"}, {"key": "dc.description.provenance", "value": "Made available in DSpace on 2009-04-30T05:48:50Z (GMT). No. of bitstreams: 2\r\nlicense.xml: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)\r\nJanne.Autio.pdf: 280457 bytes, checksum: 6cd493d7fef94e10541c6c69a5847990 (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": "www-sovellus", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "paketti", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "proseduuri", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "Oracle", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.subject.other", "value": "PL/SQL", "language": "en", "element": "subject", "qualifier": "other", "schema": "dc"}, {"key": "dc.title", "value": "PL/SQL -kieli WWW-palveluiden tuottamisessa", "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-200904241499", "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": "Bachelor's thesis", "language": "en", "element": "type", "qualifier": "ontasot", "schema": "dc"}, {"key": "dc.type.ontasot", "value": "Kandidaatintutkielma", "language": "fi", "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": "restrictedAccess", "language": null, "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"}, {"key": "dc.rights.accessrights", "value": "This material has a restricted access due to copyright reasons.", "language": "en", "element": "rights", "qualifier": "accessrights", "schema": "dc"}, {"key": "dc.rights.accessrights", "value": "Luettavissa tekij\u00e4noikeudellisista syist\u00e4 vain Jyv\u00e4skyl\u00e4n yliopiston Tietojenk\u00e4sittelytieteiden laitoksella.", "language": "fi", "element": "rights", "qualifier": "accessrights", "schema": "dc"}]
|