Optimizacija DW-a korištenjem Oracle OLAP 11g

Oracle OLAP (ex Express OLAP) je prva multidimenzionalna baza podataka. Nakon akvizicije, Oracle je počeo s ugradnjom Express OLAP engine u Oracle bazu (9i rel. 2). Svaka nova verzija je nudila sve veću integraciju relacijske i multidimenzijske baze. Oracle OLAP je jedini OLAP server koji je implementiran u samom kernelu baze, a ne kao odvojeni server. To mu daje brojne prednosti pred konkurentima počevši od jednostavnijeg backup-a, security-a i osvježavanja OLAP kocki, jednostavnijeg ETL-a, pristupanja OLAP-u korištenjem SQL-a, pa sve do Cube MV-ova i njihovo korištenje za query rewrite čime se mogu zamijeniti desetci postojećih MV-ova. Sve to uz moćan OLAP DML programski jezik, stavlja Oracle OLAP daleko ispred konkurentskih proizvoda.

DW optimization using Oracle OLAP 11g
Oracle OLAP (ex Express OLAP) is the first multi dimensional database. After the acquisition, Oracle has started to implement Express OLAP engine in his flagship database (starting with 9i rel. 2). With every new version, Oracle increase integration between relational and multidimensional engine. Oracle OLAP is the only one OLAP server that is tightly integrated in database kernel, unlike the other competitors which are offering OLAP server outside of database as a separate server. That is what is giving Oracle OLAP many advantages over the competitors starting with simpler backup, security and cubes refreshing, simpler ETL, accessing to OLAP engine from SQL, up to the Cube MV and its usage for query rewrite. With the last feature, it’s possible to replace dozens of MVs. In addition, with very powerful OLAP DML programming language, Oracle OLAP is far ahead of his competitors.

Detalji o predavanju

Vrsta: Radionica / Workshop

Razina težine: Srednje detaljno / Detailed

Poželjno iskustvo slušatelja: Iskusni (2-3 g.) / Experianced

Poželjna funkcija slušatelja:
DBA
Developer
Dizajner / Designer
Menadžer - operativni / Manager - Operational

Predviđeno vrijeme trajanja rada - aktivnosti: 30 - 60 minuta min

R03_Pojatina Optimizacija DW s OLAP.pdf 3,02 MB

Referat R03-Pojatina-OLAP.pdf 1,07 MB

O predavaču

Josip Pojatina

Agrokor ICT

Rođen sam 23.4.1969 u Zagrebu, gdje sam završio osnovnu i srednju školu (MIOC), te FER. Od samog početka radne karijere bavim se raznim disciplinama operacijskogoperacijskim istraživanjima (optimizacija planiranja proizvodnje, upravljanje logistikom, BI). Od 2005 godine intenzivno koristim Oracle bazu za koju posjedujem OCA certifikat. Okosnica mog Težište mog interesa rada s Oracle-om predstavlja optimizacija Oracle baze u velikim sustavima te BI.

I was born in April 23th, 1969 in Zagreb, where I’ve finished elementary, high school MIOC-Vladimir Popovic, and Faculty of Electrical Engineering and Computing (FER). From the beginning of my working career I’m dealing with various disciplines of operational research (like production planning optimization, logistic management, Business Intelligence etc.). From 2005 I’ve been constantly using Oracle database constantly, for which I own OCA certificate. Central interests of my working with Oracle database are database optimization in large environments and BI.