WORKSHOP: Implementing Test Data Management with Delphix

 

Abstract

This workshop is an example of implementations ideas shared in the Test Data Management. Delphix is a data virtualization platform and it allow users to quickly start and refresh test or developers databases. During a workshop there will be a presentation of creating new database, refreshing it using GUIs and automation. Also there will be examples of patching database and testing before a production patches.

About Test Data Management: 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.

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.

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.

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.

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.

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.

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."

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.

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 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.

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.

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.

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.

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.

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.

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č.

Dino DBA goes Dev-Ops

 

Abstract

As a DBA or Database-person you will be asked to join a Dev_Ops team and use some of the Agile methods. When this happens, you will have to absorb new knowledge and work-habits. But you will also have to educate your colleagues on what is possible and impossible at the database level. We will try to give some guidelines, and point out a few embarrassing mistakes we made in these situations.

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.

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.

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.

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

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.

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

Subcategories

jezik/language:language

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

 

Page 1 of 4