Information System Development for Tartu Ujumisklubi
Name
Marko Tiidla
Abstract
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.
Graduation Thesis language
Estonian
Graduation Thesis type
Bachelor - Information Technology
Supervisor(s)
Vambola Leping
Defence year
2013