jezik/language:language

Vrstni red predavanj je urejen po alfabetičnem vrstnem redu naslovov predavanj.

 

A Deep Dive into APEX JET Charts

Roel Hartman
engRoel Hartman
APEX Consultingace director

 

Abstract

In this session we will take a closer look on the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile to investigate.

You will learn that with just a few lines of JavaScript you can change the look and feel of a chart to your own needs.

Application Express 5.1 and beyond ...

Carsten Czarski
engCarsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

Application Express 5.1 is available since December 2016. Many users have already installed this new version which not only provides the new Interactive Grid or Oracle JET charts.

This presentation gives on overview on APEX 5.1 also highlighting the smaller features, which not everybody talks about. Beyond that the session will give a brief outlook on what's coming with future APEX releases.

Application Express and the REST of the world - Part 1,2

Carsten Czarski
engCarsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

Learn how to access REST services from within Application Express. The presentation will show, how to invoke a REST Service, how to process JSON or XML responses and how to build reports or charts on top of this. Finally, attendees will get an outlook on future trends regarding APEX and REST.

In the old days, things were simple: Data was in the (Oracle) database and APEX applications worked with that data. But today, we have to integrate data from different sources all the time. These data sources can be on the internal network, but also on the internet.

Today, the REST architecture is commonly used to interface between different systems: REST services are often provided, so we want to use these REST services with the Oracle Database and APEX applications. The presentation will give a brief introduction to REST, cover the building blocks to invoke REST Services and to process the response and finally put everything together in Application Express.

Arhitektura Oracle in SQL Server podatkovnih zbirk iz vidika restavriranja podatkov

Urh Srenik
engUrh Srečnik
Abakus plus d.o.o.

 

Abstract

V Abakusu kot Oracle DBA-ji večkrat naletimo na situacijo, da ima stranka več kot en tip podatkovne zbirke. V SQL svetu se kot konkurenca Oraclu najpogosteje pojavlja Microsoft SQL Server. Ker smo z našim produktom Deja Vu želeli zadostiti zahtevam strank, da bi na enoten način izvajali varnostno kopiranje različnih podatkovnih zbirk, smo letos za ta produkt razvili polno podporo tudi za SQL Server.

V letu dni, odkar smo začeli s tem projektom, smo se precej podrobno seznanili z razlikami in izzivi, ki jih različna tipa podatkovnih zbirk ponujata. Na predavanju bomo iz arhitekturnega in praktičnega vidika predstavil, kakšne te razlike so in kakšne prednosti prinaša eden ali drug.

Namen predavanja ni iskati boljše/slabše implementacije rdbms-ja. Namen je, da predvsem Oracle DBA-ji, ki imajo manj izkušenj z drugimi podatkovnimi zbirkami, dobijo vpogled v drugačen, še ne raziskan svet. Poleg tega bodo izkušenejši DBA-ji nedvomno dobili precej idej/vprašanj glede posledic, ki jih različne implementacije prinašajo. Te DBA-je po predavanju vabimo na pivo in nadaljnjo diskusijo.

Automate DBA Tasks With Ansible

Ivica Arsov

 

Abstract

Every time you find yourself doing the same thing over and over, have you asked your self: How can I automate this? Nowadays cloud vendors are a major driving force for automation in our industry.

This presentation focuses on the increasing role of automation and how it impacts the way Database Consultants and Administrator job is evolving. You will learn how you can decrease boring tasks and free up time for value-add work. We will take a detailed look at Ansible framework with which we can automate repetitive tasks.

Automating Oracle database administration, practical examples with Ansible

Ilmar Kerm
engIlmar Kerm
Kindred Groupace director


Mikael Sandstrm
Mikael Sandström
Kindred Group

 

Abstract

As the demand for Continuous Delivery and Cloud Computing increases, so to does the repatative nature of DBA work. This is where automation can help you. One of the most popular Devops Tools for automation is Ansible. Ansible allows you to automate workflows using YAML an easy to use language, that can also serve as documentation.

This session is a practical "no-slides" hacking session where the presenters will implement basic DBA workflows using Ansible automation software. The presented examples will give the audience the necessary skills to get started with Ansible so that they can implement their own custom workflows.

AWR Warehouse: the Good, the Bad and the Ugly

Patrick Jolliffe
engPatrick Jolliffe
Li & Fung Trading Ltd

 

Abstract

In the presentation we will start with some a high level overview of the functionality provided and how it enhances the feature-set of Enterprise Manager. We will discuss the licensing advantages of offloading historical AWR data and processing into a separate database instance.

Then we will review how the ETL process is actually implemented, particularly the tables which store metadata for the extract and load portions. Build on that we will provide some ideas about how to troubleshoot when things don't work as expected, and how to workaround some of the limitations of the product.

Back to the basics: TABLESPACES… but a little bit low level style

Kamil Stawiarski
engKamil Stawiarski
ORA-600 | Database Whisperersace director

 

