EPM Business Content

Track sponsored by:

EPM Business Content at the ODTUG Kscope17 Conference

At Kscope17, we have the world’s best EPM experts joining forces to bring you the most actionable insights in one conference. From budgeting and planning to real-world case studies, strategies, and best practices in the EPM world. 

Budgeting and Planning Process:  

You’ll attend sessions about using Oracle EPM products for Planning and Budgeting from a functional and business benefit perspective. 

Case Studies:  

We’ll show you case studies covering real-world implementation stories, tips, tricks, and strategy on how to deliver the best performance for reporting with confidence using the entire EPM suite of products.

EPM/BI Strategies:  

Employee Performance Management and Business Intelligence Strategy best practices, and how to integrate multiple products. We’ll cover the latest trends in enterprise data governance along with the newest cloud features.   

Financial Close Processes:  

What products carry the keys to your success? You’ll take a look at Financial Close products such as HFM, FCCS, Close Manager, Account Reconciliation Manager, and Supplemental Data Manager from a functional and business-benefit perspective.

Check out the presentations listed below.



Look Inside the Locking Mechanism
Liron Amitzi , DBAces
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Begonia
Topic: Database - Subtopic: Other Database

Locking issues have always been an interesting topic. This is one of the most important features that maintain the integrity of our database.

Why do we need the locking mechanism? What locking modes and types are there? What does Oracle lock during DML and DDL operations? How are constraints and indexes affected by and affecting locks? These are some of the questions this session handles. It also includes live demos for some advanced and interesting scenarios and shows how to query relevant data dictionary views.

Back to Top
SQLcl: A Modern Command Line Interface to the Oracle Database
Galo Balda , State of Texas
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

SQLcl is a Java-based command line interface that takes advantage of SQL Developer’s scripting engine to deliver a modern command line interface that is backward compatible with SQL*Plus but also introduces new commands and usability enhancements that have been missing for a long time. Come to this session to see a demo showing the new inline editor, query history, aliasing, result formatting, DDL generation, JavaScript support, and other exciting features that set SQLcl apart from its predecessor.

Back to Top
Track-a-Watt: Modify a Power Usage Tracker to Log Your Power Usage in a Database
Blaine Carter , Oracle Corporation
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Begonia
Topic: Database - Subtopic: DB Tools

If you're like me, you use way too much power and you’re not quite sure where. Tracking your power usage is a great start, but analyzing the data is often easiest when it's in a database. Having to type it in by hand would be a pain; let's void a warranty instead!

Back to Top
Building an Oracle Database Web Application with Oracle JET and ORDS
Ashley Chen , Oracle Corporation
Co-presenter(s): Jeff Smith, Oracle Corporation
When: Jun 27, 2017, Hands on Lab Session 6, 8:30 am - 9:30 am
Room: Goldenrod
Topic: Database - Subtopic: Other Database

summary to come

Back to Top
The Future of Database
Maria Colgan , Oracle Corporation
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Begonia
Topic: Database - Subtopic: DBA

Database architectures are fundamentally changing due to new technologies and new requirements. Organizations must understand and embrace these transformations to thrive in the future. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and explains how you can embrace each transformation while preserving your existing investments.

Back to Top
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
Maria Colgan , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task, even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Back to Top
Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS
Jim Czuprynski , Zero Defect Computing, Inc.
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Begonia
Topic: Database - Subtopic: Other Database

Originally introduced in Release 12.1.0.2, Database In-Memory (DBIM) offers the ability for analytic queries to sift through billions of rows at incredible speed because data is now retained in columnar format in the In-Memory Column Store (IMCS). Oracle Database 12cR2 dramatically expands the capabilities of DBIM, making it even simpler to implement, monitor, and manage while extending its reach to more complex execution plans, expanding its utility to Active Data Guard (ADG) instances, and enabling capture of frequently-evaluated expressions in the Expression Statistics Store (ESS).

Session Outline:
Through presentations and examples using Swingbench’s latest TPC-DS query generation features, this session will illustrate how Oracle 12.2 Database In-Memory:
- Dramatically speeds execution of analytic queries through In-Memory Column Store (IMCS)
- improves the management and monitoring of the IMCS
- Improves complex query execution through improvements like Expressions Statistics Store, In-Memory Filtering, and Parallel Execution

Back to Top
Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database’s Real Application Testing (RAT) Suite
Jim Czuprynski , Zero Defect Computing, Inc.
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Begonia
Topic: Database - Subtopic: DB Tools

In the seven years since Oracle released the Real Application Testing (RAT) suite as part of release 11.1.0.7, this powerful set of diagnostic tools has received significant upgrades. This session will illustrate how the latest version of RAT in Oracle Database 12.1.0.2 is still a primary contender in the battle to identify potential bottlenecks in application performance before any database is migrated / upgraded to a newer version. We will offer some real-world examples of how to best to leverage RAT’s several new features in 12.1.0.2, including Workload Intelligence, Workload Scale-Up, and Consolidated Database Replay, as well as its original key features – Database Capture and Replay (DBCR) and SQL Performance Analyzer (SPA) -to avoid unnecessary application performance regression, especially when transitioning to Oracle Database 12c.

Session Outline:
Through presentations and online demonstrations, this session illustrate how to:
- Capture replayable database application performance baselines with RAT Database Capture and Replay
- Determine which SQL statements will unquestionably experience performance regression during execution
- Leverage the latest hooks to Oracle’s built-in tuning advisors to generate improved execution plans before migrating or upgrading your database to the next release

