RMOUG welcomes anyone who would like to attend the meeting.  The meeting is free to all current RMOUG members and current Regis students. There is a of $15.00 charge for Non-members attending the meeting.

Presentations:Session 1:

9:30am – 11:00am – “DBA 2.0 Is Dead. Long Live DBA 3.0!”

Session Abstract:
If you are an Oracle DBA who is wondering what the future of that role will look like, this session is the perfect antidote to ending your speculation. We will look at five key trends in the IT industry – Cloud, Big Data, IoT, Security, and Reshoring – and how they are impacting the role of the Oracle DBA within IT organizations. Most of all, this session will explain why it’s absolutely crucial to transform yourself into from DBA 2.0 to DBA 3.0 in 2017.

Session Outline:
We’ll discuss five key trends and their impact on the role of the Oracle DBA:
– Cloud: Caveat Nuba Emptor
– Big Data: Facts Replace Beliefs. (Sometimes Painfully.)
– IoT: Alexa, Buy Me a Dollhouse!
– Security: Building Better Levees Against the Storm
– Reshoring: Offshoring Meets Its Match

Category:  Database
Experience Level: Beginner
Target Audience: Database Administrators, Developers, CxOs, Managers

Session 2: “Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2″

Session Abstract:
As experienced Oracle DBAs know, building a Data Warehouse is just the beginning of any successful application for performing complex analytics – you’ve also got to build the proper analytic views, fact tables, dimensions, and queries to make sense of the DW’s data. Oracle 12cR2 now provides a simple way to build out just the right objects for an analytics environment using just a few simple commands. Best of all, these new objects can incorporate all the needed measures and calculations so that an application end-user can take advantage of precisely-defined data models without having to construct complex views on their own, thus limiting the chance of producing erroneous analyses through a simple mistake like a missing join or filter.

Session Outline:
Through presentations and demonstrations, this session illustrates how to leverage the latest features of 12cR2 Analytic Views to:
– Build complex hierarchical relationships between data elements
– Enhance analysis techniques for use across multiple dimensions
– Leverage built-in functionality to quickly construct measures and metrics with a simple set of commands

1. Introduction to Built-In 12cR2 Analytics Features
2. Constructing Hierarchies and Relationships: CREATE HIERARCHY
3. Adding Enhanced Dimensions: CREATE ATTRIBUTE DIMENSION
4. Building Analytic Views: CREATE ANALYTIC VIEW
5. Putting It All Together: Examples of the Power of Analytic Queries
6. Conclusions

Objective #1:
The attendee will understand how to build complex hierarchical relationships and dimensions with simple 12cR2 commands.

Objective #2:
The attendee will discover how to quickly create complex analytic measures and metrics without having to build equally-complex queries.

Session Prerequisites:
To gain the most from this presentation, attendees should be familiar with basic data warehousing (DW) and decision support systems (DSS) concepts, including hierarchies, dimensions, fact tables, and materialized views.

Category:  Database, SQL, Exadata, Data Mining
Experience Level: Intermediate
Target Audience: Database Administrators, Developers