Abstract

There are a lot of myths and legends about storing segments in tablespaces - should we keep indexes separated from the tables? Can we stop worrying about segment fragmentation? What is real difference between MOVE and SHRINK?

At this session I will present you my free C++ tool to visualize the contents of the datafile. We will disassemble a database block and try to understand how Oracle is really managing space inside tablespaces.

Backup z dodano vrednostjo

Boris Oblak
engBoris Oblak
Abakus plus d.o.o.

 

Abstract

Dodana vrednost backupa je nič, oziroma je celo negativna, saj so za njegovo delovanje potrebni viri (disk, trak, vzdrževanje, električna energija, ...), torej predstavlja strošek. Ali lahko vrednost backupu povečamo?

Klasičen backup je nepremičnina. Z njim ne moremo početi ničesar. Če ga želimo preveriti, moramo postaviti testni sistem in narediti obnovo podatkov. Za to pa potrebujemo čas in druge vire.
Se da backup narediti tako, da bi ga lahko uporabili? Lahko iz backupa na enostaven način vrnemo tabelo? Ga lahko uporabimo za izpis starih podatkov?
Kaj pa, če želimo narediti nek ad-hoc test? Lahko uporabimo backup tudi v načinu Read-Write? Je backup po takih posegih še uporaben?

Predstavljeno bo, kako naredimo backup, da ga kasneje lahko hitro uporabimo in mu s tem povečamo vrednost.

Predavanje bo zanimivo vodjem, ki jih zanima kako zmanjšati stroške, DBA-jem, ki imajo vedno premalo časa in razvojnikom, ker bi najraje razvijali na produkcijskih podatkih.

Be a Hero with Your DBA: Database Performance Tuning for Admins and Architects

Randal Sagrillo
engRandal Sagrillo
Oracle Corporation

 

Abstract

Be a hero with your DBA! Learn how to identify database key performance indicators, classify relevant workloads, and analyze AWR/STATSPACK reports to make meaningful recommendations for what is needed in your database system infrastructure to meet your performance service-level objectives. The methods discussed will apply equally to on-premises and cloud based infrastructure.

This technical session focuses principally on transactional and analytics workloads, with some discussion of data warehouse workloads.

Cloud security and personal data regulations

Michal Wypych
engMichal Wypych
ORACLE Poland

 

Abstract

In this session, you will learn about physical security, backup and disaster recovery. This will give you an overall overview of the architecture and data centre in which Oracle’s applications are hosted. You will learn about hosting policy, data privacy and contract guarantees. The presentation will show you Oracle’s approach to the security from the different points of view.

Common Pitfalls in Complex Apps Performance Troubleshooting

 

Abstract

Faced with a performance issue in complex systems people tend to look at things they find easy to get and interpret: CPU & IO usage, Load, Wait Events. The numbers may help in finding what is going wrong - *sometimes*, and hide the real issue easily.

This session is going to discuss simple things to remember while tackling performance issues in complex applications deployed in multiple tiers.

Deadlocks

Peter ampa
engPeter Čampa
Četrta pot d.o.o.

 

Abstract

Predavanje bo na temo deadlock-ov. Pogledali si bomo, v katerih situacijah pride do deadlock-ov, kaj nam sporoča tracefile, ki ga generira deadlock in kako ga pravilno interpretirati. Na praktičnih primerih bomo prikazali, kako pridemo do deadlock-ov in kaj lahko naredimo, da do njih ne pride več.

Design your databases straight to the Cloud

Heli Helskyaho
engHeli Helskyaho
Miracle Finland Oyace director
Elise Valin Raki
Elise Valin-Raki
Fenniaace director

 

Abstract

Everybody is talking about Cloud. How does the Cloud change my work as a database designer? What should I know and what new to learn?

In this session we will talk about these concerns and design a small database to the cloud using Oracle SQL Developer Data Modeler and Oracle SQL Developer.

dNFS for DBA's

 

Abstract

Direct NFS is an Oracle implementation of the standard NFS protocol inside Oracle Database. Using this native solution Oracle instance is able to better handle IO traffic and bypass a kernel layer of operating system. dNFS is commonly used for Exadata backups into ZFS Appliance and for Oracle databases using a NFS based solutions (like NetApp or Delphix ).

The goal of this presentation is a show DBA’s what is a Direct NFS, how to configure, use and monitor it. Proper configuration and monitoring are important to achieve a maximum performance and easy problem diagnostic. There will be examples of configuration with and without direct NFS.

NFS protocol is based on the TCP/IP protocol and this presentation will also show a recommended configuration of the TCP stack and explain how network should be monitored.

Dobre prakse pri reševanju izzivov upravljanja identitet

Matja Premerl
engMatjaž Premerl
Unistar LC d.o.o., Ljubljana

 

Abstract