Back to Top
Open-Source PL/SQL Utility Tools for Oracle
Martin D'Souza , Insum Solutions
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Dev

OOS Utils is a free open-source PL/SQL tool set for common utility functionality that developers use. Its goal is to prevent developers from having to rewrite the same code over and over again.

This presentation will highlight some of the great features of OOS Utils and showcase some future plans for the project. All audience types (DBAs, PL/SQL and APEX developers, and Development Managers) are encouraged to attend, as all will see immediate benefits for themselves or their teams to use.

Back to Top
Deploying REST Services at Scale
Colm Divilly , Oracle Corporation
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: Other Database

REST powers the Oracle Cloud. From how customers build and deploy REST services, to how the cloud itself is built. This session will cover how Oracle REST Data Services is deployed in the Oracle Public Cloud at scale. This includes auto configuration for adding capacity on demand, security, tiered architecture, and lots more.

Back to Top
REST Enabling the Oracle Database
Colm Divilly , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

This session will demonstrate how quickly one can install and configure Oracle REST Data Services (ORDS) to provide/serve REST endpoints on both RESTful Services and Database Objects themselves.

A brief overview of REST concepts will be followed by a demo of ORDS being installed in less than 5 minutes.

Then a series of demos showing how easy it is to REST enable a table and use GET/POST/DELETE to provide a full CRUD API to your data, including complex scenarios involving complex data types like SDO_GEOMETRY and rich web applications that can take advantage of JSON.

REST is the new development paradigm and the Oracle Database is 100% ready with the addition of ORDS.

Back to Top
Alexa! How Do You Work with Oracle REST Data Services?
Jonathan Dixon , JMJ Cloud
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: Other Database

At first glance, Artificial Intelligence (AI) may seem beyond the reach of the citizen ORDS developer. With companies such as Amazon, Google, and Apple providing the interface (aka Alexa, OK Google, and Siri), however, this is no longer the case. In this session, I will demonstrate how you can use Oracle REST Data Services (ORDS) as the gateway to and the Oracle Database as the engine behind Alexa skills that will impress your customers. Alexa! How many orders were placed in the past hour? Alexa! Are there any stuck transactions in ERP Cloud? Alexa! It's time to make ORDS and the Oracle Database cool!

Back to Top
The Benefits and Simplicity of Oracle Cloud Infrastructure: IaaS
Julian Dontcheff , Accenture Enkitec Group
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Azalea
Topic: Database - Subtopic: Design

IaaS is the fastest-growing area of public cloud computing. Oracle Cloud infrastructure as a service with built-in security and high availability offers elastic compute, networking, and storage to help any company quickly reach both value and productivity out of the business. The presentation covers the benefits of Oracle IaaS over Amazon and Azure, and we show how fast and easy it is to set up IaaS services in the Oracle Public Cloud.

Back to Top
Exploring Advanced SQL Techniques Using Analytic Functions
Zohar Elkayam , Brillix-DBAces
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

Even though DBAs and developers are writing SQL queries every day, it seems that advanced SQL techniques such as multidimension aggregation and analytic functions still remain relatively unknown. In this session, we will explore some of the common real-world usages for analytic function and understand how to take advantage of this great and useful tool. We will deep dive into ranking based on values and groups, understand aggregation of multiple dimensions without a group by, see how to do inter-row calculations, and much more.

Together, we will see how we can unleash the power of analytics using Oracle 11g best practices and Oracle 12c new features.

Back to Top
Oracle Dev Gym PL/SQL Workout: Oracle Database 12c
Steven Feuerstein , Oracle Corporation
When: Jun 26, 2017, Hands on Lab Sessions 3-4, 2:00 pm - 4:15 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

The best way to learn is to actively engage/exercise with the technology. In this session, attendees will participate in an Oracle Dev Gym workout: a series of multiple-choice quizzes that test your knowledge of PL/SQL features in Oracle Database 12c Releases 1 and 2. Steven will then review each quiz and give out prizes for best performance. It'll be a fun and different way to learn about PL/SQL!

Back to Top
Optimizing PL/SQL for Performance and Maintainability
Steven Feuerstein , Oracle Corporation
Co-presenter(s): Bryn Llewellyn, Oracle
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

After fully leveraging SQL in your Oracle Database applications, it’s time to completely utilize PL/SQL to implement business rules, create APIs on top of your data structures, and implement key processes within the database. Usually when developers think about optimization, they focus on performance, and this session does, too. But it’s also critical to think about how to write code today so that tomorrow and years from now, future developers will be able to adapt that code to changing user requirements and database features. In this session, PL/SQL experts, including Bryn Llewellyn and Steven Feuerstein, will present their ideas on writing optimal PL/SQL but focus mainly on answering questions from the audience.

Back to Top
Change Impact Analysis with 12.2 PL/Scope
Steven Feuerstein , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Azalea
Topic: Database - Subtopic: DB Dev

PL/Scope, first introduced in 11.1, offers a powerful code analysis tool, baked right into PL/SQL. With it, you can answer questions such as, "Where is this variable modified in my code?" "Which packages invoke a specific overloading of a function?" and "Show me all my unused declarations." Cool stuff. But prior to 12.2, SQL statements were not a part of that analysis. Now in 12.2, PL/Scope also gathers information about static SQL statements and where dynamic SQL is executed in your code. As a result, you can now use PL/Scope to perform comprehensive, detailed analysis of the impact of planned changes to your code base. In this session, Steven Feuerstein introduces attendees to PL/Scope, explores 12.2 enhancements, and provides scripts everyone can use to leverage PL/Scope in their dev environment.

