Korištenje baza podataka pomoću rest servisa u oblaku

master's thesis

• Title (english): Use of data bases with rest services in the cloud
• Author: Ivana Škrtić
• Mentor: Katarina Ćurko (mentor)
• Committee member: Ivan Strugar (predsjednik povjerenstva)
• Committee member: Božidar Jaković (član povjerenstva)
• Granter: University of Zagreb; Faculty of Economics and Business; (Department of Informatics); Zagreb
• Defense date and country: 2020-09-16, Croatia
• Scientific / art field, discipline and subdiscipline: SOCIAL SCIENCES; Economics; Business Informatics

Abstract

Ovaj rad sastoji se od teorijskog i praktičnog dijela. U teorijskom dijelu opisani su RESTful i Big web servisi. Detaljno je objašnjena REST arhitektura i ograničenja, HTTP protokol i JSON format reprezentacije podataka. Opisano je računarstvo u oblaku, Oracle Cloud usluge i njihove specifičnosti. U praktičnom dijelu prikazana je primjena RESTful servisa na B2B aplikaciji prodaje. Objašnjena je tro-slojna arhitektura aplikacije, opisani su alati za razvoj i testiranje. Razvoj aplikacije je prikazan kroz faze: konceptualnog modeliranja, logičkog modeliranja i fizičkog modeliranja u relacijskoj bazi podataka. Aplikacija je implementirana u Oracle Cloud-u koristeći Oracle Cloud Free Tier (Always Free Services). Objašnjeno je postavljanje REST servisa na objektima baze podataka tablicama i pogledima. Prikazani su slučajevi korištenja: registracija kupaca, pregled kategorije proizvoda, grupa proizvoda, proizvoda, zadavanje narudžbi, praćenje narudžbi.

Abstract (english)

This paper consists of a theoretical and a practical part. The theoretical part describes RESTful web services and Big web services. The REST architecture and constraints, the HTTP protocol, and the JSON format of data representation are explained in detail. Cloud computing, Oracle Cloud services and their specifics are described. The practical part shows the application of the RESTful service on the B2B sales application. The three-layer architecture of the application is explained, the tools for development and testing are described. Application development is presented through the phases of conceptual modeling, logical modeling, physical modeling in a relational database. The application is implemented in Oracle Cloud using Oracle Cloud Free Tier (Always Free Services). The setting up of REST services on database objects with tables and views is explained. The use cases are shown: customer registration, product category overview, product group, products, placing orders, order tracking.

• Keywords: web servis; REST; HTTP; JSON; računalni oblak; Oracle
• Keywords (english): web service; REST; HTTP; JSON; cloud computing; Oracle
• Language: croatian
• URN:NBN: urn:nbn:hr:148:383689
• Study programme: Title: Business Economics; Study programme type: university; Study level: integrated undergraduate and graduate; Academic / professional title: magistar/magistra ekonomije (magistar/magistra ekonomije)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Open access
• Created on: 2020-09-17 19:35:23