Pri upravljanju identitet je izbor avtoritativnega vira ključnega pomena. Na primeru dobre prakse na tehnični univerzi na Cipru, vam bomo z rešitvijo Oracle Identity Manager povedali, kako smo se lotili posameznih podatkovnih virov in kako smo jih postopoma vključevali v sistem upravljanja identitet.

Z rešitvijo sedaj tehnična univerza razpolaga z možnostjo upravljanja virov na centraliziran način in z vnaprej definiranimi pravili in tako končni uporabniki posameznih sistemov vedno razpolagajo samo z ustreznimi pravicami, kar bomo prikazali tudi na uporabniškem portalu z možnostjo pregleda in »nakupovanja« posameznih informacijskih virov, vključno z možnostjo potrjevanja zahtevkov, kjer se vključuje tudi rešitev Oracle SOA za potrebe določanja poslovnih pravil.

Docker for Dummies

Roel Hartman
engRoel Hartman
APEX Consultingace director

 

Abstract

You might (or might not) have heard of Docker. But you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon.

In this session you'll learn what Docker is and how you can benefit from it in your daily work.

Efficient Test Data Management

 

Abstract

Testing is an important part of every development projects unfortunately there are still projects that are not doing it right. Based on my experience two of the most common problems are: size of data and data accuracy. If test with production like data sets are performed at the end of time deployment cycle, in the pre production phase, cost and time used for fixing potential bugs will much higher than if same errors were found at the beginning of the deployment cycle. Both problems mentioned above are typically related to an infrastructure and/or organization issues.

Modern software and hardware solutions can address typical problems of cloning full data sets and provide an easy and cost effective solution for data cloning. But cloning a production data for testing will create another serious issue with has to be addresses. It’s data confidentiality and potential access to a sensitive data for development and testing teams. This issue has to be addressed with a data masking solution so data can be anonymized before released into non-secure zones.

This presentation want to address a necessity of providing a proper data to developers and testing team in the fast and reliable way. In addition to that integration of data management with a common code control mechanism will be presented.

Ensure Performance Stability when Upgrading Databases

Mike Dietrich
engMike Dietrich
Oracle Corporation

 

Abstract

The biggest fear of DBAs upgrading or migration database is bad performance afterwards.

This presentation will guide you through a simple and straight forward approach to ensure performance stability when upgrading or migrating Oracle database from one release to another. It will also talk about know pitfalls and how to avoid them successfully.

Extending your HCM Cloud Self Service is as simple as ABC(S)

Debra Lilley

 

Abstract

Application Builder Cloud Services is the Low-Code Development solution for extending Cloud Applications, without the need for deep technical knowledge.

This presentation will include a live demo to build a simple application, using Cloud HCM APIs to extract the core data, and how to integrate the running of the application, seamlessly from within HCM and finishing with a quick mobile app.

From 0 to APEX - APEXify your Newbies

Dietmar Gabauer

 

Abstract

Experienced APEX developers are rare on the market - let's educate some! This presentation gives an overview, how FOEX enlarged the development team.

What is APEX? What's needed in addition? SQL, PL/SQL, HTML, CSS, JavaScript......what else? How can this be trained? How do I phase-in a new, basic trained employees into running project work? Answers to these questions are out of our experience in phasing in new employees and employees having different knowledge.

Function Result Cache - Fixed.

 

Abstract

On troubleshooting a particularly Complicated PL/SQL-based system, a so-called thick-db system, we found that the Function-Result-Cache did not work as advertised. A Colleague found the cause, and devised an inventive Fix.

This presentation is must for developers struggling with over-complicated systems, and for the architects that design them. We can help you avoid some Mistakes.

Histograms are Evil like Chocolate is Evil

Neil Chandler
engNeil Chandler
Chandler Systemsace director

 

Abstract

Continuous Delivery is a topic that can become very complex in big environments - but starting with this subject is not that difficult as many may think.

Are you using Histograms? Yes, of course you are - even if you didn't know it. Did you want to use them? Are they helping you get to the optimal optimization plan, or making life harder for the optimizer? I will explain the benefits and threats associated with histograms, how the new 12.2 histogram types make them more acceptable, where they are still a threat and how I usually handle them for greatest benefit in large systems.

How to build the perfect dashboard

Pavel Glebov
engPavel Glebov
FRT Consulting GmbH

 

Abstract

Dashboards have become a standard business and operations tools. Unfortunately, many of them are overloaded and difficult in daily use.

This presentation covers high-level know-how to build focused, thoughtful, and user-friendly dashboards. Namely it includes base principles and graphical design, explanation of practical usage of APEX components, Charts, JET-technology, and Plugins. Also the approaches to modify Oracle DB, using both well-known and newest 12C features, to get answer almost in real-time are described.

Implementing incremental forever strategy for Oracle database backups

Ilmar Kerm
engIlmar Kerm
Kindred Groupace director

 

Abstract

When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time and resources, but more importantly the same also applies to restores. RMAN has always provided a solution as incrementally updated image copies, but they are much less manageable than backupsets.

