Pre-Conference Workshops

Tuesday, May 15, 2018

Pre-registration and additional fee required.

9:30 am - 12:30 pm
SmartDB vs. Layered Architectures in the Real World
John Clarke, Oracle Corporation

Layered software architectures are a common modern application architecture and typically start with an object-oriented domain model in the middle tier.  Interaction between the application code and the database is implemented in a series of primitive put/get instructions, and the database is treated simply as a persistence layer.   Layered architectures move data to the processing layer in units of the lowest common denominator, perform processing, and then save changes to the databases.  The SmartDB paradigm, on the other hand, uses the database as processing engine, bringing the processing to the data.  

There are consequences and costs associated both with moving business logic outside your data tier and with adopting the SmartDB paradigm, and in this session, we’ll cover the performance aspects of these architecture choices.  But simply “running faster” isn’t always the right answer; developer productivity, agility, total costs of ownership, and other factors play major roles in application architecture suitability. We’ll tie these factors together and describe how your architecture choice might be impacting your organization.

John Clarke is a performance engineer and Software Development Director in the Real World Performance group at Oracle.  Real World Performance (RWP), a part of Oracle’s database development team, focuses on customer escalations/benchmarks/POCs, internal database and applications performance projects, and training/education.  With RWP, John leads the group focused on internal database and applications initiatives and in this role has contributed to a number of Data Warehouse, In-Memory, SaaS/Applications, and Optimizer projects.    Prior to Oracle John was an Oracle architect with Centroid Systems, a Michigan-based Oracle partner.

9:30 am - 4:30 pm 
Oracle APEX Developer Day
Click here for the agenda.

Oracle Application Express (APEX) is becoming more and more popular as organizations discover just how quickly they can build and deploy web and mobile applications using this deceptively powerful tool.  We will hear from APEX thought leaders who will share important insights into how to get the most out of your investment in Oracle and specifically APEX. 

We will close the day with a series of “Lightning Talks”, where APEX developers will give 10 minute demos of some cool applications they’ve built. These lightning talks are a great way to see the possibilities with APEX, and can kick start your own ideas.

So, if you've ever been curious about building web applications, or may have heard of APEX and are interested in learning more, please join us for APEX Developer Day!

10:00 am - 4:00 pm 
AWS Cloud Database Workshop
Various Instructors
Limited to 30 people

Spend the day learning from the engineers that stand behind the Amazon RDS for Oracle cloud and their relational data services.If you have been thinking about using the cloud or have questions about what makes Amazon RDS for Oracle unique, then attend this workshop.No prior cloud experience is necessary.If you believe in learning by doing, this is the workshop for you.Walk away from the day with the knowledge that you can navigate the Amazon RDS for Oracle cloud with confidence.

1:00 pm - 4:00 pm 
From A to Z on Oracle Analytics Cloud
Edelweiss Kammermann & Gustavo Gonzalez, IT Convergence   

Oracle Analytics Cloud is becoming one of the leaders in the Business Intelligence and analytics space. It offers a complete Platform in the Cloud including products such as: Essbase Cloud, Oracle Data Visualization Cloud and even BI Publisher with the latest release available just in December 2017. Based on four pillars - Connect, Prepare, Explore and Share - Oracle Analytics Cloud allows users to connect to more than 50 different data sources, tools for auditable and traceable data handling and a rich self-service visualization, exploration and socializing insight across the organization. From the administration’s perspective, you have the flexibility of managing and monitoring your own cloud environment, deciding when to scale up and/or down, when to apply patches or roll back, and even when to upgrade to a newer version.

In this workshop, we’ll introduce the concepts of working with multiple data sources - even your own personal files as a source, how to prepare the data using the powerful tools available in OACS as well as how to build stunning visualizations for your organization. The workshop will have some concepts, live demos, and discussions on what would be the best approach to adopt this technology at your workplace. Last but not least for those running Oracle Business Intelligence Enterprise Edition (OBIEE), we’ll explore and demonstrate best practices and lessons learn while performing the upgrade from your on-premise OBIEE to Oracle Analytics Cloud Enterprise Edition.

Edelweiss Kammermann, Business Intelligence Manager at IT Convergence, is a Business Intelligence, Data Visualization and Data Integration specialist with over 19 years of consulting and project management experience in Oracle technology.  She is a founding member and Vice President of the Oracle User Group of Uruguay (UYOUG), a member of the Communications Committee and Director of Community of Latin America Oracle Users Council (LAOUC). An Oracle ACE Direction, she has been a University instructor since 2001 and teaches a variety of courses including OBIEE, BPM, BI Publisher, Oracle Warehouse Builder and Oracle Data Integrator. As a writer she runs a blog about BI, DW and Data Integration in Spanish and has published technical articles on OTN (English), Rittman Mead blog, Linkedin and OTN Latin America (Spanish). Edelweiss holds a Bachelor of Science & Information Technology Engineering, Universidad de la Republica, Uruguay.

Gustavo Gonzalez is IT Convergence's Chief Technology Officer (CTO), defining the strategy for technology platforms, partnerships, and external relationships, and providing visible leadership for the company. He began working with Oracle tools and solutions in the late 1990s, joining IT Convergence as Global IT Director in 2006. In 2008 he led IT Convergence’s upgrade of Oracle E-Business Suite to Release 12, making ITC one of the first companies in Latin America to use this new version. Gustavo was distinguished as Oracle ACE Director in November 2012, becoming the first in Argentina and Latin America with the specialty in Applications. He has delivered presentations in more than 200 conferences and has co-authored Oracle E- Business Suite Financials Handbook, Third Edition, published by McGraw-Hill and Oracle Press. He is co-founder and current President of AROUG (Argentina Oracle User Group) and member of the board of LatinOAUG, as well as current President of Latin America Oracle User Community (LAOUC). Gustavo holds Master in Business Administration (MBA), University of Buenos Aires, CABA, Argentina  and Bachelor Systems Engineer, UNICEN University,  Tandil, Buenos Aires, Argentina.

1:30 pm - 4:30 pm 
Modern Analytics and Warehouse Query Performance
John Clarke, Oracle Corporation

In our group we aim to make software perform to the capabilities of our hardware, so with today’s fast hardware, exceptional DW query performance is attainable.  Yet many customers suffer from suboptimal query performance, even with modern systems.  In this session you will learn what can be done and what should be done for DW query performance on Oracle, starting with the basics of data modeling and then walking through our Real World Performance “recipe” for DW query performance.  With this foundation, we’ll explore performance features and capabilities designed to turbocharge data warehouse queries and also discuss diagnostics and troubleshooting techniques.  At the completion of the session, each attendee should be able to understand what their execution plans should look like and know where to look in SQL*Monitor to assess whether their query performance is as fast as it can be.

John Clarke is a performance engineer and Software Development Director in the Real World Performance group at Oracle.  Real World Performance (RWP), a part of Oracle’s database development team, focuses on customer escalations/benchmarks/POCs, internal database and applications performance projects, and training/education.  With RWP, John leads the group focused on internal database and applications initiatives and in this role has contributed to a number of Data Warehouse, In-Memory, SaaS/Applications, and Optimizer projects. Prior to Oracle John was an Oracle architect with Centroid Systems, a Michigan-based Oracle partner.