DOUG-dag 2019

Præsentationer fra DOUG-dagen 22. oktober 2019

Program for DOUG-dagen 22. oktober 2019

Her er planen DOUG-dagen tirsdag 22. oktober 2019. DOUG-dagen er som sædvanlig del af et nordisk samarbejde (Oracle GroundBreakers Nordic Tour), så vi kan tiltrække de bedste internationale talere.

Oracle Danmark lægger som sædvanlig velvilligt lokaler til, denne gang i deres nye lokation i The Cube i Hellerup. Se abstracts og talere længere nede på siden.

Før frokost tilbyder Rita Nuñez at hjælpe dig med at registrere din gratis Cloud account hos Oracle – det tager 5 minutter og kan klares fra din smartphone! Hvis du har din laptop med, kan du efter få minutter oprette din gratis Oracle Cloud-database.

Parallelt med foredraget efter frokost holder Oracle også en hands-on workshop fra 13.00 til 14.30. Hvis du tager en laptop med, kan du få lov at lege med din egen instance af Oracle Autonomous Database. Af hensyn til Oracle er der separat tilmelding til denne workshop. Hvis man skal deltage i denne skal man være lidt hurtig med frokosten.

DOUG takker vores sponsorer:

0900-0930 Registrering og morgenmad
0930-0945 Velkomst
0945-1045 Sandesh Rao: The Machine Learning behind Autonomous Database
1055-1125 Martin Jensen: Nyt fra OpenWorld
  DBA-spor Udvikler-spor
1140-1240 Sai Penumuru: Harness the Power of Oracle Autonomous Database Kim Berg Hansen: Twisting Data in Cloud and On-Prem SQL 1130-1300: Rita Nuñez: Get Your Free Cloud Database
1240-1330 Frokost 1300-1430:
Getting Started Workshop for Autonomous Data Warehouse
(separat tilmelding nødvendig)
1330-1430 Rita Nuñez: First Steps with Oracle Autonomous Transaction Processing Database Sai Penumuru:Accelerate Your Application Development Using Oracle Developer Cloud
1445-1545 Daniel Overby Hansen & Frank Vidtfeld Larsen: Use AWR to save resources Kim Berg Hansen: MATCH_RECOGNIZE – All-round Tool for Cloud and On-Prem Development
1545-1615 Kaffepause
1615-1715 Sandesh Rao: 19 troubleshooting tips and tricks for Database 19c Jeanette Holland & Daniel Overby Hansen: Test your PL/SQL with utPLSQL
1730-2030 Fælles middag

Pr. 2019-10-20. Ret til ændringer forbeholdes.


The Machine Learning behind Autonomous Database

We are entering a new era in the database with the introduction of the Oracle Autonomous Database. AI and Machine Learning are center stage to most projects and assist in making complex decisions which was not possible before. Most data science projects don’t get beyond the data scientist and rarely operationalize their predictive models. there are new toolsets and methods available everyday which make this an extremely dynamic space. There are different categories of users who want to use the algorithms , the toolsets but don’t know where to start. Whether you are a data scientist who wants to play with data and build your own models or make use of the database features with the built in models or use the specific AI services within a specific vertical such as Insurance or Healthcare . We will take a glimpse at Oracle’s Machine Learning Zeppelin-based notebooks for Oracle Autonomous Data Warehouse Cloud to how Oracle uses AIOps and Applied Machine learning for its own operations and the Oracle AI Platform Cloud Service to provided an all rounded view of what Oracle is upto in this space

Harness the Power of Oracle Autonomous Database

Like an autonomous car, Oracle Autonomous Database provides a level of performance and reliability that manually managed databases can’t deliver. Compared to a manually managed database, Autonomous Database costs less to run, performs better, is more available, and eliminates human error. This session covers various benefits, includes an end-to-end live demo, and discusses how we can see Autonomous Database as an opportunity to take on new responsibilities—and move into more-challenging roles. Come to this session to experience a deep dive into what you really need to know to make your career thrive in an autonomous-driven world.