Back to Top
Updatable Views to Secure Your Database and Make Your Developers Happy
John Flack , Synectics for Management Decisions, Inc.
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Azalea
Topic: Database - Subtopic: DB Dev

Learn about the advantages of putting updatable views between your applications and your tables. They can simplify development, enforce business rules, and provide extra security. And I will show you how to write INSTEAD OF triggers that make it all possible.

Back to Top
Accelerating Testing Using Data Virtualization
Tim Gorman , Delphix
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Begonia
Topic: Database - Subtopic: Other Database

How much testing do you perform in your BI/DW environments? Do you even have a test environment? Do you test in production?

The biggest problem with testing in BI and DW environments is the size and velocity of data. Databases and applications have grown enormous and complex. "Storage is cheap" is simply not true. Need proof? Ask for 10 TB to provision a new test environment.

Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes or even petabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, if ever, and both code quality and data quality suffer.

Data virtualization is the solution. Using thin-provisioning technologies, virtual databases and file systems only consume space from changed blocks, so it is possible to provision virtual terabytes for only a few actual megabytes. Coders and testers have full and independent read-write environments provided quickly in which to develop and test, improving code quality. Learn about the technical details behind this solution.

When I first heard about data virtualization, it sounded far-fetched, just a trick. Instead, it is the perfect solution to the perfect storm of more data quickly. Every IT shop will need to know how to provision test environments faster using less storage. It's not a matter of "if," but "when."

Back to Top
Barriers to Oracle Database In IaaS Cloud
Tim Gorman , Delphix
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Begonia
Topic: Database - Subtopic: DevOps/Agile

IaaS cloud vendors such as AWS prefer that everyone migrate to the cloud, but what often happens is that non-production migrates for cost reasons but production stays on-premises. This phased path to the cloud can leave IT with a split personality: production on-premises on legacy proprietary UNIX platforms, non-production in the cloud on commodity Linux platforms.

Because the security risk on non-production systems is much higher than production, there is a requirement to mask personally identifiable information or confidential data before it is copied to non-production. Data virtualization employs thin cloning, snapshots, and network-attached data presentation, reducing cloning from hours or days to minutes. But there is more: Your legacy UNIX (i.e. AIX, Solaris, HP-UX) databases aren't going anywhere off-premises because the cloud is based on Intel (i.e. Linux, Windows). So what to do?

In this session, learn how data virtualization and data masking make "split-brain IT" not just possible but desirable.

Back to Top
Top Five Cool Features in Oracle SQL Developer Data Modeler
Kent Graziano , Snowflake Computing
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Dev

Oracle SQL Developer Data Modeler is an industrial-strength data modeling tool that can be used for any data modeling task you need to tackle. Over the years, I have found quite a few features in the tool that I rely on to make me more efficient in developing my models. I will demonstrate at least five of these features, tips, and tricks including using the metadata export tool.

Back to Top
Analytic Views in Oracle Database 12.2: The Virtual Cube
Kim Hansen , Trivadis Danmark A/S
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: Other Database

Traditionally to model and analyze your data with dimensions and hierarchies, either you copy your data to a data warehouse and from there to a dimensional cube, or you have to write quite a lot of rather advanced code and SQL to emulate the same directly on your relational data.

With analytic views (introduced in Oracle Database version 12.2), you declaratively define the dimensions and hierarchies similar to creating a cube, but it is only stored as a metadata layer on top of your tables; it is a multidimensional *view* of your relational data. The SQL language has been expanded to allow a simpler query syntax on the analytic views to utilize these metadata and automatically use advanced analytic functions to give you dimensional analysis on real-time data. As SQL is used below the covers, performance can be tuned using query rewrite with materialized views or In-Memory options or any other option you would normally use for SQL tuning.

This session will show code examples covering a lot of the syntax you have for creating and using analytic views.

Back to Top
Advanced SQL Topics: Analytic Functions
Kim Hansen , Trivadis Danmark A/S
When: Jun 27, 2017, Hands on Lab Session 7, 11:15 am - 12:15 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

When analytic functions appeared in the database in version 8, they were the best thing to happen to SQL since the keyword SELECT was invented. Analytic functions are indispensable in a lot of use cases for creating highly efficient queries, often enabling you to avoid slow procedural code. Once you have started using analytic functions more than a couple of times, you'll develop the mindset for recognizing opportunities for utilizing them often in your daily work, making your applications highly efficient.

This hands-on-lab will let you try out yourself a series of examples demonstrating the powerful aspects of analytic function syntax and various use cases, giving you practical experience that'll help you know when you profitably can use analytic functions in your work.

Back to Top
Advanced SQL topics: Pattern Matching
Kim Hansen , Trivadis Danmark A/S
When: Jun 28, 2017, Hands on Lab Session 14, 1:45 pm - 2:45 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

Row pattern matching with MATCH_RECOGNIZE can be useful in a variety of situations, once you get to grips with how the various parts of the syntax work and interact with each other. Try out yourself different ways of using MATCH_RECOGNIZE like advanced declarative analytic functions.

