20.500.12556/RUL-72327 Adaptivni sistem za učenje jezika SQL Adaptive system for learning SQL language Dandanes je na seznamu ključnih kompetenc vsakega razvijalca programske opreme vsekakor moč zaslediti tudi poznavanje jezika SQL. Poglobljeno znanje pisanja poizvedb in obvladovanja osnovnih konceptov je ne le zaželeno, temveč pričakovano. Proces učenja jezika SQL študentom povzroča vrsto preglavic. V diplomskem delu smo se lotili lajšanja učenja pisanja poizvedb z izdelavo adaptivnega sistema za generiranje namigov. Sistem temelji na množici zgodovinskih podatkov preteklih poskusov reševanja tovrstnih nalog. Za inteligentno rabo znanja, skritega v podatkih, je bil uporabljen Markovski odločitveni proces, ki omogoča napovedovanje v negotovih razmerah. Poleg pametnega agenta smo razvili tudi komponento za procesiranje samega jezika SQL ter preprost spletni vmesnik. Rezultati testiranj so pokazali, da je razvit sistem zmožen ponuditi uporabne namige, prilagojene posameznemu študentu, in da obenem predstavlja dobro osnovo za nadaljnji razvoj na tem področju. Nowadays one can identify SQL proficiency as a key competence of any software developer. Broad knowledge of writing correct and efficient SQL queries is not only desired but also required. The process of SQL learning turns out to be anything but straightforward. With this thesis we have set to reduce the effort needed to learn SQL by developing a robust system for hint generation. The system is based on a set of historical data which represent past attempts at solving SQL related exercises. In order to use the knowledge hidden within such data, we have have used Markov decision processes which enable us to make predictions under uncertain circumstances. Next to the agent we have also developed a way to process SQL language and a simple web-based interface. Evaluation has shown, that the system is capable of offering useful hints which are tailored to individual students. We agree, that the system represents a solid foundation for future work in this field. inteligentni sistemi za učenje učenje jezika SQL Markovski odločitveni proces procesiranje jezika strojno učenje priporočilni sistemi intelligent tutoring systems SQL learning Markov decision process language recognition machine learning recommendation systems true false false [T. Matek] Slovenski jezik Angleški jezik Diplomsko delo/naloga 2015-09-12 04:43:34 2015-09-12 04:43:35 2024-08-29 04:16:00 0000-00-00 00:00:00 2015 0 0 70 str. 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 1536526275 1536526275 63120264-TADEJ_MATEK-Adaptivni_sistem_za_ucenje_jezika_SQL.pdf 63120264-TADEJ_MATEK-Adaptivni_sistem_za_ucenje_jezika_SQL.pdf 1 5EFC9D72BC77715357C82A7376A2992C 64f72d5127f207754dd95ea2d65d56924bd4d292446d9ce81590ea60f49e4d4c b5ef1d7e-6512-11ef-8f74-0050569b8976 https://repozitorij.uni-lj.si/Dokument.php?lang=slv&id=189096 Fakulteta za računalništvo in informatiko 0 0 0