This presentation goes into detail on how to successfully implement incremental-forever database backup strategy together with a capable storage system like Netapp or ZFS Storage Appliance, and on how to build more advanced features on top that platform, like automation and cloning.

It's a Disaster! Making it better with FarSync and Fast Connect Failover

Neil Chandler
engNeil Chandler
Chandler Systemsace director

 

Abstract

When sat in a meeting discussing Recovery Point Objectives and Recovery Time Objectives, the CIO will always say "No Downtime! No Data loss!"

What is the most effective way of approaching this hard-to-achieve goal? How did we minimise downtime and data loss?

This presentation shows how we reached the decision points for the application, which options were discarded and the final implementation of technology to approach the requirements.

And what simply was not possible without application re-engineering.

Izgradnja modernih aplikacij z uporabo API, mikrostoritev in klepetalnih robotov

Toma Potuvan
engTomaž Poštuvan
Oracle Software d.o.o.

 

Abstract

Časi, ko se je razvoj programske opreme štel v mesecih, pisanje popravkov pa v tednih, so minili. Nove verzije aplikacij se razvijajo in nameščajo večkrat na dan, včasih celo večkrat na uro. Arhitekturne zasnove teh aplikacij niso več monolitne, temveč temeljijo na mikrostoritvah ter enostavnih protokolih za komunikacijo med njimi. Razvijalci razvijajo moderne aplikacije, ki so dostopne uporabnikom preko različnih kanalov. Normalno je, da se uporabniška izkušnja ne menja, če namesto klasičnih računalnikov uporabimo kar svojo mobilno napravo, bodisi tablico bodisi kar pametni telefon.

Pristop »Najprej API« (API first), kjer najprej razvijemo programski vmesnik API, šele nato pa nad njim aplikacijo, postaja vedno bolj dominanten. Istočasno je tudi kritičen, saj združuje med seboj vse komponente sistema ter omogoča, da aplikacije, razvite za oblak (»Cloud native«), lažje dostopajo do podatkov in procesov. Služi tudi kot način komunikacije med razvijalci zalednih (back end) in čelnih (front end) aplikacij.

V predstavitvi si bomo ogledali, kako moderne aplikacijske platforme omogočajo razvijalcem, da enostavno gradijo ter povezujejo spletne ali mobilne aplikacije, le-te pa uporabljamo na različnih napravah."

Kako vzpostaviti APIje in jih povezati z zalednimi sistemi z uporabo Oracle API Platform in Integration Cloud Service

MatjazBJuric
engdr. Matjaž B. Jurič
UL FRI, Java Championace director


RokPovse
Rok Povše
Sunesis

 

Abstract

Kako pomembno je v digitalni ekonomiji vzpostaviti APIje (in s tem temelje za API ekonomijo) ter jih učinkovito povezati z zalednimi sistemi, verjetno ni potrebno posebej poudarjati. Danes je splošno sprejeto, da je v ta namen na strani IT potrebno vzpostaviti okolje za upravljanje API-jev ter integracijsko platformo. V predstavitvi si bomo ogledali oblačni storitvi, ki jih ponuja Oracle pod imenoma API Platform Cloud Service in Integration Cloud Service ter prikazali, kaj ponujata in ovrednotili, kako s temi orodji uspešno nasloviti zgornje cilje.

Kakšno varnostno kopiranje potrebuje vaša podatkovna baza?

Primo Bedra
engPrimož Bedrač
Oracle Software d.o.o.

 

Abstract

Pristopov k varnostnemu kopiranju je Oracle podatkovne baze je veliko, kateri izmed njih je najbolj ustrezen pa vedno predstavlja svojevrsten izziv. Oracle kot proizvajalec podatkovne baze in strojne opreme ponuja tudi rešitve za njeno varnostno kopiranje. Kot proizvajalec podatkovne baze je Oracle v določeni prednosti, saj lahko ponudi tudi koncepte in tehnologije, ki jih ostali proizvajalci ne morejo. V zadnjem času se je obstoječim rešitvam pridružila še možnost varnostnega kopiranja v Oracle Cloud.

Kreiranje Word docx dokumentov iz podatkovne baze

Zoran Tica
sloZoran Tica
ZT-TECH

 

Abstract

V predavanju bom predstavil metodo kreiranja Microsoft Word docx dokumentov neposredno iz podatkovne baze z uporabo PL/SQL package-a, katerega sem razvil za potrebe mojih projektov. Najprej bom razložil način izvedbe in delovanje programske logike, potem pa uporabo na konkretnih primerih. Kreiranje dokumentov neposredno iz podatkovne baze se je pogosto izkazalo kot zelo uporabno, ker za samo izvedbo niso potrebna nobena dodatna zunanja orodja ali tehnologije, LE PL/SQL znotraj podatkovne baze.

Little Red Riding Hood and GDPR : Who’s afraid of the big GDPR

Philippe Fierens

 

Abstract

Wikipedia states :

