SAP Sybase SQL Anywhere veebiteenused
Date
2013
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Tartu Ülikool
Abstract
Töö eesmärk oli uurida SAP Sybase SQL Anywhere andmebaasi veebiteenuseid ja luua ainele Andmebaasid (MTAT.03.264) vastavasisulised õppematerjalid. Püstitatud eesmärgid lõputööga saavutati.
Töö sisaldab veebiteenuste tutvustust ja näiteid. Lisaks veebiteenuste uurimisele käsitleb lõputöö ka SQL Anywhere veebiteenuste üht suuremat probleemi, veebiteenuste probleemne koostöö dünaamiliste SQL päringutega. Probleem seletati täpsemalt lahti ning toodi välja üks võimalik lahenduse viis koos näidetega. Lõputöö käigus valmistas autor sisuka õppematerjali, mis on koostatud wiki formaadis. Materjal sisaldab teooriat, hulgaliselt näiteid, veebiteenuste ja dünaamilise SQL päringute probleemi tutvustus koos ühe võimaliku lahendusega, veebiteenustega seotud ülesandeid ja lahendusi. Õpematerjal on koostatud viisil, et õppejõul oleks võimalus kasutada seda vastavalt vajadusele.
Autori arvates on SQL Anywhere andmebaasi veebiteenuste loomise funktsionaalsus hea alternatiiv traditsioonilistele liidestele nagu JDBC ja ODBC. Andmebaasi veebiteenustega saab lihtsasti luua SOAP veebiteenuseid ja lihtsamaid veebiliideseid. Olukorras, kus andmebaasil on vaja pakkuda või tarbida veebiteenuseid, on andmebaasisiseste veebiteenuste kasutamine küllaltki õigustatud - andmetele pääsetakse otse ligi ja ei ole vaja andmebaasi serverile lisada muid väliseid komponente.
The goal of this bachelor thesis is to research SAP Sybase SQL Anywhere web services and to put together study materials for Database course in University of Tartu. SQL Anywhere is a relational database management system with a built in database. SQL Anywhere has the functionality to create and use web services inside the database without any external help from other applications. The thesis introduces and explains how SQL Anywhere web services work and how they are created. Creation syntax is explained thoroughly and examples are used to show how web services work. SQL Anywhere web services have a problem working alongside with dynamic SQL query executions. This problem is shown and explained in the thesis. One possible solution to this problem is introduced. The solution is explained and shown to work with examples. During the research the author compiled study materials for the Database course. The material is written in wiki format using PmWiki wiki engine. This ensures the compatibility with Tartu University's computer science institutions courses webpage, which also uses PmWiki for it’s wiki engine. The study material consists of theory, several examples, web service and dynamic SQL problem’s explanation and solution, exercises for students and solutions for the exercises. The material can be used according to need. The course lecturer could use all the material or select only some parts depending on how much the students should know.
The goal of this bachelor thesis is to research SAP Sybase SQL Anywhere web services and to put together study materials for Database course in University of Tartu. SQL Anywhere is a relational database management system with a built in database. SQL Anywhere has the functionality to create and use web services inside the database without any external help from other applications. The thesis introduces and explains how SQL Anywhere web services work and how they are created. Creation syntax is explained thoroughly and examples are used to show how web services work. SQL Anywhere web services have a problem working alongside with dynamic SQL query executions. This problem is shown and explained in the thesis. One possible solution to this problem is introduced. The solution is explained and shown to work with examples. During the research the author compiled study materials for the Database course. The material is written in wiki format using PmWiki wiki engine. This ensures the compatibility with Tartu University's computer science institutions courses webpage, which also uses PmWiki for it’s wiki engine. The study material consists of theory, several examples, web service and dynamic SQL problem’s explanation and solution, exercises for students and solutions for the exercises. The material can be used according to need. The course lecturer could use all the material or select only some parts depending on how much the students should know.