Archive for the ‘Oracle BI’ Category

My Presentations at Germany Oracle User Group Conference (DOAG2019)   Leave a comment

Next week I will be presenting the two following topics at Germany Oracle User Group Conference (DOAG2019):

Cloning Oracle EBS Database With Snapshot for DEV/Test

Abstract: For many complex database applications such as Oracle E-Business suite, it is quite common that a production environment needs 10 or more copies of various development and test purposes. This database clone process to create these many copies of production database can be very challenging and costly especially when the database gets larger than multiple even over 10 terabytes (TBs). This session will discuss two snapshot based methods that can help IT simplify this database cloning process and reduce the time and resource cost: The method is called Oracle gDBClone which is based on Oracle ACFS snapshot. The second method is based on database storage volume snapshot provided by the storage array. With a real example in our IT department, we will discuss the implementation details of these two methods and discuss the pros and cons of these two methods.

Oracle ADW for Advanced Analytic and Machine Learning

Abstract: Oracle Autonomous Data Warehouse (ADW) provides a fully automated data warehouse specific features to deliver outstanding query performance. As a fully managed cloud service running on high performance Oracle Infrastructure Cloud (OCI), ADW also comes with a new set of tools such as Zeppelin-based SQL notebooks for advanced analytics and Oracle machine learning. This session will examine the architecture of Oracle ADW and its collaborative environment. Then we will discuss how application developers and data scientists can leverage this environment: how import and export large set of data to/from ADW database instance, and how to build, evaluate, and apply machine learning models with SQL notebooks. With several examples, I will share some troubleshooting experiences and tips of building such advanced analytics and Oracle machine learning applications in Oracle ADW.

The  presentation slide deck links have been listed on the presentations section of this blog.

Thanks IOUG for Accepting My Presentations for Collaborate 17   Leave a comment

Just received a great news from IOUG that three of my presentations were accepted for Collaborate 17.

. Session #724:  Oracle DBAs, It is time to have a first taste of Oracle Database Cloud Service

    Abstract: As an important part of Oracle Cloud offering, Oracle Database Cloud service provides an easy of use enterprise-proven highly available and scalable database service. Oracle database cloud service can be the first “going to Cloud” that you, an Oracle DBA may experience. This session helps you get the first taste of Oracle Database Cloud service. It will examine choices of of database cloud services and help you to determine which one would fit in your business requirement. It will also discuss the technical expects of each of cloud services. Through a few examples, the session will discuss the DBA tasks and how you would perform in the new database environment ranging from creating database cloud service to managing the databases.

. Session #487, Leveraging Oracle Database In-Memory to accelerate Business Analytic Applications

Abstract :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 advisor 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.

. Session #437: Get ready to upgrade your Oracle databases to 12c: tools, methods and paths

Abstract: In this session we will share some of our experience on upgrading different versions of Oracle databases to the  latest Oracle 12c. Attend this session you will learn the upgrade tools and various upgrade paths that help you plan your upcoming database upgrades. This will include upgrade methods for multitenant databases.  Another focus area of this session is Oracle RAC database upgrade which includes Oracle Grid Infrastructure upgrade and Oracle RAC database upgrade. You will also learn how to use the rolling upgrade for Oracle Clusterware and ASM and Oracle RAC database to reduce the database downtime.
And it will be my great honor to join my fellow Oracle ACE Directors and Oracle ACEs  as a co-speaker for their sessions:
. Session #779: Oracle VM, OEM13c and Cloud Computing – Expert Panel by   Tariq Farooq and Charles Kim and Kai Yu
. Session #518: Oracle 12c R2 Expert Panel by Anuj Mohan, Jim Czuprynski, Kai Yu, Seth Miller
And at last , but certainly not least,  I am waiting for  IOUG Collaborate 17 conference committee to accept one of important sessions in Cloud area:  the  IOUG Cloud SIG session: Session #711 Cloud Experience-To the Cloud and Back -Hands on Workshop by Steve Lemme, Charles Kim, Try Logon, Erik Benner, Kai Yu, Seth Miller.
See you at Collaborate 17@Vegas , next April!

 

My Upcoming Presentations at Collaborate 15 Conference   Leave a comment

At the upcoming Collaborate 15 conference (April 12-April 16), I will be giving three technical presentations and joining a technical panel as panelist. The presentation schedules and abstracts are listed as follow:

1. Optimize Oracle BI with Oracle 12c in-memory Database option
OAUG presentation, session #10502, Track: Business Analytics
April 13, Monday 12:45 PM – 1:45 PM | Room Jasmine C

Abstract: By adding the in-memory columnar-store feature, the recently released In-Memory Database option is designed to significantly improve query performance for OLAP application. This presentation will explore how to leverage this In-Memory feature on the Oracle OBIEE analytics environment. This presentation will use an financial analytics project as a case study to explore the best practices, lesson learned, performance studies of applying In-Memory database in the business analytic applications.
Session link: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=2129

2. Design and implement your own self service Enabled Private cloud with Oracle Em12c

IOUG presentation and virtual session: session #464, Track: Cloud Computing
April 14, Tuesday 2:00-3:00pm| Room: Palm D
Abstract:: Today when IT organizations plan to deploy Oracle database and applications in cloud, they may look at either using Oracle public cloud service or building their own private cloud. For those who would prefer to building and hosting their own private cloud, there are a quite few Oracle technologies that are designed for this purpose. This session will discuss some of these technologies and methodologies that Oracle used to build the Oracle public cloud: Oracle EM12c cloud management, self-service portal and Oracle Virtual Assemble Builder (OVAB). Using a case study as an example, this session will show how to design and build your private cloud with these technologies and to show how to implement the important cloud service: application self-service provisioning which is featured in Oracle public cloud.
Session Link:: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=3530

3. Zero to 100MPH at the speed of cloud employing Oracle database on public cloud
IOUG presentation and Panel with panelist, session #530, panelists: Charles Kim, Kai Yu,Tariq Farooq
Track: Cloud Computing
April 15, Wednesday 9:15am-10:15am | Room: Reef F

Abstract: The Expert Panelists/Speakers will present a comprehensive overview of the Oracle Database Cloud Service offerings by covering Best Practices, Experiences, Insight, Tips and, a whole lot more about employing/deploying the Oracle Database Server family on Oracle’s Public Cloud.
Session link:: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=3531

4. Implementing oracle database 12c heat map and automatic database optimization for database storage performance and cost
IOUG presentation and virtual session: session #464, Track: Cloud Computing
April 15, Wednesday 3:15-4:15pm | Room: Palm A

Abstract: While SSD (Solid State drive) based storage significantly improves the database performance by removing the storage IO bottlenecks, the cost of SSDs is still much higher than ones of regular spinning disks. As a cost effective way to leverage SSDs performance, the Storage tiering method stores those active data in high performance SSD storage and store those less or inactive data in low speed conventional spinning storage. While the store tiering methods is usually implemented on the storage level and setup by the storage admin, Oracle 12c Heat Map and Automatic Data Optimization (ADO) together called Information lifecycle Management (ILM) provide a great way for DBAs to automate the storage tiering for database segments on database level . This session will show the steps and method by which DBAs can use to implement these Oracle 12c features to automate the compression of database segments as well as movement of them to another tier storage based on the usage of the data.
Session link: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=3555