Twisting Data in Cloud and On-Prem SQL

Quite often you have data in rows and need to display or output it in columns, or vice versa. You can also often have delimited data in strings and need them separated out, or conversely aggregate rows of data into delimited strings. In a Cloud era it becomes more and more relevant to avoid dragging raw data from the database to do such twisting in client- or application server code. Instead the time-tried powers of SQL (re-using your skills from on-premises apps) can be used to do the Data Twist of pivoting, unpivoting, splitting and aggregating.

First Steps with Oracle Autonomous Transaction Processing Database

An autonomous database is a cloud database that automatically executes tasks as database tuning, security, backups, updates, and other routine management tasks traditionally performed by database administrators. This session focus on Oracle Autonomous Database Transaction Processing,  that is optimized for transactions, so it can run simple transactions, complex transactions, batch programs, reportings, and mixed workloads. Autonomous Database comes with two deployment choices Serverless and Dedicated and we will explore uses cases that fit better for each one. You’ll learn also the first steps to start using in it, how to sign-in Oracle Cloud Service, provisioning an Autonomous  Database Transaction Processing and connecting with it. This database has drivers for the main development languages as java, python, node.js, .net.  This session includes a DEMO of Provisioning and Connecting to an ATP.

Accelerate Your Application Development Using Oracle Developer Cloud

Want to easily develop your apps in a fully provisioned environment that helps you code, test, deploy, and manage them in the cloud? Oracle Developer Cloud provides an integrated platform that combines DevOps and agile features to help manage development teams, software, and infrastructure from a single location. This session covers various benefits of using DevOps, microservices, and Oracle Developer Cloud, and includes a live demo.

Use AWR to save resources

At SimCorp there are hundreds of databases running various types for workload spanning multiple platforms and RDBMS versions. In such a landscape and during a busy day it is impossible to keep up with all the databases. The AWR is a treasure chest of valuable instrumentation data but it is not very easy to get a good overview and identify issues without digging into the details of every single database. SimCorp decided to build an AWR data warehouse wherein the data could be aggregated and presented to a DBA in a consolidated fashion.

Join this session to hear about the experiences gained at SimCorp by looking at AWR data from an consolidated, and aggregated view. Using SQLs and AWR views you will be shown how SimCorp saved many spinning CPUs and unnecessary TBs of I/O.

MATCH_RECOGNIZE – An All-round Tool for Cloud and On-Prem Development

Row pattern matching is useful for recognizing patterns in rows of data, as the name implies. But the uses of MATCH_RECOGNIZE extends beyond the obvious – it can be applied to grouping consecutive data, merging overlapping periods, bin fitting, child number calculations in hierarchies, and more. Being part of SQL it should be part of any Cloud developer’s toolkit to avoid pulling the data to the client (which of course applies to on-premises too.)

19 troubleshooting tips and tricks for Database 19c

This part of the workshop will focus on 19 troubleshooting tips and tricks for DBA’s covering tools from the Oracle Autonomous Health Framework (AHF) like Trace File Analyzer (TFA) to collect , organize and analyze log data , Exachk and orachk to perform mass best practices analysis and automation , Cluster Health Advisor to debug node evictions and calibrate the framework , OSWatcher and its analysis engine , oratop for pinpointing performance issues and many others to make one feels like a rockstar DBA

Test your PL/SQL with utPLSQL

Unit testing provides a mean of fast feedback to a developer. Modern programming has a lot of focus on continuous integration, and with utPLSQL there is a great framework for easily create and run unit tests on your PL/SQL code. Join this presentation to see a demo of the utPLSQL unit test framework, and learn how to use it, and get started with testing your own code. The presentation will follow a test driven development (TDD) approach and thus it starts out with creation of a unit test. Next, a new PL/SQL package is created that applies conditional compilation to expose otherwise private functions to the unit test framework. Finally, the feedback from the failing unit tests can be used to continuously improve the PL/SQL until it passes all tests, and are ready for being saved. We promise there will be code or examples on (almost) all slides.