The General Data Protection Regulation (GDPR) (Regulation (EU) 2016/679) is a regulation by which the European Parliament, the Council of the European Union and the European Commission intend to strengthen and unify data protection for all individuals within the European Union (EU). It also addresses the export of personal data outside the EU. The primary objectives of the GDPR are to give citizens and residents back control of their personal data and to simplify the regulatory environment for international business by unifying the regulation within the EU.

What does this mean for the Oracle DBA how can he help his company to be compliant with this regulation ? Which Oracle products can help you with this difficult task. This session will be a mix between practical experience and theory. Both speakers worked at a highly secured complex banking environment

Managing decisions in real time using Oracle Real Time Decisions

 

Abstract

Oracle Real-Time Decisions (RTD) is adaptive, real-time decision management solution, which uses a combination of your explicitly defined business rules and automatically identified statistical information to deliver the best possible content to your customers for every single interaction. Real-time analytics can be incorporated in any type of business process or customer interaction and provide the best offers and recommendations for each and every customer.

Moving traditional procurement process to the Cloud

Simon Jurecic
engSimon Jurečič
OSIR-ERPIS, d.o.o.

 

Abstract

Typical procurement process, many would say „how complex could it be“. Company needs some goods or services, so just prepare RFQ, send it to potential suppliers and choose the „best one“. But the truth behind that process is much more complex than that.

Who are potential suppliers for some goods or services, do you know which suppliers are qualified to deliver some goods or services, based on what criteria will you decide which one is „the best“, price and delivery term are just one part of the criteria,... If your company is obligated to perform procurement according to public procurement process, every step of the process must be conducted according to strict law requirements.

This presentation will give you an overview of a complete software solution which will support your complex business processes in Procurement part.

One click to rule them all - Continuous Delivery for everyone in 45 minutes

Christian Klingbacher
engChristian Klingbacher
Altran Concept Tech GmbH

 

Abstract

Continuous Delivery is a topic that can become very complex in big environments - but starting with this subject is not that difficult as many may think.

The purpose of this presentation is to show, how fast and easy APEX Applications can be deployed automatically to different environments with only one click. Using Git, Apache Maven, and Atlassians´ Bitbucket, it will be demonstrated how to setup and run a complete deployment pipeline by the creation of only two text files. Furthermore, it will be shown how any Docker image can be used and configured as basis for the deployment process.

Until the end of the presentation the attendees will receive a comprehensive step-by-step description of how to introduce and maintain their own Continuous Delivery for their APEX applications.

Oracle 12.2 funkcionalnosti za DWH & BI

Robert Koroec
engRobert Korošec
Oracle Software d.o.o.

 

Abstract

Opis in demosntracija Oracle 12.2 funkcionalnosti za DWH & BI:

  • Analytical Views.
  • In-Memory 12.2 (Join Groups, In-Memory Exspressions).
  • Attribute Clustering.
  • Integracija s Hadoop (BigData SQL).
  • Exadata (Columnar Flache Cache, Zone Maps, ...).

Oracle 12.2 Datatabase - novosti

Robert Koroec
engRobert Korošec
Oracle Software d.o.o.

 

Abstract

Na verzijo Oracle 12.2 smo v Oracle ekosistemu čakali nekaj let in sedaj je čas, da si podrobneje pogledamo, katere novosti prinaša Oracle 12.2 primarno za Administratorje kot tudi tudi za razvijalce za čim boljšo izrabo vseh funkcionalnosti v Oracle 12.2

Oracle 12c for Developers

Alex Nuijten
engAlex Nuijten
all APEXace director

 

Abstract

Do you want to get up to speed with the most current release of the Oracle database? Then this session is for you.

You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle database 12c than just pluggable databases.

Oracle Analytic Cloud

iga Vaupot
engŽiga Vaupot
Qubix Svetovanje


Mojca Gros
Mojca Gros
Qubix Svetovanje

 

Abstract

Oracle Analytic Cloud (OAC) je integrirana platforma za poslovno analitiko, ki vključuje ključna 3 orodja poslovne analitike: Oracle Business Intelligence Cloud Service, Oracle Data Visualisation Cloud Service in Essbase Cloud Service.

OAC je oblačna storitev, ki vključuje vse ključne funkcionalnosti orodij, ki se jih sicer lahko uporablja v "on-premise" različici, pri čemer pa je ključna lastnost, da je mogoče celotno rešitev iz "on-premise" okolja preseliti v oblak, kjer deluje praktično brez sprememb, če odmislimo ponastavitve povezav do baz podatkov. Je pa v vseh orodjih v oblaku opazen bistven premik k poenostavljenju določenih funkcij orodij tako, da so le ta postala enostavnejša in bolj prijazna za uporabo. Na ta način lahko že malo bolj napredni uporabniki izdelajo zahtevnejše rešitve, kar v "zemeljski različici" orodij ni mogoče.

Oracle Enterprise Metadata Management – comprehensive metadata management platform

 

