Primjena Oracle SQL Developera u razvoju aplikacija

master's thesis

• Title (english): Application of Oracle SQL Developer in application development
• Author: Magdalena Modrušan
• Mentor: Robert Manger (mentor)
• Committee member: Robert Manger (predsjednik povjerenstva)
• Committee member: Zvonimir Bujanović (član povjerenstva)
• Committee member: Miljenko Marušić (član povjerenstva)
• Committee member: Mladen Jurak (član povjerenstva)
• Granter: University of Zagreb; Faculty of Science; (Department of Mathematics); Zagreb
• Defense date and country: 2020-09-29, Croatia
• Scientific / art field, discipline and subdiscipline: NATURAL SCIENCES; Mathematics

Abstract

U radu je opisan alat za rad s Oracle bazama podataka Oracle SQL Developer koji koristi Java Development Kit. Prva verzija ovog alata pojavila se na tržištu u ožujku 2006. godine te je otada jedan od najpopularnijih alata za manevriranje bazama podataka, ako ne i najpopularniji. Glavne prednosti su mu što se ne plaća te je jednostavan za korištenje. U trećem poglavlju ovog rada opisan je model baze podataka Europskih strukturnih i investicijskih fondova (ESI) te je isti realiziran koristeći Oracle SQL Developer i njegove bogate funkcionalnosti poput unosa podataka u bazu podataka izravno iz Microsoft Excel dokumenta. U zadnjem poglavlju baza iz trećeg poglavlja spojena je s Oracle Application Expressom te je stvorena popratna aplikacija koja služi za pregled korisnika i operacija Europskih strukturnih i investicijskih fondova.

Abstract (english)

This thesis describes a tool for working with Oracle databases, Oracle SQL Developer, which uses the Java Development Kit. The first version of this tool appeared on the market in March 2006 and has since been one of the most popular database managing tools, if not the most popular. Its main advantages are that it is free and it is easy to use. The third chapter of this thesis describes the European Structural and Investment Funds (ESI) database model. It is implemented using Oracle SQL Developer and its rich functionalities such as entering data into the database directly from the Microsoft Excel documents. In the last chapter, the database from the third chapter was merged with Oracle Application Express and an accompanying application was created for overview of the users and operations of the European Structural and Investment Funds in Croatia.

• Keywords: Oracle baza podataka; Oracle SQL Developer; Java Development Kit; baze podataka Europskih strukturnih i investicijskih fondova (ESI); Oracle Application Express
• Keywords (english): Oracle databases; Oracle SQL Developer; Java Development Kit; European Structural and Investment Funds (ESI) database model; Oracle Application Express
• Language: croatian
• URN:NBN: urn:nbn:hr:217:900441
• Study programme: Title: Mathematics and Computer Science Education; specializations in: Mathematics and Computer Science Education; Course: Mathematics and Computer Science Education; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra edukacije matematike i informatike (magistar/magistra edukacije matematike i informatike)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Open access
• Created on: 2021-03-01 13:53:03