Deep-Dive and Tech-Tip Sessions 2017

PresentationsButton presenter Button AGENDA-button SponsorsButton

Tuesday, February 7, 2017, Deep-Dive and
Tech-Tip Sessions

These sessions are included with the purchase of a full conference pass.

Deep-Dive Sessions  Tech-Tip Sessions




Deep-Dive Sessions

Dimensional Modeling: Beyond the Basics
Jason Horner, Pragmatic Works
Room 405         1:00 – 3:00 PM

Dimensional modeling is arguably one of the most important fundamentals of business intelligence. Correctly modeling your organization’s data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.

This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, and how and when to use them. We will also cover some approaches to creating rich hierarchies that make reporting a snap. Finally, we will cover physical design choices. This case study and demo-based session promises to be very interactive and engaging; bring your toughest dimensional modeling quandaries.

Back to top

Key PL/SQL Performance Techniques: Bulk Processing and Function Result Cache
Steven Feuerstein, Oracle Corporation
Room 406            1:00 – 3:00 PM

The most important step you can take to tune up your PL/SQL code is to optimize your SQL. Once you’ve done that, it’s time to look at how you are executing SQL in your PL/SQL code. This deep dive explores the two biggest winners in this area: bulk processing with BULK COLLECT and FORALL, and the Function Result Cache. With one hour for each, Steven might not have to be in too much of a hurry!

Back to top

Building a High-Availability Enterprise Manager System
Werner De Gruyter, Oracle Corporation
Co-Presenter: Curtis Dinkel, Oracle Corporation
Room 404            1:00 – 3:00 PM

The key to a successful Enterprise Manager deployment starts with the right HA (High Availability) and DR (Disaster Recovery) design. Learn how to build an Enterprise Manager system from the ground up in a flexible way, capable of extending and expanding with the growing administration and monitoring needs.

Back to top

Under the Covers: Architecture and Internals of Oracle Hyperion EPM
Eric Helmer, ADI Strategies

Room 407            1:00 – 3:00 PM

Oracle ACE Director Eric Helmer will break down the internals of the latest Oracle EPM version 11. This session will be geared toward IT professionals who are considering implementing or upgrading to Oracle EPM version 11 and want more information on its inner workings. Learn the different components of the EPM suite, including web services, WebLogic components, services, and database layers. This session will also cover architecture, interprocess communication, and data flow, as well as required system administration activities and upgrade considerations.

Back to top

Agile Data Warehousing: Using Oracle Data Modeler (SDDM) to Build a Virtualized ODS
Kent Graziano, Snowflake Computing

Room 405            3:15 – 5:15 PM

At a recent client visit, in order to meet timelines to fulfill urgent, unmet reporting needs, I found it necessary to build a virtualized Operational Data Store as the first phase of a new Data Vault 2.0 project. This allowed me to deliver new objects, quickly and incrementally, to the report developer so we could quickly show the business users their data. In order to limit the need for refactoring in later stages of the data warehouse development, I chose to build this virtualization layer on top of a Type 2 persistent staging layer. All of this was done using Oracle SQL Developer Data Modeler (SDDM) against (gasp!) a MS SQL Server Database. In this talk, I will show you the architecture for this approach, the rationale, and then the tricks I used in SDDM to build all the stage tables and views very quickly. In the end, you will see actual SQL code for a virtual ODS that can easily be translated to an Oracle Database.

Back to top

SQL Hands-On: Zero to Hero
Andy Weiss, HP
Room 406      3:15 – 5:15 PM

With the introduction of Oracle Database 12c SQL is a powerful and complex tool that many people learn on the job and as needed. This leads to gaps in knowledge and common mistakes that are easily avoidable with exposure to a more complete view of the SQL language. With lots of examples and tips on how to avoid common pitfalls, this session hopes to cover everything you need to know to start using SQL more effectively and efficiently. So if you are just starting out or are looking for a refresher, this is a great place to begin.

This session discusses the setup and use of PDBaaS using the Enterprise Manager product suite.

Back to top

Deep Dive: An SOA Application, End-to-End
AceChris Ostrowski

Room 404              3:15 – 5:15 PM

In two hours, this presentation will walk attendees through the development of an SOA application that will highlight all major SOA-based technologies and allow attendees to see, in a real-time, actual environment, how Oracle’s suite of tools can be used to create a fully functional SOA-based application in a short period of time.

We’ll explore the use of cloud-based development combined with build automation and continuous integration techniques for testing and deploying metadata and web catalog releases for OBIEE. Attendees will witness a live demonstration of multiple developers producing repository metadata content that is automatically tested and deployed.

Back to top

PL/SQL: Newbie to Knowledgeable
Bill Coulam, DB Artisans
Room 407              3:15 – 5:15 PM