Abstract

Trying to find an answer to a question which data is used by which application, can be a real challenge for number of companies, due to the proliferation of different IT technologies, tools, applications and systems that companies have in place. So, tracking the data to its source, i.e. performing impact analysis is many times very difficult exercise even for a trained IT personnel, and mission impossible for business users.

Oracle Enterprise Metadata Management (OEMM) is here to help. OEMM is a comprehensive metadata management platform, which can "harvest", i.e. reverse engineer and catalog metadata from virtually any metadata provider, including relational, Hadoop, ETL, BI, data modeling, and number of others.

Oracle Innovation Management Cloud Service @ Addiko Bank BiH

Nihad Velagi
engNihad Velagić
Core d.o.o.


unknown user
Adi Hadžiosmanović
Addiko Banka (BIH)

 

Abstract

In December 2016 Addiko BH has selected the Oracle Idea and Innovation Management Cloud solution for the management of their innovation process. Implementation was carried out by company CORE d.o.o. as a specialized Oracle partner for Cloud implementation. The scope of the project included the process of nominating ideas by employees, analyzing and approving ideas, and developing project proposals for adopted ideas. The users also have the option of managing the portfolio of innovations through which the user can analyze the compatibility of the proposed innovations with the strategic and operational goals of the organization. The implementation was completed within the deadline and the users went into production since mid-April.

At the end of the year, concrete results and effects of the implemented solution Oracle Cloud Idea & Innovation Management in Addiko BH will be available.

Oracle Keynote

duncan harvey
engDuncan Harvey
Oracle Corporation, Business Development Sr. Director, EMEA Cloud Platform

 

Abstract

To be defined.

Oracle Next Generation Cloud Infrastructure Platform

Uro Beoanin
engUroš Beočanin
Oracle Software d.o.o.

 

Abstract

Oracle’s next generation cloud infrastructure platform brings together best practices and learnings from nearly a decade of public cloud IaaS. The combination of virtualized network, mix of bare metal and VMs, interoperable infrastructure stack in public cloud or cloud at customer, all together with advanced governance and management capabilities, brings to market a highly competitive public cloud IaaS option for the enterprise market.

We will present Oracle cloud infrastructure platform from technical and customer use-case point of view.

PaaS4SaaS demo case

Michal Wypych
engMichal Wypych
ORACLE Poland


Marcin Podwojski
Marcin Podwojski
ORACLE Poland

 

Abstract

This presentation will guide through extensibility of the functionality in Innovation Management using Mobile Cloud Service. This live workshop of the application development will give step by step instruction how to create the mobile application. Using online integration with Innovation Management, the solution will be shown in action.

Pimp my grid

Marko Goriki
engMarko Gorički
BiLog d.o.o.

 

Abstract

We all waited a long time for "the grid" feature. Now when it's finally there it's time to use it in your projects. Is it ready for this?!

In this presentation I'll talk about my experience with the first project where I've used Interactive grid and I'll try to dig a bit deeper to show you some of the advanced features.

Regular Expressions: Say What?

Alex Nuijten
engAlex Nuijten
all APEXace director

 

Abstract

It has been possible since Oracle database release 10, Regular Expression support with its own set of functions. But getting started with Regular Expressions is not easy. Most database developers would avoid them if at all possible. With current release of the Oracle database, Regular Expression syntax becomes more important. You can use them to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause.

This session covers the basic syntax and gives you an easy introduction with Regular Expressions with plenty of code samples.

Return On Investment of Data Governance – A Megatrend On Discipline Around Data Management

Tomas Vavra

Milomir Vojvodic
Oracle

 

Abstract

Market success now depends on data integration speed. We collected the best practices from the most advanced IT leaders and built this presentation as a scientific elaborate to prove ROI of Data Governance elements and how exactly they are:

  • Increasing confidence in decision making.
  • Decreasing the risk of regulatory fines.
  • Maximizing the income-generation-potential of data.
  • Minimizing or eliminating re-work.

Revizijska sled z Flashback Data Archive

Sunil Jayasinghe
engSunil Jayasinghe
Nova KBM d.d.

 

Abstract

Predavanje o zelo aktualni temi hrambe in sledenju spremembam v bazi podatkov. Ena od obveznosti finančnih institucij (in tudi drugih) je hramba pomembnih podatkov ter zagotavljanje takoimenovane revizijske sledi. Flashback Data Archive (FDA) funkcionalnost baze 11g omogoča samodejno shrambo vseh sprememb na izbranih tabelah za daljše časovno obdobje. Vse to se dogaja v ozadju brez intervecije s strani uporabnikov ali aplikacij. Arhivski podatki so dostopni z navadnimi SQL ukazi. Z uporabo FDA dokumentiramo zapisovanje in spreminjanje zapisov v celotni življenjski dobi revizijske sledi, od izvornega zapisa do trenutno veljavnega zapisa. Iz revizijske sledi je razvidno, kakšna operacija je bila izvedena nad posameznim zapisom, s katerimi podatki in kdaj. Od Oracle verzije 12g pa dodatno še podatek o tem, kdo je spremembo izvedel .