If time allows there is also a demo of a full CI pipeline with PL/SQL being created in SQL Developer, saved in GitHub, and tested by utPLSQL via Team City build agents.  


Kim Berg Hansen

Kim Berg Hansen is a database developer from Middelfart in Denmark. Originally wanting to work with electronics, he almost coincidentally tried computer programming and discovered where his talent lay, as the programs he did worked well – unlike the electronics projects he soldered that often failed. After that experience he progressed from Commodore Basic on VIC-20 over Modula-2 and C at Odense University to Oracle SQL and PL/SQL, which last two languages he now has worked with extensively since the year 2000. His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for the users.

Kim shares his experience and knowledge by blogging, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation is when peers go “now I understand” after his explanations, or when end users “can’t live without” his application coding. He is certified Oracle OCE in SQL as well as awarded Oracle ACE Director. Outside the coding world Kim is married, loves to cook, and is a card-carrying member of Danish Beer Enthusiasts association.

Rita Nuñez

Rita Nuñez is an Oracle ACE Director, Oracle Database and Oracle Cloud Specialist. University Graduated as a Systems Engineer. Instructor of Oracle University. She is CEO and Founder of Tecnix Solutions, leads the Consulting and Training services in Oracle Products. She collaborates with the Oracle Community by writing articles for OTN and on their blog. Keeps the Oracle community informed through their twitter. She has been giving presentations at Oracle events since 2013 in Argentina, Brazil, Uruguay, Chile, Paraguay, Panama, and Costa Rica. He also gave presentations at Oracle Code Buenos Aires 2018, Oracle Code Paris 2018, Oracle Open World 2016 and 2017. She is a member of the board of Directors and Coordinator of SIG Database & RAC of ArOUG. 

Sai Penumuru

Sai is an expert in industry-leading technology trends: Cloud & DevOps and having more than 17 years of experience in driving technology innovations and helping customers. He spent past six years evangelizing an industry-wide shift to the cloud. In his current role as Chief Technologist focusing on building solutions maximizing use of emerging technologies to help customers transform their applications to a digital platform. Strong client facing personality and experience engaging Senior Stakeholders He is also an accredited Oracle ACE Director and Oracle Groundbreaker Ambassador an honor bestowed on him by Oracle because of his community contributions. Sai is a well-known and respected technologist within the Oracle community. He is one of the founding members of All India Oracle Users Group ( and currently serves as President. He has been invited to present regularly speaker at industry conferences across the globe including Oracle Open World (2013 to 2018), Tech UKOUG (2014,2016,2017), OUGN (2016 to 2018), AMIS – Beyond the Horizon (2016), DOAG (2016), Oracle Cloud World (2016), Oracle Code 2017 (New Delhi, Moscow), Oracle Code 2018 (Hyderabad, Bengaluru), Oracle Code 2019 (Bengaluru), Sangam (2009 to 2018), OTNYathra (2012 to 2018) and many TechDays. Sai holds a Master’s degree in computer science from the University of Madras and is a member of Toastmasters International. His LinkedIn profile –

Sandesh Rao

Sandesh Rao is a VP running the AIOps Automation for the Autonomous Database Group at Oracle Corporation specializing using AI/ML for different usecases from predicting faults before they happen to Anomaly Detection within log data , metrics data. His previous positions have focused on performance tuning , high availability , disaster recovery and architecting cloud based solutions using the Oracle Stack. With more than 18 years of experience working in the HA space and having worked on several versions of Oracle with different application stacks he is a recognized expert in RAC , Database Internals , PaaS , SaaS and IaaS solutions and solving Big Data related problems . Most of his work involves working with customers in the implementation of public and hybrid cloud projects in the financial , retailing , scientific , insurance , biotech and the tech space. He is also responsible for developing assessments for best practices for the Oracle Grid Infrastructure 19c including products like RAC (Real Application Clusters) , Storage (ASM , ACFS) More details at @sandeshr