Back to Top
Six Reasons Why You Will Get Addicted to SQLcl Scripting
Sabine Heimsath , its-people GmbH
Co-presenter(s): Robert Marz, its-people GmbH
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

SQLcl is ready to replace the reliable but somewhat outdated SQL*Plus as the new command line interface of the database. The most exciting new feature of SQLcl is scripting: Batch scripts can now be written in languages such as JavaScript, Python, or Perl. This means a veritable cornucopia of options, many of which are not obvious at first sight.

After a brief introduction to SQLcl, we will show many real-world examples that demonstrate the new possibilities. All examples are available for download to allow for further tests and exploration. This presentation provides many in-depth live demos.

Back to Top
Design Your Databases Using Oracle SQL Developer Data Modeler
Heli Helskyaho , Miracle Finland Oy
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: Design

Oracle SQL Developer Data Modeler is one of the leading database design tools in the market. The amount of data is growing, and everybody is starting to understand the value of good-quality data for their business. The only way to have good-quality data and to understand your data is to design your databases. To be able to design them, you need a tool; paper and pen are not enough anymore. What is database designing, and how do you design databases using Oracle SQL Developer Data Modeler?

Back to Top
How to Design a Database? Let's Start with the Logical Model
Heli Helskyaho , Miracle Finland Oy
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: Design

What is database designing, and how do you design a relational database? What is a logical design, and why do I need to create one? What is NF3 and BCNF? Why would I care about all the theory, and what is it, by the way? During this session, you will get answers to these questions plus about 100 more.

Back to Top
OMG! Identifying and Refactoring Common SQL Performance Anti-Patterns
Jeff Jacobs , Jeffrey Jacobs & Associates
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Begonia
Topic: Database - Subtopic: DB Dev

Most presentations on SQL performance assume that the query developer is highly experienced in SQL and Oracle and focus on tracing and other techniques. Sadly, in today's world, knowledge of SQL and Oracle are not highly valued, and many SQL performance problems are the result of inexperience, misguidance, "heard it/read it somewhere," and various sources of misinformation. This presentation will address common "anti-patterns" in database design and SQL query writing that have been encountered over the years and how to fix them without tracing, changing init.ora parameters, or techniques requiring DBA-level privileges. It is focused on techniques that are typically available to developers. This presentation received a 2015 SELECT Journal Editor’s Choice Award.

Back to Top
PDB Me, ASAP! Oracle Database 12cR2 Multitenant Workshop
Charles Kim , Viscosity North America
Co-presenter(s): Jim Czuprynski, OnX Enterprise Solutions
When: Jun 26, 2017, Hands on Lab Sessions 1-2, 10:30 am - 12:45 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

Oracle Database 12cR2 has dramatically revamped the range of Multitenant features, including faster PDB cloning with virtually no downtime, tighter resource control at the PDB level, ILM Automatic Data Optimization (ADO) policies for PDBs using Heat Maps, and even FLASHBACK recovery for individual PDBs. This 2-hour workshop explores the latest features of 12cR2 Multitenant and provides attendees with practical, hands-on experience as well as numerous code examples that they can immediately leverage when deploying, upgrading to, and migrating to CDBs and PDBs.

Back to Top
The THINGS Are Here! Using Oracle IoT Cloud Service
John King , King Training Resources
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Dev

First, the Internet connected us. Then we added computers and network connections to machines and things. Today, many “things” (computers, sensors, devices, appliances, cars, phones, etc.) are connected to the Internet, to our applications, and to each other. The Internet of Things is exploding, and you need to be prepared for it. In this session, you will learn how the Internet of Things is changing our lives. Every day, more use cases appear where we harness the tremendous flow of data coming from “edge” devices to enable better business decisions. Oracle’s Internet Of Things Cloud Service is an instrumental part of this new world. This session will introduce you to IoT and Oracle’s Internet Of Things Cloud Service.

Back to Top
Give MAF a REST: Using REST/JSON Services in MAF
John King , King Training Resources
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

Oracle’s Mobile Application Framework (MAF) builds web applications quickly and easily that port to iOS and Android devices without target-specific customization. MAF applications may use data from Java POJO’s, the local SQLite database, SOAP/XML Web Services, REST/XML Web Services, and REST/JSON Web Services. This presentation shows attendees how to create MAF applications based upon REST/JSON Web Services. The combination of REST and JSON has become the standard mechanism for communicating with mobile applications; MAF developers attending this session will learn how to use them.

Back to Top
I've Looked at Cloud from Both Sides Now: Developer Cloud Service or Not?
Peter Koletzke , Quovera
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DevOps/Agile

If, like this presenter, you are a developer or IT professional who has been wary of cloud computing since first hearing about it, your objections to it probably run along the lines of price, complexity, loss of control over your development environment, security, and just good old stubbornness to change. Alternatively or additionally, if you work in an Oracle-oriented shop, the tendency may be to rely on Oracle's products, but your shop is waiting for Oracle's cloud products to mature before jumping in (flying up).

Whatever your opinion about cloud computing in general, and Oracle's competency in cloud products specifically, Oracle Developer Cloud Service is worthy of examination now. Oracle Developer Cloud Service is a Platform as a Service (PaaS) product that provides a complete development environment for creation of applications in any discipline (for example, APEX, ADF, JET, MAX, ABCS, or Forms).

On the "Up" side, this presentation explains this service and how you can use it as an out-of-the-box solution for the full life-cycle of an application, or for integrating some of your own components into the service.