Na predavanju bomo predstavili:

  • opis tradicionalne in najpogostejše metode sledenju spremembam z uporabo triggerjev v bazi,
  • predstavitev napredne metode z uporabo FDA,
  • konfiguracija in vklop FDA,
  • primer uprabe FDA,
  • prednosti/slabosti obeh metod,
  • kompresija zgodovinskih tabel (vrstic, LOB polj, deduplikacija LOB polj),
  • izvoz/uvoz zgodovinskih tabel.

So, my query plan says "Table Access Full" - what happens next?

 

Abstract

For some reports the fastest way to get them done is to use an index to go straight to the rows of interest, but sometimes the only way that makes sense is to scan the entire table. I'm the Oracle Architect for Smart Scan and the engineer in Oracle co-responsible for the table scan driver and this talk will show what happens under the covers in simple easy to understand steps.

We will look at (1) what is a granule in PQ (2) how exactly does the system decided whether to use buffer cache to direct read, (3) how is physical I/O done including Multi-Block reads and Async-I/O (4) what wait events and stats to look at (5) what tuning options are available to the DBA, and (6) for the truly curious how to trace what is happening.

SSD in Oracle

Sergej Roman
engSergej Rožman
Abakus plus d.o.o.

 

Abstract

Približno 10 let se v podjetju Abakus plus že srečujemo s SSD diski, ko smo v enem od poznanih podjetij nanje prvič namestili Oracle zbirko podatkov. O SSD diskih se je od takrat nabralo ogromno izkušenj. Začetni vtisi so bili zelo navdušujoči, sčasoma pa so se pokazale tudi nekatere slabosti.

Največja prednost uporabe SSD diskov je, da zbirkam podatkov zagotovijo neverjeten pospešek. Tudi cena je že zelo sprejemljiva. Slabosti naj zaenkrat ostanejo skrivnost in jih bomo razkrili na predstavitvi. Predstavili bomo tudi nekaj dobrih praks, s katerimi se težavam lahko vnaprej izognemo.

V splošnem pozitivne izkušnje prevladujejo nad slabostmi in danes SSD diske uporabljamo praktično povsod. Nedavno smo s SSD diski v infiniband SAN diskovnem sistemu lastne proizvodnje dosegli nove rekordne rezultate. Paket iz zbirke podatkov dbms_resource_manager.calibrate_io je pokazal pretočno hitrost prek 3 GB/s in 150.000 IO operacij na sekundo pri zakasnitvi 0 ms.

The journey of a BI database stack to the cloud

 

Abstract

BI is and can be a complex matter in big organisations. This presentation will tell the story about a strategic business decision to move the on premise BI stack to the Microsoft Azure cloud. The main focus is on how the Oracle Database is moved as the application servers were moved using a lift and ship mechanism.

This presentation will cover: - how we managed to move +300TB divided over several multi Tb databases to the cloud, - which services were chosen to run the database servers and why, - how performance testing and sizing has been done - how automatic provisioning has been done for providing developers what they need in agreed SLA's, - how we dealed with the short deadline, - why the Azure Cloud was chosen over the Oracle cloud, - Cost savings?

The deadline of the project was end of the year 2016. This gives the opportunity to give you an insight in a very fresh project of the move to the cloud for a complete BI environment.

The new Oracle Release and Update Model

Mike Dietrich
engMike Dietrich
Oracle Corporation

 

Abstract

As of July 2017 Oracle changed its release and update model for the Oracle Database. But not even the release numbering changes, the entire schedule and naming for patches, BPs and PSU changes as well.

This presentation will shed some light on the new release and update model including recommendations for patches and how to find the most important patches for your environment.

Top 10 Features of Oracle SQL Developer everybody should use, even in the Cloud

Heli Helskyaho
engHeli Helskyaho
Miracle Finland Oyace director
Elise Valin Raki
Elise Valin-Raki
Fenniaace director

 

Abstract

Oracle SQL Developer is a tool every Oracle user should be using. In Oracle SQL Developer there are excellent features that will make your life easier, does not matter if you are a dba, a developer or a database designer.

There is plenty of great features for everybody, Learn about my favourite features that will hopefully make your life easier too and make you a more profitable member of your IT team.

All the demos in this session are performed in the Oracle Cloud.

Upgrade to Oracle Database 12.2 - Live and Uncensored

Mike Dietrich
engMike Dietrich
Oracle Corporation

 

Abstract

Upgrading a database works fine on Powerpoint. But how about a real upgrade?

This presentation will introduce the news around Database Upgrade to Oracle Database 12.2 including the new preupgrade.jar. And the upgrade will be demonstrated live and interactively, on the command line and graphically with the DBUA.

