DOUG-dag 2018

Her er programmet for DOUG-dagen vi afholdt 6. november 2018. Hver præsentationstitel er et link til den pågældende præsentation, hvis vi har den. Ami har også leveret de SQL scripts han brugte i sine præsentationer.

0900-0930 Registrering og morgenmad
0930-0945 Velkomst
0945-1045 Ami Aharonovich: The SQL* Family – Exploring SQL*Plus SQL Developer and SQLcl Best Practices for Developers and DBAs
SQL scripts: SQLcl_Examples.sql   SQLPlus_Examples.sql
DBA-spor Udvikler-spor
1100-1200 Christian Antognini: How Autonomous is the Oracle Autonomous Data Warehouse? Keith Laker: Simplified and Fast Fraud Detection using JSON and MATCH-RECOGNIZE
1200-1300 Frokost
1300-1400 Ami Aharonovich: Exploring Best Practices for Protecting Sensitive Data on Cloud & On-Premise Databases
SQL scripts: Data_Redaction.sql
Martin B. Nielsen: Latest news about building and supporting web applications with Oracle Application Express (APEX) 18.2
1415-1515 Christian Antognini: Identification of Performance Problems Without the Diagnostic Pack Keith Laker: Patterns and Use Cases for Self-Describing, Reusable Polymorphic Table Functions
1515-1545 Kaffepause
1545-1645 Martin Jensen: Nordea going 12.2 Multi-Tenancy – Pitfalls and promises Sten Vesterli: Database and APEX development with version control and automated build
1700-2000 Fælles middag

Pr. 2018-11-06. Ret til ændringer forbeholdes.

DOUG takker vores sponsorer:

Miracle logo
Scott/Tiger logo
Sysco logo

 

Abstracts

The SQL* Family – Exploring SQL*Plus SQL Developer and SQLcl Best Practices for Developers and DBAs

This session will explore best practices for using the SQL* family of tools which includes 3 main utilities: The SQL*Plus command-line interface, the SQL Developer GUI IDE and the latest Oracle’s SQLcl Java-based command line interface. Participants will gain significant knowledge regarding how they can use those three tools in order to both administer and develop either cloud or on-premise databases. This session will also include real life examples and live demonstrations on using some very handy commands and features for all three tools while leveraging and enriching your day-to-day productivity and accomplishing your database development and administration tasks much easier and faster.

How Autonomous is the Oracle Autonomous Data Warehouse?

With its Autonomous Data Warehouse Cloud (ADW), Oracle promises a self-configuring, fast, secure, and scalable platform for data warehouses. The installation takes place with few mouse clicks, and a much easier development and operation of a data warehouse is assured. Things like upgrades and patches, backups, performance optimization, scaling, indexing and partitioning, materialized views, optimizer statistics, and other “trivia” are no longer a concern of the customer. The marketing statements sound tempting – or scary, depending on the starting position. But what is really behind it? What happens when we run our data warehouses with ADW? Which tasks are simplified or superfluous? What effects does the self-configuring cloud solution have on database design, ETL processes, and BI queries? Based on various typical applications from the data warehouse area, we tested the ADW to know where in the future we still need, or can, influence ADWC and which tasks in the construction and operation of a data warehouse will be eliminated or simplified.

Simplified and Fast Fraud Detection using JSON and MATCH-RECOGNIZE

This session will demonstrate how using sql pattern matching techniques you can speed up searching for fraudulent events within a dataset compared to using other programming languages. As part of the presentation live demos will be used to review a series of uses cases and provide conceptual simplified SQL to solve these business requirements. These examples are taken from real-life requirements from customers in the financial services, retail, life sciences and telecommunications industries, although the scenarios are also applicable across many other industries. A simple four step framework will be used to construct pattern matching queries. A live demonstration will show how easy it is to write and amend SQL-based pattern

Exploring Best Practices for Protecting Sensitive Data on Cloud & On-Premise Databases