On the "Down" side, the presentation discusses why you may not want to use this service, and, if you do decide to use it, what to avoid when configuring and using the product.

The session closes with an example of setting up Oracle Developer Cloud Service to supply a full application life cycle that includes version control, code reviews, build integration, issue tracking, and deployment phases. You may be pleasantly surprised at what you learn about this product.

Back to Top
Thick Database is Alive: Leveraging the Oracle Database SQL and PL/SQL to Simplify Any User Interface Application Development
Peter Koletzke , Quovera
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

Whether you develop applications for an Oracle database in APEX, ADF, MAF, JET, MAX, ABCS, or any other development framework or programming language, the development approach known as "thick database" can provide benefits in productivity, code reusability, and ease of application maintenance. This approach to development evolved from discussions in ODTUG channels over ten years ago.

The thick database approach consists of centralizing most application logic in the database, which greatly simplifies the user interface work. It also shields the application somewhat from UI technology changes, so if an application framework needs to be changed, the amount of code to rewrite is much less than with business logic in the application.

This presentation explains the benefits, principles of, and guidelines for using this approach. It discusses how business rules logic can be centralized and standardized so that application updates due to business changes are much easier. It also describes different levels at which you can use the thick database principles: extreme, modified, and conservative, and how to decide which level to use. It also explains how you would decide which business rules should be implemented in the user interface even if they are also written in the database.

The session also suggests a simple system you can create to track business rules as one part of thick database development as well as a starting point for creating test plans. The session then shows examples of the main SQL and PL/SQL code components you might use to implement thick database principles: table APIs, complex views with INSTEAD OF triggers, and business rules procedures.

Back to Top
A Real-World Comparison of the NoPlsql and Thick Database Paradigms
Toon Koppelaars , Oracle Corporation
Co-presenter(s): Bryn Llewellyn, Oracle Corporation
When: Jun 29, 2017, Deep-Dive Session, 9:00 am - 11:00 am
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

The NoPlsql paradigm starts with an object oriented domain model in the middle tier. This leads naturally to treating the database as a bag of tables, so that primitive SQL statements express its API. The Thick Database paradigm starts with the design of the relational model. This leads naturally to allowing client-side code only to call PL/SQL subprograms, so that all SQL is done from PL/SQL. These two paradigms are mutually incompatible.

In our first part of our session, we show, based on real-world use cases, how the NoPlsql paradigm brings problems with correctness, security, and performance, and we note that projects that adopt the NoPlsql paradigm use most of their resources on developing plumbing code rather than code that implements actual business functionality. These problems are just the tip of the iceberg and we explain how the NoPlsql paradigm also brings maintenance nightmares.
In our second portion of the session, we turn to the Thick Database paradigm, rehearse the reasons for its superiority, and explain that it implies more than just allowing database calls to invoke only PL/SQL subprograms. We formalize a layered code classification scheme which leads to optimal understandability and maintainability of both your PL/SQL and your SQL code -- which properties bring the maximum probability of correct behavior. We will convince participants that adopting the Thick Database Paradigm guarantees the avoidance of the awful problems brought by the NoPlsql paradigm and establishes the database tier as a reliable central service provider in the application landscape. We will debunk the myth that “moving business logic out of the data tier and into the middle tier” improves scalability.

Back to Top
A Holistic Approach to Database Security
Robert Lockard , Oraclewizard
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Begonia
Topic: Database - Subtopic: DBA

For years we have been locking down the software to protect information. This presentation puts the focus where it belongs: identifying, protecting, and selecting the correct tools to protect your data.
Starting with a brief history of security breaches and the impact to both companies and consumers, the presenter will move through a methodology of identifying sensitive information, creating a risk matrix, and which tools are available to mitigate information leaks.

Back to Top
Thinking Clearly about Testing Performance
Cary Millsap , Cintra Software and Services
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: Testing

Testing for functional correctness is generally a matter of specifying the right output for a given input and then using a tool that check whether your code produced the output you specified. Testing performance, though, is a lot harder, even conceptually. You can use a tool to check whether a given function "runs in D seconds or less," but there's more to it than that, because realistic data volumes and loads matter so much. But you can prevent a lot of post-production performance problems without having to spend a gazillion dollars on "perfect" performance testing. In this session I'll help you learn how.

Back to Top
Introduction to ADF: Building an Application in 60 Minutes.
Jamie Morrison , Peak Indicators Ltd.
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

Discover how to create a basic browser based application using the latest version of JDeveloper 12c and Application Development Framework (ADF).

In the session we will start with a blank canvas from which we will build up a working HR application using core technologies and functionality, we will compile it, then deploy it to our Weblogic server where we can see it in action. During the session we will dip in to aspects such as creating data capture forms, skinning, and creating custom menu options.

Back to Top
Tips and Best Practices for DBAs
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Azalea
Topic: Database - Subtopic: DBA

A vibrant session with “Real Tips” for real world daily database problems a DBA could find. Here you will learn how to improve your productivity, how to solve some real DBA problems, and also learn several tips to help you to become a successful DBA. This session is based on some of the most frequent questions I’m asked on my blog and during my presentations. (Version 3 of this presentation.)

Back to Top
Logging or Nologging: That is the question!
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Begonia
Topic: Database - Subtopic: DBA

