Houston Oracle Training Day
Architecting the Database, Micro-services, and Applications on Oracle for Maximum Availability Architecture and Disaster Recovery
Thursday, October 19, 2017, 1:00pm - 4:00pm
Houston Oracle Training Day
118 Vintage Park Blvd W, Houston, TX 77070
October 19, 2017, 1:00pm – 4:00pm Central Time Zone
(lunch provided by Viscosity)
1:00 - 2:05 Drill into 12.2 Analytic Views for Developers, DBA’s, and Analysts
With Oracle Database 12c Release 2, Oracle has included a new metadata-only solution to multi-dimensional analysis that works like most dimensional databases and BI cubes. In a typical Business Intelligence (BI) stack, this functionality would usually be spread across an ETL layer, a repository layer, and a tool layer. This distribution can make it difficult to troubleshoot the logic and data between what the user sees and what is in the transactional database source. Analytic views eliminate this distribution by providing, in a single metadata construct: attribute dimensions, hierarchies, views, measures, and even documentation. Oracle has extended its SQL language to allow for very simple SQL statements that do complex things like navigate different hierarchies and aggregations. We will illustrate all of these features with an Apex application that does multi-dimensional analysis.
2:10 - 2:55 Secure Your Insurance Policy: Architecting Maximum Availability and Disaster Recovery with Oracle Cloud
No matter what the corporate cloud strategy is, customers need to ensure that databases can be recovered anywhere. Viscosity will provide the latest backup and recovery strategies using new capabilities in Oracle Database 12c Release 2, and related on-premises and cloud solutions. Learn cool tips, tricks, and best practices to enable you to build a complete disaster recovery solution with Oracle Recovery Manager.
We need to ensure that secure backups are performed and that the data can be restored when disaster strikes. Leveraging technologies like Oracle ZFS Storage Appliance Cloud Pools and Oracle Cloud Storage Software Appliance, we can easily achieve seamless data replication from on premise to Oracle Cloud to provide ongoing protection, restoration, and recovery of the data when media and hardware failures occur or even in the loss of the data center? We will provide an architected solution to provide a hybrid disaster recovery solution. The objective is to provide database availability, continuous protection, and reduce IT OpEx while safeguarding the company mission critical Oracle databases.
3:00 - 3:40 Architecting Micro-services and Applications on Oracle for Maximum Availability and Disaster Recovery
3:45 - 4:30 Upgrading to Oracle Database 12c Release 2 with Zero Downtime
Many companies opt to perform a technology refresh when they are ready to do a database upgrade. Learn what is needed to perform a zero downtime upgrade of the databases on ODA/Exadata/X-86 hardware. Database upgrades consume a lot of the corporate resources for testing and infrastructure staff. We will show how you can reduce up the upgrade timeline and testing cycles by rapidly provisioning of DEV/TEST/UAT environments on Oracle by leveraging technologies like Snapshot Manager Utility (SMU) on the ZFS Storage Appliance. Also, reduce your storage footprint with deep deduplication and compression on the ZFS Storage Appliance and Exadata.
About the Presenters
Charles Kim is an Oracle ACE Director, a VMware vExpert, an Oracle Certified DBA, a Certified Exadata Implementation Specialist, and a Certified RAC Expert. With specializations in RAC, Exadata, Cloud, complex data replication, and virtualization, Charles has co-authored of nine books on Oracle Database. Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft, and has over 26 years of Oracle experience on mission- and business- critical databases.
Charles presents regularly at local, regional, national, and international Oracle conferences, including COLLABORATE, VMware World, and Oracle OpenWorld, on topics of RAC, ASM, Cloud, Linux best practices, Data Guard best practices, VMware best practices, Oracle on VMware virtualization, and 7×24 high-availability considerations. Charles is also the founder and president of Viscosity North America, a niche Oracle consulting company specializing in Exadata, RAC, virtualization, and Oracle Cloud. Charles is also the president of the Cloud SIG for the Independent Oracle User Group.
Managing Partner, Viscosity
Jerry Ward is a co-founder of Viscosity and runs the Application Development efforts for our customers. Prior to joining Viscosity, Jerry served as a consulting architect for VHA, Kellogg Brown and ROot, Invesco, Fidelity National Financial, Dresser Rand, Ericsson, Nortel Networks, and the Human Genome Sequencing Center.
Jerry has worked with Oracle technology since 1991, including Oracle Applications version 9+ and Oracle database version 6+, Oracle Applications Express (APEX), Oracle Forms, and Oracle Reports. He has been featured in several business publications such as Gulfscapes Magazine, Houston Chronical, Venice Magazine, KXAN Austin, Tyler Morning News, and more.