Join us for a two-hour crash course in solid foundation PL/SQL development. Come for both hours if you are new to Oracle, will be starting your first PL/SQL work soon, or know that your knowledge of PL/SQL needs improvement. Come for the second hour if you would like to step up to the next level where development is smooth and work products follow best practices, perform well, and are easy to test, debug, and maintain. Besides the bullet points and demonstrations, attendees will come away with some resources, templates, and downloads they could use to jump-start their efforts.

We’ll explore the use of cloud-based development combined with build automation and continuous integration techniques for testing and deploying metadata and web catalog releases for OBIEE. Attendees will witness a live demonstration of multiple developers producing repository metadata content that is automatically tested and deployed.

Back to top

Team Up: You and the Optimizer
Vlado Barun, Oracle Corporation

Room 4a              3:15 – 5:15 PM

A lot of SQL performance issues are caused by inefficient execution plans. Common remedies include Hints, SQL Profiles, and SQL Plan Baselines. However, these remedies do not address the root cause of why the Optimizer chooses inefficient execution plans. Furthermore, not only can these remedies cause their own performance issues, but they can also increase maintenance cost.

This session will help the audience address the root cause of a performance problem instead of just chasing after the symptoms. We will cover non-trivial use cases (i.e. Parallel Distribution Methods) and use an interactive format to bring this topic alive.

This deep dive culminates with a complex real-world use case in which the audience will be challenged, step by step, to find the best way to get the Optimizer to produce an optimal plan. And, with the use of a live demo system, the audience will experience the effects of their decisions in real time.

We’ll explore the use of cloud-based development combined with build automation and continuous integration techniques for testing and deploying metadata and web catalog releases for OBIEE. Attendees will witness a live demonstration of multiple developers producing repository metadata content that is automatically tested and deployed.

Back to top

MySQL 101
Dave Stokes, Oracle Corporation

Room 4b              3:15 – 5:15 PM

Need to get started with MySQL? Then this is the two hours you need. You will learn how to install MySQL on Linux and Windows, the basic server architecture, security, configuration, loading data, backups, administration with MySQL Workbench, and more. If you are simply trying to stretch your database knowledge, need to be able to support existing MySQL instances on your jobs, or are looking to polish your MySQL DBA skills, then you need to be in this session.

We’ll explore the use of cloud-based development combined with build automation and continuous integration techniques for testing and deploying metadata and web catalog releases for OBIEE. Attendees will witness a live demonstration of multiple developers producing repository metadata content that is automatically tested and deployed.

Back to top

Tech-Tip Sessions

E-Business Suite: Mobile Application Configuration
Divyashree Shampur

Room 401            1:00 – 1:30 PM

Oracle has released Android and iPhone apps for individual business modules, such as timecards, approvals, expenses, and inventory, to name a few. With little modification to the existing E-Business Suite, these business modules can be made available to users on their personal mobile devices. This session will cover the basics of server side configuration, setting up users, and user profiles to ensure there is access to the same modules on the mobile device as on the desktop client version of EBS.

Back to top

SSH/PuTTY Tricks and Tips for the DBA
Erik Benner, Mythics

Room 401             1:45 – 2:15 PM

Face it: Most of our systems we now access are Unix, or Unix-like systems. Regardless of the flavor, Linux, Solaris, AIX, and even the rare HPUX system all share one key component: We use SSH to access the servers. One of the most common (and free) SSH clients for Windows-based systems is PuTTY. On a day-to-day basis, you likely use PuTTY to SSH into servers, but did you know it’s far more than a basic terminal emulator? This session will show you several of these tricks to improve your life as an admin. Even experienced admins will learn a trick or two in this session.

Back to top

Using VirtualBox and Free Online Resources to Learn Oracle Database 12c and EBS R12
Ace Director
Biju Thomas, OneNeck IT Solutions
Room 401           2:30 –3:00 PM

VirtualBox is widely used for training by many institutions and individuals to have hands-on experience with Oracle and other products. The setup is easy. VirtualBox lets DBAs and Developers have a Solaris/Linux/Windows system running on their desktop or laptop. There are several pre-configured virtual host images available as well. This session will introduce you to VirtualBox, how to configure, and how to make use of the Oracle Database 12c pre-configured VM and Oracle EBS R12 pre-configured VM. We will also discuss the free resources available to learn Oracle Database 12c, including Oracle RAC and Oracle EBS R12.

Back to top

Objectivity Is in the Eye of the Beholder
Jason Aughenbaugh, Insum Software
Room 402/403      1:00 – 1:30 PM

It never fails. We all get that request to make a metrics report that someone has prescribed for a system or an operation that is important to how they do business. The problem with this is almost never the actual report. “The computer is a marvelous invention; it always does exactly what you tell it to do.”