The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever," or just that the initial creation operation has no redo generation, but that DML down the road generates redo? How and when can the NOLOGGING option be employed?
Redo generation is a vital part of the Oracle recovery mechanism. Without it, an instance will not recover when it crashes and will not start in a consistent state. Excessive redo generation is the result of excessive work on the database. This presentation covers the subject of reducing redo generation using LOGGING and NOLOGGING options, the differences between them, how it happens, how to reduce it, and when to use. Also, you will find examples and tips regarding each one of them.

Back to Top
The Best 12c R1 & R2 Query Tuning New Features
Rich Niemiec , Rolta
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

This presentation will look at which 12c new features should be investigated for query tuning. Most of the features that will be covered will be related to the developer & DBA. There will be simple examples to show the basic functionality of the new features:

- Using Invisible Columns
- Multiple Indexes on the same Column
- Adaptive Execution Plans
- Runaway Query Management
- Online Move Partition
- Partial Indexes for Partitioned Table
- Enhanced DDL Online
- Other 12c Query Tuning New Features
- Using Oracle In-Memory Database

Back to Top
Creating Your First Database to Access with Oracle's DBaaS (DataBase as a Service)
Rich Niemiec , Rolta
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Begonia
Topic: Database - Subtopic: DBA

This presentation will show the steps to create a Database in the Oracle Cloud using Oracle's Database Cloud Service or DBaaS (DataBase as a Service). It will give the brief steps as well as showing how to use the free test service. We'll also see different methods for testing in the cloud as well as the different uses for the Cloud initially and eventually.

Back to Top
Oracle 12c for Developers
Alex Nuijten , allAPEX
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

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.

Back to Top
Full Table Scan: Friend or Foe?
Mauro Pagano , Accenture Enkitec Group
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

"Full table scan is bad evil." How many times have you heard this claim? It's one of those myths in the Oracle performance world that never goes away.
It's only a myth and it's just plain wrong! Especially now with all the advancements in the software and not just Oracle.
How many times did you spend hours trying to avoid a full scan, just to find out performance wasn't that great once you get an index used?
This session focuses on why full scan has been demonized in the past, why this claim is false, why Oracle is smart enough to chose a full table scan when it's worth, and how to make sure that once Oracle choses it, the full scans runs at its best.

Back to Top
Adapting to Adaptive Plans on 12c
Mauro Pagano , Accenture Enkitec Group
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

Did you notice that many navigation apps can suggest, in real time, to deviate from the initial route because of traffic or accidents?
It's pretty cool right? You wanted to take 5th, but there is an accident so your initial plan doesn't look so good anymore once you hit the road.
Oracle 12c can do the same, the optimizer can generate an execution plan (your route) keeping the door open for changes in case more data than expected is being processed (traffic / accident).
This is a great feature but it requires a little shift in the way we think about performance; we need to be more open to changes just like our nagivation app.
This session focuses on how this feature works, what it means for us, when it can help us, and most important how to look at execution plans that can change after they started their execution.

Back to Top
Oracle Database Automation: From Snowflake Instances to DBaaS
Simon Pane , Pythian
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Begonia
Topic: Database - Subtopic: DevOps/Agile

Ever wonder why you can spin-up an Oracle Database environment from a public cloud provider in mere minutes yet it takes days to provision and configure one internally?

Oracle database provisioning and management using DevOps style processes may seem like mixing oil and water, but it doesn't have to be that way. In fact, it's very possible without any additional at-cost tools. The resulting automation leads to "efficiency," "standardization," and "consistency" - pillars of scalability for effectively managing large database environments.

This presentation reviews how organizations can implement database deployment and management automation as an underpinning technology for a DBaaS using common DevOps tools such as Ansible to: prepare servers, deploy Oracle software, create databases, implement DR configurations, and customize databases with site specific requirements in a highly automated manner, regardless of whether the host servers are physically on premise or in the public cloud.

The results are databases that are easier to manage, as well as a greatly reduced service time for database provisioning requests. Literally taking the implementation time down from days to less than one hour end-to-end!

Back to Top
Modernizing Your DBA Scripts with the Oracle Scheduler
Simon Pane , Pythian
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Begonia
Topic: Database - Subtopic: DBA

As the Oracle Database evolves, so should the way DBAs monitor and manage it. And even though the Oracle Database Scheduler was introduced over a dozen years ago with Oracle 10g, almost all DBA environments still rely heavily on the Linux (UNIX) CRON for scheduling of database monitoring, management, or backup jobs.

But the Oracle Database Scheduler isn't just for developers and application logic. Instead, it should also be the primary scheduling tool for DBAs and DBA scripts; regardless of whether those scripts are SQL based, Linux shell scripts, or Windows command (batch) files.

This presentation convinces DBAs why the Oracle Database Scheduler should be their tool of choice by covering the profound functional and security benefits of using the Oracle Database Scheduler over OS scheduling tools. How to use and manage the Oracle Scheduler effectively, including concrete examples on how to use it with Linux (UNIX) shell scripts and Windows command files is detailed. Finally, exciting new 12c Scheduler enhancements are discussed and demonstrated.

So whether it's for monitoring jobs, management/maintenance jobs, or even a database backup jobs (RMAN or otherwise), it really is "time to schedule with the scheduler" and get rid of all of those old-school CRONs.

Back to Top
Virtualization- To Infinity and Beyond!
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Begonia
Topic: Database - Subtopic: DBA

Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security?

This session builds on the impressive customer experience from Kellyn Pot’Vin-Gorman with years of architecting virtualized environments to show how to simply and securely migrate to the cloud. A full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the road-block to projects!