Today, Organizations are required to protect their sensitive data due to regulations such as GDPR, PCI and others, and to prevent sensitive data leakage to unauthorized personnel. Oracle Data Redaction enables you to redact sensitive data returned from queries issued by applications. This session will explore best practices for implementing various sensitive data redaction methods including full, partial, regular expressions and random redaction. Participants will learn from real life examples how they should use Oracle Data Redaction and what are the pros and cons of implementing this solution. The session will also include a live demos and will present various scripts and best practices for implementing Data Redaction to mask your sensitive data either in cloud or on-premise databases. Objectives: 1) Learn the essentials of dynamic vs. static data masking 2) Learn when and how to use Oracle Data Redaction 3) Learn the pros and cons of implementing Oracle data redaction 4) Learn how to implement various data redaction methods including full, partial, regular expressions and random redaction

Latest news about building and supporting web applications with Oracle Application Express (APEX) 18.2.

This talk will dive into the coolest of the new features that has been implemented in version 18.1 and 18.2 of Application Express (APEX). It will further touch on some of the latest trends within that technology space, such as PWA (progressive web apps), Running APEX in the Oracle Cloud, and running APEX for free – using the latest version of the Oracle XE database (18).

If you want to stay in touch with the latest in developing rapid, scalable, responsive and user-friendly applications – this is the place to be.

Identification of Performance Problems Without the Diagnostic Pack

Diagnostic Pack, which is an option available for the Enterprise Edition of Oracle Database only, gives access to a number of dynamic performance views and to the Automatic Workload Repository (AWR). Both are very useful for the identification of performance problems. On the one hand, dynamic performance views are mainly used for the analysis of performance problems while they are occurring. On the other hand, AWR is aimed at the analysis of performance problems that occurred in the past. The aim of this presentation is to describe how to perform analyses similar to those that can be carried out with the tools provided by the Diagnostic Pack even if you don’t have it.

Patterns and Use Cases for Self-Describing, Reusable Polymorphic Table Functions

Development teams are actively looking for new, agile, and efficient ways to expand the breadth, depth, and sophistication of their data analysis. This session explores common patterns and use cases for polymorphic tables, which a new, agile analytical framework designed to support the new types of fast-moving data discovery and big data analytics that are a key part of modern data warehousing. Come and explore how developers can use this agile framework to create efficient, scalable, self-describing, user-defined analytics functions that can greatly simplify data discovery and analysis of big data for report writers, application developers, data analysts, and data scientists.

Nordea going 12.2 Multi-Tenancy – Pitfalls and promises

In order to harvest promised on lower foot-prints on Multi-Tenancy, Nordea is on the way to use this feature from 12.2 and onwards. We have however found a few areas where a some pieces in the puzzle are still missing. Thus this session.

Database and APEX development with version control and automated build

As a developer building applications with Java/ADF and PLSQL/APEX, I felt that my database and APEX development was missing something in version control and automated build. This presentation shows how to use versioned database development and APEX with Flyway and automated build with Jenkins

In most organizations I have worked with, database and APEX development happens straight in some development database. This gives you some manual work packaging your application with the consequent certainty that something will be done wrong eventually.