The fact is that business and performance metrics rely on some of the most basic calculations that we learn in grade school. We have used these numbers so much that we cannot help but trust them and many times refuse to question what they are all about. In business, we need to relearn these numbers. We need to know why they are bad and what makes them good.

This session explores the mean/median/mode from the world of statistics, with the ideal of how we use them and how we should be using them. The session will also explore this topic from the perspective of collecting and reporting these problems and solutions from the Oracle Database. It will show how simple it is to show good, actionable metrics and how to explain them to anyone.

Back to top

Dave Stokes, Oracle Corporation

Room 402/403             1:45 – 2:15 PM

Looking to enhance your MySQL relational databases with NoSQL? MySQL 5.7 has a native JSON data type that will store documents; 5.7 also has the ability to bypass the SQL parser to allow direct access of data as a key/value pair. And you can search this NoSQL data with SQL simultaneously by adding additional servers or disks, or making dramatic configuration changes to you server. This session will cover installation, configuration, implementation, and management of both the JSON and p/k software.

Back to top

Oracle PaaS: What Did We Learn While Developing Integration on PaaS?
Komal Goyal, 6e Technologies
Room 402/403           2:30 –3:00 PM

This session will cover the PaaS implementation for both On-Premise to Cloud and Cloud to Cloud integration. The focus of the session will be to share experiences that we had while being one of the initial ones to complete this type of integration.

Back to top

Yum Server Overview and Setup: Tech Tips for Exadata
Tina Rose, Oracle Corporation

Room 401             3:15 – 3:45 PM

This presentation will discuss how to set up a yum repository by creating an Unbreakable Linux Network mirror. We will show how to configure the yum server, subscribe to channels, and set up the client servers. Although this presentation is geared toward Exadata, anyone may benefit from the procedures, as the steps are not Exadata exclusive.

Back to top

R12.2 Upgrade and Cross-Platform Migration
Naveen Ankem, AST Corporation
Room 401           4:00 – 4:30 PM

This presentation covers the complete process to perform a platform migration and upgrade from 11i EBS and 10g Database versions to R12.2 and 11g. It will also explain cross-platform migration, 32-bit to 64-bit migration, and the best methods to migrate based on target and source endian values. Successful case studies will be cited, including a migration of EBS (11i to R12.2), Database (10g to 11g), and platform (Solaris to Red Hat 6.x). We will share the challenges faced during multiple cross-platform migrations and upgrades. Organizations have seen major improvement in performance after these upgrades/migrations. We will share how basing your plans on the size of the database and the endian formats involved (for both source and target) can enable you to choose the best method for platform migration.

Back to top

Being There
Laura Ramsey, Oracle Corporation

Room 401             4:45 – 5:15 PM

Product communities are a place where passionate technology fans share technical expertise and build relationships, but there’s a greater value to participating. Many technology enthusiasts miss the opportunity to interact with a company in these informal development venues because they don’t realize the best way to connect. This session explores cool communities and offers tips on how to get the most out of “Being There.”

Back to top

Inside Oracle Exalytics
Ace Director
Osama Mustafa, Gurus Solutions (Owner)
Room 402/403           3:15 – 3:45 PM

Oracle Exalytics is the industry’s first engineered system for in-memory analytics that delivers extreme performance for Business Intelligence and Enterprise Performance Management applications. This session will cover OBIEE, TimesTen, and EPM products.

Back to top

RTF 101: Building an RTF Document
Karen Cannell, TH Technology

Room 402/403             4:00 – 4:30 PM

We all know RTF – Rich Text Format – but do we really know RTF? This simple format is most convenient for simple tasks such as generating documents, mail merge, and report template processes.

This 30-minute quick tip gives an overview of RTF, covering document format, RTF syntax, some key structures, and using RTF templates. The session will demonstrate the steps of RTF basics and steps involved in programmatically building an RTF document.

Most often we generate HTML for web pages, but sometimes we need a formatted, printed document that is not an HTML page. RTF is one option.

Back to top

The Challenges of Hyperion Support: The Transition from Finance to IT
Chris Chase, The Bean Consulting Group
Room 402/403           4:45 – 5:15 PM

As Oracle’s suite of Hyperion applications moves from “siloed” solutions in the finance department to enterprise solutions in the IT department, supporting these Hyperion applications can be a daunting and challenging assignment for an IT department. Supporting Hyperion environments involves a unique approach to critical thinking and problem solving that requires an understanding of not just the technology being used but also of how the technology is being used. So it becomes imperative that the people supporting the Hyperion environment understand both the technical aspects of the Hyperion system and how the system is used from a functional perspective. In this session, we will discuss the key challenges that face an organization in this transition and how best to try to address these issues. Topics will include security, metadata management and governance, Smart View support, reporting on Hyperion data, process management and workflow, and integration with other systems.

Back to top