NorthEast Ohio Oracle Users Group

September 30, 2016
NEOOUG Business Meeting

Featured Presentation


Please pre-register here to let us know if you plan to attend. This will immensely help us in planning.

1:00 pm - 2:30 pm - Split Brain Syndrome: Barriers to Oracle Database In The Cloud
Speaker : Tim Gorman, Delphix

Cloud vendors 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 are 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 makes "split-brain IT" not just possible, but desirable.

3:00 pm - 4:30 pm - Scaling To Infinity: Partitioning Data Warehouses on Oracle Database
Speaker : Tim Gorman, Delphix

There is a lot of talk about big data, and it is often associated with Hadoop and other NoSQL databases. But SQL and Big Data are not mutually exclusive. There are petabyte-sized databases on Oracle Database, and this is how they happen.
This presentation is distilled from 15+ years of extensive experience implementing multi-terabyte databases to support data warehouses on the Oracle RDBMS. One of the most important technical decisions is how to implement partitioning within the Oracle RDBMS to optimize query performance for response time even as data volumes increase, and also to optimize data loading to maximize availability during data loading, eliminating downtime and minimizing impact on the system. Partitioning is also implemented to optimize storage by enabling compression and taking advantage of "tiered" storage strategies and READ ONLY tablespaces.
Partitioning is the key to unlock the full power of numerous advanced Oracle features for data warehousing in a way that is not explicitly documented by Oracle.
This interlocked dependency between features is described by the presenter as the "virtuous cycle." Not starting with partitioning on a data warehouse project can lead to a deadlock of unfortunate circumstances that can doom the project to failure, which the instructor characterizes as the "death spiral." In fact, one of the most important query optimizations for data warehouses in Oracle known as "star transformations" is effectively unavailable without using properly implemented partitioning.

Mr Gorman is a technical consultant for Delphix, who enable data virtualization integrated with data masking to increase the agility of IT development, testing and operations.
He is current president of RMOUG (Rocky Mtn Oracle Users Group) and has been an active member since 1992.
Mr Gorman also serves on the board of the Project SafeGuard Foundation (PSGF), which manages funds in trust for Project SafeGuard and its mission.

Tim Gorman has worked in the information technology (IT) industry since 1984, as an Oracle application developer since 1990, as an Oracle database administrator (DBA) since 1993, and as a skilled optimizer of performance on applications and systems built on Oracle technology since the mid-1990s.
In moving to Delphix in 2014, Tim now optimizes the performance of the IT organization itself, in addition to the systems that organization builds.
Tim has co-authored six books on Oracle technology, and has performed technical review on seven more books, has been an Oracle ACE since 2007 and an Oracle ACE Director since 2012, has been a member of the Oak Table Network since 2002, and has presented at Oracle Open World, Collaborate, KScope, Hotsos, RMOUG, UKOUG, and Oracle users groups in lots of wonderful places around the world.