Veebiteenuste kasutamine SQL Anywhere andmebaasis
Files
Date
2011
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Tartu Ülikool
Abstract
Bakalaureusetöö eesmärk on koostada õppematerjalid, mis õpetaksid Andmebaaside kursusel olevatele tudengiteke kuidas kasutada veebiteenuseid. Töö on jagatud nelja põhilisse peatükki.
• Sybase ja SQL Anywhere tutvustus,
• veebiserveri ja veebiteenuste loomine ja nende kasutamine veebilehitsejas,
• näite ülesannete tegemine,
• tudengi andmebaasi hindamine.
Esimeses peatükis kirjeldatakse lühidalt Sybase ja SQL Anywhere ajalugu ning antakse ülevaade seisust tänapäeval. Selle peatüki eesmärk on näidata, et Sybase on pika ajalooga usaldusväärne ettevõte.
Teises peatükis on seletatud kuidas käivitada ja sulgeda SQL Anywhere’i sisse ehitatud http serverit. Kirjeldatakse veebiteenuste loomissüntaksit, koostatakse mõned näite veebiteenused ja näidatakse kuidas veebilehitsejas andmebaasi andmeid näha saab.
Kolmandas peatükis tutvustetakse andmebaasi mudeleid, mida kasutatakse Andmebaaside kursusel. Luuakse näite veebiteenused, näiteks andmebaasi tabeli kuvamine veebilehitsejas või uute andmete sisestamine andmebaasi.
Viimases peatükis näidatakse mugavat võimalust tudengi andmebaasi hindamiseks. Selleks tuleks luua funktsioonide ja veebiteenuse komplekt, mis muudab veebilehitseja interaktiivseks sql’iks. Sellega tekib õppejõududel mugav võimalus sisestada juba olemasolevaid kontrollfunktsioone tudengi andmebaasi ja seeläbi kontrollida tudengi andmebaasi õigsust.
Autori hinnangul ei ole andmebaasile veebirakenduste loomine kasutades vaid sql’i parim lahendus, kuid õppeeesmärkidel on see lihtne viis loomaks andmebaasile mingigisuguse kasutajaliidese. See on aga autori arvates väga oluline äratamaks tudengites suuremat huvi andmebaaside vastu.
The aim of this graduation work is to create learning material about making web services in database that allow accessing database by a web browser. The work is divided into four main chapters: • summary of Sybase and SQL Anywhere, • starting a http web server, creating web service and accessing them in web browser, • making example exercises, • student database evaluation. In the first chapter I give a brief history of Sybase and SQL Anywhere and also show where they are positioned today. The aim of this chapter is to shows that Sybase is a big and trustworthy enterprise with long history on its field. The second chapter explains how to start and stop the SQL Anywhere inbuilt http server. Gives and explains the syntax of web service and also gives some example web services. The chapter also shows how to access the web service via web browser. In the third chapter I introduce database models that are used in database course. Then I show same database specific exercises like writing a web service that shows some of the tables when called in web browser or creating a web service for inserting new lines into database table. In the final chapter a convenient way for evaluating student database is shown. For that a set of functions and web service that turn browser into interactive sql have to be inserted into database. Then lecturers can insert already existing control functions into student database with their own computer. In conclusion I would say that making web applications only with sql is not the best options. But for learning purposes it is a easy way to make some kind of user interface to your database, which in my opinion is essential to rise students interest of databases.
The aim of this graduation work is to create learning material about making web services in database that allow accessing database by a web browser. The work is divided into four main chapters: • summary of Sybase and SQL Anywhere, • starting a http web server, creating web service and accessing them in web browser, • making example exercises, • student database evaluation. In the first chapter I give a brief history of Sybase and SQL Anywhere and also show where they are positioned today. The aim of this chapter is to shows that Sybase is a big and trustworthy enterprise with long history on its field. The second chapter explains how to start and stop the SQL Anywhere inbuilt http server. Gives and explains the syntax of web service and also gives some example web services. The chapter also shows how to access the web service via web browser. In the third chapter I introduce database models that are used in database course. Then I show same database specific exercises like writing a web service that shows some of the tables when called in web browser or creating a web service for inserting new lines into database table. In the final chapter a convenient way for evaluating student database is shown. For that a set of functions and web service that turn browser into interactive sql have to be inserted into database. Then lecturers can insert already existing control functions into student database with their own computer. In conclusion I would say that making web applications only with sql is not the best options. But for learning purposes it is a easy way to make some kind of user interface to your database, which in my opinion is essential to rise students interest of databases.