Uporaba Oracle SaaS rešitve kot podpora finančno-računovodskih procesov v javnem sektorju

Adnan Crnica
engAdnan Crnica
Oracle Corporation

 

Faruk Jazic
Faruk Jazic
Oracle Corporation

 

 

Abstract

Računovodski sistem državnega aparata predstavlja enega od ključnih informacijskih sistemov v državi.

V BiH je od leta 2003 finančno računovodski sistem na ravni države, obeh entitet (Federacija BiH in Republika Srpska) in vseh 11 kantonov uspešno deluje na rešitvi Oracle eBusiness Suite.

SaaS rešitve predstavljajo naslednjo generacijo informacijskih sistemov, ki tudi uporabnikom v javnem sektorju prinašajo širok spekter dodanih vrednosti. Na drugi strani uporaba SaaS pristopa v javnem sektorju zahteva dodatno analizo in ustrezno strukturiranje projekta.

Srednjebosanski kanton je sprejel odločitev o prehodu finančno računovodskega sistema z Oracle eBS na Oracle ERP Cloud rešitev junija 2017. Projekt migracije rešitve je v teku.

Tema predavanja bo predstavitev razlogov in strukture projekta ter pričakovanih koristi uporabe ERP SaaS aplikacij v javnem sektorju v BiH.  

Utilizing the data attribute: Client-side behavior in APEX

Richard Martens
engRichard Martens
Smart4solutions BVace director

 

Abstract

Creating an APEX application is easy, just follow the wizards to create all those reports and forms. But what if you want to add some client functionality like deleting a record using a form, or do some 'drag-n-drop' ordering of records.

The presentation will show you how to add client side and AJAX functionality to your apps.

VOODOO - the black magic of cheep cross-database replication

Kamil Stawiarski
engKamil Stawiarski
ORA-600 | Database Whisperersace director

 

Abstract

The history why we wrote our own replication tool between Oracle and PostgreSQL with a bit of low level archivelog architecture explanation.

  • We shuld buy a bar!
  • Of course we should buy a bar!!! Brilliant why we didn't think about it earlier!?
  • Do you have a few hundred thousand euros?
  • A pint then?
  • A pint then.

We all want to have a bar and drive Porshe... But in most of the cases we can afford only a few pints and drive with VW. Replication engines are expensive and buying something like Golden Gate when you only have SE database and you want to replicate it to PostgreSQL is like buying a single malt to make Cola taste more bearable. That's why we wrote our own replicator tool. A simple one. A cheep one. Nothing fancy. But it works. And we will use this subject as an excuse to show some low level archivelog tricks.

What is new in Multitenant 12.2

 

Abstract

Oracle Multitenant was introduced in Oracle 12.1. and as any product of version 1 in Oracle family was very limited in functionality and suffered for many bugs. In 12.2 Oracle added missing functionality to multitenant thus making this functionality much more interesting than it was in 12.1.

In this session we will look at new features of Oracle Multitenant like provisioning capabilities, cloning PDB, refreshable PDBs, relocating PDBs, PDB local undo, flashback single PDB, different character sets in PDBs, improved resource management, Cross-Tenant Aggregation and more. If you had doubts why you should use Multitenant architecture in 12.1 then this session will probably change your opinion.

WORKSHOP: Oracle Data Visualisation

Mojca Gros
engMojca Gros
Qubix Svetovanje


iga Vaupot
Žiga Vaupot
Qubix Svetovanje

 

Abstract

Oracle je v zadnjih nekaj letih izjemno veliko napora vložil v razvoj novih orodij za vizualizacijo podatkov. Visual Analyzer v orodju Oracle Business Intelligence 12c ali Business Intelligence Cloud Service, Data Visualisation Cloud Service in Data Visualisation Desktop so različna imena orodij, vendar v bistvu gre za eno in isto orodje.

Na delavnici bomo predstavili, uporabniki pa bodo lahko praktično preiskusili orodje, različne tipe vizualizacije podatkov, pri čemer bodo uporabili različne vire podatkov, kjer so le ti medseboj marsikdaj tudi kombinirani.

Delavnica bo tipa hands-on, kar pomeni, da vsak udeleženec prinese svoj laptop.

WORKSHOP: Oracle JET Hands On Lab

Alan Arentsen
engAlan Arentsen
Arentsen Database Consultancyace director

 

Abstract

Oracle JET is becoming more and more used and they invest a lot to spread the JET knowledge. Last year people could participate with a three week MOOC. After the MOOC you earned an Oracle JET MOOC certificate.

The MOOC material is still online and you can do the course in your own pace. But you may have had some problems starting to learn JET.

Did you miss the MOOC or do you want to update your knowledge than this HOL is something for you to join.

After a short introduction about the various JET components you start building your own JET application. Did you build an application yourself allready then it's possible to download the sample application and build a composite component. All this guided by the course material and an experienced instructor.

WORKSHOP: Topic DBA - to be defined

 

Abstract

< To be defined >