Back to Top
Oracle & Apache Kafka: Stories from the Message Bus Stop
Bjoern Rost , Pythian
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Begonia
Topic: Database - Subtopic: DB Tools

Apache Kafka is a massively scalable message queue that is being used at more and more places connecting more and more data sources. This presentation will introduce Kafka from the perspective of a mere mortal oracle DBA and share the experience of (and challenges with) getting events from the database to Kafka and possibly even back using different solutions and connectors.

Back to Top
DevOpsify DBA tasks
Bjoern Rost , Pythian
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DevOps/Agile

Organizations are struggling to manage and standardize an ever increasing number of
database deployments. This presentation shows how scripting and automation tools can
be used to provision databases and to manage resources like users, tablespaces,
instance parameters, and settings in general.
With this setup one can manage a large range of systems from a very small set of
descriptive text based configuration files. More so, these configs are easily managed in a
revision control system like git enabling agile workflows for database change
management.

Back to Top
Take a Walk on the Wild Side - A Beginner's Guide to Regular Expressions in Oracle
Helen Sanders , Temple University
Co-presenter(s): Justin Biard, Focal Trend, Inc.
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Azalea
Topic: Database - Subtopic: DB Dev

Don't let regular expressions scare you! They'll make your life easier once you get the hang of them! We'll give the lowdown on where they came from and how to use them. This session is especially for the novice/beginner, and is meant to be an introduction to regular expressions.

Back to Top
12 Things Developers Will Love About Oracle Database 12c Release 2
Chris Saxon , Oracle Corporation
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

Oracle Database 12c Release 2 is here!

The headline features are Sharding, Multitenant and Application Containers. But it's the improvements to SQL that make a real difference in your day-to-day life work with Oracle Database.

In this session Chris gives you an overview of the changes to SQL and PL/SQL that will help you build faster, more robust database applications.

If you're a developer or DBA who regularly writes SQL or PL/SQL and wants to keep up to date this session is for you!

Back to Top
SQL Magic!
Chris Saxon , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Dev

In this fun session you’ll see SQL used in new and exciting ways. Chris will perform SQL "magic tricks" including:

- Sawing the Query in Half: starting with a normal query, Chris will split it into smaller and smaller chunks that somehow all give the same result!
- Find the Card: After getting an audience member to choose a "card" (row) from a "deck" (table), Chris will find it by making it float to the top of the table.
- The Magically Changing Data Type: watch as a number changes to a date and back again!

But unlike real magicians, he'll show you how the tricks work. This will enable you to perform your own "SQL magic” and build better Oracle database applications.

This session is for developers and DBAs looking to expand their SQL skills. It highlights features that are new to 12c as well as little used existing options.

Back to Top
America’s Next Top Model-er Feature
David Schleis , Insum Solutions
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

Oracle SQL Developer Data Modeler (SDDM) is a remarkably useful tool, but despite all of the books, blogs, and presentations some of its most powerful functionality goes unused. Scripting within SDDM allows you to make modifications to your model, make sure that your models conform to your standards, and also create customized reports that can be used for import into other tools such as Jira.

This session is an introduction to the powerful scripting capabilities found in SDDM, and contains numerous examples of scripts and the SQLgr library that will help you capitalize on the wealth of information captured within your models.

Back to Top
Feelin’ Groovy – Scripting with SQLgr Hands on Lab
David Schleis , Insum Solutions
When: Jun 27, 2017, Hands on Lab Sessions 9-10, 3:30 pm - 5:45 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Tools

SQL Developer Data Modeler (SDDM) and SQLcl both provide the ability to enhance their power through scripting. While the default scripting language is JavaScript, fortunately Groovy can also be used. Groovy is an incredibly powerful and versatile scripting language already a part of a number of Oracle tools. Groovy is easier to learn than JavaScript and allows you to do more with less code.

This presentation is an introduction to the Groovy language and the SQLgr libraries. Focus will be placed on Groovy features specifically in regards to their use in the scripting of SQLcl and SDDM. Knowledge of these features, along with the SQLgr libraries, will allow attendees to begin building their own scripts immediately when then they get back to work.

Back to Top
Developing JavaScript Applications: The Oracle Offering
Shay Shmeltzer , Oracle Corporation
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

JavaScript might be the most used development language out there today. In this session, we'll review Oracle's tools and framework for developing applications with JavaScript. We'll talk about the complete ecosystem Oracle has built around JavaScript discussing and demo-ing Oracle JET, Oracle Application Builder Cloud Service, Oracle Developer Cloud Service, and more. Learn about the architecture and the relationships between the various products and when they'll be useful for you.

Back to Top
Developing On-Device Mobile Apps - A Visual Approach
Shay Shmeltzer , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

Learn how to create device resident applications without writing a single line of code in a visual way. See how Oracle Application Builder Cloud Service enables you to accelerate development of applications with an intuitive browser based development approach. Start from scratch - crete your DB objects and build your UI in minutes.

Back to Top
Understanding SQL Trace, TKPROF, and Execution Plan for Beginners
Carlos Sierra , Accenture Enkitec Group
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

On this session participants will learn about producing a SQL Trace then a summary TKPROF report. A sample TKPROF is navigated with the audience, where the trivial and the not so trivial is exposed and explained. Execution Plans are also navigated and explained, so participants can later untangle complex Execution Plans and start diagnosing SQL performing badly.