This presentation shows how I use Flyway (https://flywaydb.org/) for incremental, version controlled database development so I can always build a database in any version, and I know which version runs on any environment. I use Oracle, but Flyway works with more than a dozen other databases.

I also show my workflow for making sure my APEX development is version controlled in my Git repository, and how to use Jenkins to build APEX applications directly from my Git repository together with the right version of the database.

Speakers

Ami Aharonovich

Ami Aharonovich, Oracle ACE Director and OCP, DBAces Founder & CEO, President of ilOUG (Israeli Oracle User Group), Ambassador for EOUC (EMEA Oracle User Group Community). Ami is an Oracle ACE Director and an Oracle Certified Professional DBA with over eighteen years of expertise as an Oracle DBA consultant and instructor, specializing in Oracle database core technologies, including database architecture, administration, development, security and performance tuning. Ami is an Oracle University instructor and has eighteen years of expertise training Oracle courses and delivering core Oracle database technology sessions and seminars throughout the world including the United States, Canada, England, Ireland, Norway, Finland, Romania, Latvia, Germany, Slovenia, Croatia, Hungary, Poland, Cyprus and Israel. Ami is a frequent speaker at various conferences and user group events throughout the world including Oracle Open World, Oracle Code event, OAUG Collaborate, ODTUG Kscope, DOAG, LVOUG, OUGF, SiOUG, HrOUG, OUGN, POUG, RoOUG and ilOUG, educating hundreds of attendees, and has gained exceptional feedback. il.linkedin.com/in/amiaharonovich/

Christian Antognini

Christian is a strong believer that at the core it is all about the data, and on how effectively companies process and take advantage of it. For that reason, since 1995 he has focused on the efficient use of database engines. His main interests include logical and physical database design, query optimizers, and basically everything else related to data processing and application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland.

If Christian is not helping one of his customers get the most out of databases, he is somewhere lecturing on application performance management or database performance features. In addition to classes and seminars organized by Trivadis, since 2001 he has presented at 100+ conferences and user-group meetings in two dozen countries. He is a proud member of the OakTable Network and is an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011/2016).

Christian lives in Ticino, Switzerland, with his wife, Michelle, and their two children, Sofia and Elia. He spends a great deal of his spare time with his wonderful family and, whenever possible, reading books, watching tennis, enjoying a good movie, riding one of his bicycles or gliding down the Swiss alps on a snowboard.

Keith Laker

Senior Principal Product Manager for Analytic SQL with extensive experience of data warehouse and business intelligence market having worked in a variety of roles, including: post sales consultancy, customer support and product management. Worked in a number of locations across Europe and also in California at Oracle’s HQ in Redwood Shores. Almost 20 years with Oracle, Keith is now part of Data Warehouse Product Management team where he works on the analytic SQL features such as: window functions, SQL pattern matching, SQL Model clause and the new approximate query processing. He is the author of the data warehouse and analytical SQL blog, his Twitter handle is @ASQLBarista and he presents at many Oracle conferences.

Martin B. Jensen

Martin is a full stack software developer specializing in building solutions using the Oracle database and Application Express (APEX). He is an independent consultant, and owner of MBNDATA since 1996.

30 years ago he started with terminal based solutions (C programming), moved to client server (Developer Suite, Java), and now the web based solutions (APEX).

Today many of the consulting tasks consists of helping customers transition to APEX, mentoring to enable customers to make the most out of this tool, and educate customer staff by hosting courses in APEX.

Martin is also active in the APEX community, making plugins, answering forum questions, hosting talks at conferences and writing blogs.

Martin Jensen

Since 1981 Martin have been working with Oracle databases, first in DDE as head of the porting team for versions 3 to 8, and later as a performance and security consultant at Oracle, instructing a number of Oracle causes covering new RDBMS features. For the last 4 years Martin has (still is) covering a position at Nordea participating in creating new and more modern Oracle database platforms.

Sten Vesterli

Sten Vesterli is one of Europe’s leading experts on Oracle technology and has been comparing Oracle tools for more than 15 years, speaking at conferences, writing books and publishing the popular Oracle Tool Watch on www.oratoolwatch.com. He develops with ADF and APEX and is currently writing a book on Oracle Visual Builder Cloud Service.   He was recognized by Oracle with the title of Oracle ACE Director for 10 years until Oracle excommunicated him from the program for the heresy of criticizing their cloud strategy.

Sten personal projects include getting a private pilot license for single-engine aircraft, an Ironman and an ultramarathon in Denmark, climbing Mont Blanc in France, hiking in Greenland, skydiving in Denmark, a three-week trek around Annapurna in Nepal, paragliding in the Alps, rock climbing in Sweden, glacier walking in Norway and scuba diving in Thailand. Follow Sten on his blog at http://www.vesterli.com/blog or on twitter @stenvesterli.