Tartu Ujumisklubi infosüsteemi arendus
Date
2013
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Tartu Ülikool
Abstract
Ujumine on Eestis laialt levinud spordiala, mida harrastab spordiklubides üle Eesti pea 10 000 inimest. 2012/2013 hooaja seisuga on nende seas ka 738 litsentseeritud võistlussportlast. Osa nendest harrastajatest ning tõsistest sportlastest esindab võistlustel ka Tartu Ujumisklubi. Praegu säilitatakse iga-aastaselt võistlustel ujutud tuhanded tulemused kontoritarkvara failides, mis ei võimalda ujumishuvilisel mugavalt soovitud informatsiooni leida. Lisaks soovib Tartu Ujumisklubi oma sportlaseid nende tulemuste põhjal rühmadesse jaotada ning klubi rekordeid säilitada.
Probleemi lahenduseks valmis käesoleva bakalaureusetöö käigus Tartu Ujumisklubile infosüsteemi prototüüp, mille valmimiskäiku ning ülesehitust antud töö kirjeldabki. Infosüsteemi prototüüp valmis vastavalt Tartu Ujumisklubi juhatuse poolt esitatud nõuetele ning võimaldab tulemuste sisestamist, nende säilitamist ning kõikidele veebilehe külastajatele mugavat näitamist.
Infosüsteem võimaldab administraatoril pärast võistlusi peaaegu automaatselt kõik soovitud informatsioon andmebaasi sisestada. Selleks konverteeritakse Java Appleti abiga Microsoft Accessi andmebaas kasutaja arvutis SQLite andmebaasiks, loetakse sealt andmed ning saadetakse need JSON kodeeringus serverisse, kus toimub salvestamine.
Kõikidel veebikülastajatel on võimalik vaadata võistluste tulemusi, Tartu UK rekordeid, EUL järkude täitmise ning Rudolph-Tabelle punktide täitmise tabeleid. Lisaks näha kõikide infosüsteemis esinevate sportlaste kohta lühikest profiililehekülge.
Infosüsteemi loomiseks kasutati üldlevinud veebirakenduste loomise tehnikaid, mis võimaldavad nii töö autoril kui vajadusel mõnel teisel arendajal kerge vaevaga infosüsteemi arendust jätkata. Serveri loomisel kasutati PHP CodeIgniter raamistikku ning lähtuti mudel-vaade-kontroller arhitektuurist. Veebilehe ülesehituseks ning kujundamiseks kasutati Twitteri Bootstrap ning kohati ka jQuery UI raamistikke.
Infosüsteemi prototüübi edasiarendus sisaldab kõigepealt andmete muutmise võimalust ning konfliktide kõrvaldamise võimalust. Seejärel kliendi ja serveri vahelise suhtluse kiiruse ning andmebaasi päringute optimeerimist. Lõpuks tuleb läbi testida erinevate andmebaaside ning puudulike andmete korral infosüsteemi toimimine. Samal ajal saavad veebilehe külastajad infosüsteemi kasutada, kuid peavad mõistma, et kõik kuvatavad andmed ei pruugi olla tõesed.
Prototüüp on leitav internetis aadressil www.tuk.ee/is.
Swimming is a wide-spread sport in Estonia with around 10 000 people practicing in swimclubs over the country. There are also 738 licenced competitors for 2012/2013 season. A fair share of these swimmers are representing Tartu Ujumisklubi (Tartu swimclub, hereinafter TUK) at competitions. Thousands of results are stored every year in office documents for competitions. Such documents do not allow swim enthusiasts to conveniently find desired information. Also TUK would like to divide their members between different groups based on their results. To solve this problem a prototype of information system for TUK was developed during this thesis. The paper will give a description of the development as well as architecture of the information system. The prototype was designed following the requirements set by board members of Tartu Ujumisklubi. The information system enables administrators of the system to upload competition results using Java Applet to convert Microsoft Access Database files to SQLite databases, read required data and send it over to server using JSON encoding. The server was built using CodeIgniter framework for PHP and is based on model-view-controller architecture. The website was built using Twitter’s Bootstrap and jQuery UI. Such well known techniques and wide-spread frameworks allow developers to easily continue working on the system if required. Visitors of the information system’s webpage are able to view interactive results of competitions as well as records for Tartu Ujumisklubi. Furthermore, TUK team members’ results are compared to Rudolph-Tabelle times and ranks set by Swimming Federation of Estonia in order to group swimmers based on performance. There are also athlete specific profile pages that display athlete’s top five results based on FINA points as well as best results over all strokes, distances and pool types. Development of the prototype will continue with implementing functionality to make changes in the available data and eliminate conflicts. Also to improve performance of queries and communication speed between client and server. Finally, testing with several competition databases and with insufficient data needs to be done before promoting the information system to the public. Information system prototype for Tartu Ujumisklubi is available at website www.tuk.ee/is.
Swimming is a wide-spread sport in Estonia with around 10 000 people practicing in swimclubs over the country. There are also 738 licenced competitors for 2012/2013 season. A fair share of these swimmers are representing Tartu Ujumisklubi (Tartu swimclub, hereinafter TUK) at competitions. Thousands of results are stored every year in office documents for competitions. Such documents do not allow swim enthusiasts to conveniently find desired information. Also TUK would like to divide their members between different groups based on their results. To solve this problem a prototype of information system for TUK was developed during this thesis. The paper will give a description of the development as well as architecture of the information system. The prototype was designed following the requirements set by board members of Tartu Ujumisklubi. The information system enables administrators of the system to upload competition results using Java Applet to convert Microsoft Access Database files to SQLite databases, read required data and send it over to server using JSON encoding. The server was built using CodeIgniter framework for PHP and is based on model-view-controller architecture. The website was built using Twitter’s Bootstrap and jQuery UI. Such well known techniques and wide-spread frameworks allow developers to easily continue working on the system if required. Visitors of the information system’s webpage are able to view interactive results of competitions as well as records for Tartu Ujumisklubi. Furthermore, TUK team members’ results are compared to Rudolph-Tabelle times and ranks set by Swimming Federation of Estonia in order to group swimmers based on performance. There are also athlete specific profile pages that display athlete’s top five results based on FINA points as well as best results over all strokes, distances and pool types. Development of the prototype will continue with implementing functionality to make changes in the available data and eliminate conflicts. Also to improve performance of queries and communication speed between client and server. Finally, testing with several competition databases and with insufficient data needs to be done before promoting the information system to the public. Information system prototype for Tartu Ujumisklubi is available at website www.tuk.ee/is.