Back to Top
SQL Tuning 101
Carlos Sierra , Accenture Enkitec Group
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Bluebonnet/ Dogwood
Topic: Database - Subtopic: DB Dev

SQL Tuning is a complex and intimidating area of knowledge, and it requires years of frequent practice to master it. Nevertheless, there are some concepts and practices that are fundamental to succeed. From basic understanding of the Cost-based Optimizer (CBO) and the Execution Plans, to more advance topics such as Plan Stability and the caveats of using SQL Profiles and SQL Plan Baselines, this session is full of advice and experience sharing. Learn what works and what doesn't when it comes to SQL Tuning.

Back to Top
SQLcl & SQL Developer Tips & Tricks
Jeff Smith , Oracle Corporation
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

Fewer keystrokes, fewer clicks = more code, more productivity, more fun.

This session concentrates on the power features that most users bypass when using Oracle SQL Developer and our new command line interface, SQLcl. Do you use all of the shortcuts available to you? After this talk, you'll know how to get what you want, as quickly as you want.

We're rebuilding this session from scratch. That's right, in 2017, this talk will be BRAND NEW. So if it's been awhile since you've seen it, come back and get caught up.

As always, our goal is for each attendee to pick up one to three techniques that will drastically impact their productivity and save them time when working with Oracle Database.

Back to Top
SQL Developer: Three Features You're Not Using But Should Be
Jeff Smith , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DB Tools

You write SQL, get results.

You click around objects, get data to Excel.

You write PL/SQL, compile it and view your errors.

That describes what 80% of our users do in Oracle SQL Developer. This session will expose 3 features that will turbo-charge your experience with SQL Developer and the Database. This session aims to make you more productive and valuable to your Oracle Database development organization.

Learn how to take those 600 files you currently have all of your hand crafted SQL in and turn them into interactive reports.

Learn how to find stuff in your database by taking advantage of PL/Scope and our search feature.

Learn how to build your own screens - that's right, learn how to use a bit of basic XML and SQL to extend SQL Developer to do what you want it to do.

Back to Top
Hands-On Training: Using the Cloud (or Oracle Virtual Box) to Build a DBA Practice Environment
Richard Soule , C2 Consulting, Inc.
When: Jun 28, 2017, Hands on Lab Sessions 11-12 , 8:30 am - 10:45 am
Room: Goldenrod
Topic: Database - Subtopic: DBA

For those who really want to learn the how and why of building an Oracle Database system from scratch, this is your session! Bring your own laptop, or use one of our hosted servers and we’ll walk through the complete installation and configuration of an Oracle Linux desktop, Oracle Grid Infrastructure with Oracle Restart and ASM including ACFS, Oracle Database 12c Multitenant, Oracle APEX, SQL/Developer and SQLcl, and more. Best practices from building databases for real world deployments as well as from teaching Oracle Database Certification classes will be included throughout the session.

Back to Top
Do more with Data Pump: Tips and Techniques
Biju Thomas , OneNeck IT Solutions
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Verbena/ Periwinkle
Topic: Database - Subtopic: DBA

Datapump was introduced in Oracle Database 10g, and has evolved over the versions with various features and performance improvements to migrate data and objects. The legacy export (exp) / import (imp) utility is still maintained in all versions of database including 12c for backward compatibility, and to migrate legacy data to newer versions of database. In this session the speaker shows you how to extend datapump for your various data and object migration needs outside of copying a table or schema. You will learn to export public and private database link and synonyms, various object filtering and row filtering techniques, improving performance of data pump operations, migrate data without using any space for dump file, changing storage properties during export and import, and methods to verify the contents of export dump file.

Back to Top
Digital Transformation: Strategy for Moving from Legacy to Enterprise Mobility
Mia Urman , AuraPlayer
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

As mobile becomes the primary means for accessing information, enterprises must find a way to accelerate mobilization. The Oracle Mobile Cloud is the missing ingredient to create mobile apps at the speed of your business and empower the front lines of your business with back office data. Oracle Mobile Cloud Service provides built-ins for push notifications, object storage, user management, analytics, and an API designer and catalog. But what should you do if your business is stuck with a mountain of Oracle Forms or EBS? How can you leverage your existing business logic while transforming the user experience to the digital world? In this session we will discuss how to begin your mobile journey; Including real life examples of customers who have been successful at it! This session will also include demos of how Oracle Mobile Cloud Service makes it possible for customers to mobile-enable their legacy systems.

Back to Top
Leveraging Oracle Database In-Memory to Accelerate Business Analytic Applications
Kai Yu , Dell EMC
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Begonia
Topic: Database - Subtopic: DBA

By introducing In-Memory column store, Oracle Database In-Memory (DBIM) significantly improves the performance for analytic queries as well as mixed workloads. Come to this session to learn Oracle Database In Memory under the hood: the dual format memory architecture and configuration, how the data is populated into In-Memory column store and it helps query performance. . This presentation also covers further enhancements of DBIM in Oracle Database 12cR2: Join group, and In-Memory expression, In-Memory active Data Guard support, etc. Through some case studies of business analytics projects, this presentation covers the practices of leveraging DBIM to improve the query performance of business analytic applications and how to use In-Memory adviser to determine the objects that need to be loaded into In memory column storage . We also will present some analysis on the performance gains by using IM memory features and when and how these gains can be achieved.

Back to Top