About Oracle Cloud Autonomous Data Warehouse

Ovaj rad sastoji se od teorijskog prikaza Oracle autonomnog skladišta podataka uz objašnjenje računarstva u oblaku i Oracle infrastructure u oblaku. Razrađene su značajke koje obilježuju Oracle ADW (end. Autonomous Data Warehouse), te iznesene prednosti njegova korištenja. U nastavku su opisani podatkovni alati, nakon čega slijedi praktični dio rada kroz koji je prikazana uporaba opisanih alata za učitanje, transformaciju, obradu i grafički prikaz rezultata. Dodatno je dana usporedba dva značajna dobavljača u oblaku: Oracle ADW i Amazon Redshift. U praktičnom djelu opisan je korišten skup podataka, dan je prikaz prethodno objašnjenih podatkovnih alata koje ADW nudi te su rezultati grafički prikazani. Svi koraci obrade potkrijepljeni su odgovarajućim vizualnim prikazima.This paper consists of a theoretical overview of the Oracle Autonomous Data Warehouse with an explanation of cloud computing and Oracle cloud infrastructure. Features that characterize Oracle ADW (end. Autonomous Data Warehouse) have been explained, and the advantages of its use have been presented. The data tools are described afterward, followed by a practical part of the work through which the use of the described tools for loading, transformation, processing, and graphical presentation of results is shown. Additionally, a comparison of two significant cloud providers is given: Oracle ADW and Amazon Redshift. In the practical part is described the used dataset. The previously explained data tools offered by ADW are presented, and the results are shown graphically. All processing steps are supported by corresponding visual representations