Quest Experience Week: Database and Technology Day

It is a formidable task to ensure Business Critical Applications meet business SLA’s within the given RTO/RPO and this requires simplifying , standardizing and automating the deployment and configuration along with providing HA and DR these critical applications to meet the above business objectives . VMware Hybrid Cloud which includes VMware Cloud on AWS and Oracle Cloud VMware Solution (OCVS) provides consistent and interoperable infrastructure and services between VMware-based datacenters and the Public cloud, which minimizes the complexity and associated risks of managing diverse environments.

This session will show the lifecycle of BCA workloads on VMware Cloud on AWS. This includes the methodology of migrating Oracle BCA from a Physical architecture (Big Endian) , Engineered Systems or non-VMware virtual platform to VMware vSphere with all best practices. This session will also show providing HA and DR across multi-AZ using Stretched Clusters for VMware Cloud on AWS for all cloud use cases.

Tired of continuously adjusting your performance monitoring and alerting rules? How about using machine learning to create the rules instead! Sure, we can train a supervised ML model to recognize patterns of poor performance. But what if your IT department is not ready to embrace it?

A novel solution is to train a supervised machine learning model to recognize patterns of poor performance, but then extract the rules in plain English and then manually enter them into your existing monitoring and alerting platform. Is this possible? Yes it is! And, I will demonstrate how you can do this.

To ensure you can easily do everything I do, I will use industry standard Python ML libraries, the industry standard Jupyter notebook, AWR and support ticket data. You can experiment with the demonstration materials “as is” and then use them to push your ML and rule creation knowledge deeper.

Introducing Oracle Zero Downtime Migration (ZDM), Oracle premier automated tool for moving your database from on-premises to the Oracle Cloud. ZDM is an automated tool that leverages the best of high availability and scalability solutions at Oracle  thus moving your Oracle Database to the Oracle Cloud with no downtime. In this session, we will cover in-depth the full range of features and functionality of Oracle Zero Downtime Migration, how it was designed and built and how it can be leveraged for all your migration needs. We will finish by discussing roadmap for ZDM and all things Oracle Database Cloud Migration.

What’s the next role for the DevOps or DBA as the autonomous database and Oracle enhancements free up time? This session will cover the role (managing more databases with autonomous database) & the integration of AI and Machine Learning. Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.

At Oracle Open World 2019, Oracle announced an Always Free Tier of cloud services. This session will review what’s available with these free cloud services such as Oracle autonomous databases including Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP), compute with up to 2 virtual machines, storage including block, object, and archive storage. We’ll explore how these free services work and what can be done with them, such as creating proof of concept systems. Looking for data? No problem! We’ll explore the vast number of free data sources that are available and can be consumed using Application Programming Interfaces (APIs). Once we combine the two, we can easily pull data into these cloud services while creating fully functioning applications including the use of Oracle Application Express (APEX).

The interesting thing about a graph is that we can use it with almost every application. We can view most data sets as a graph, and that gives you the ability to see your data through the connections and relationships between data entities. Once you represent your data as a graph, you can apply graph algorithms to get new insights into your data. In this session, I will discuss how you can create a graph from relational tables in Oracle Autonomous Database, apply graph algorithms to this graph, and use the results in your applications. My goal is to demystify graph analytics and help you get started using graphs in your analytics applications.

In this era, data privacy and security is a major concern. It is a challenge to be compliant with the standards as far as data security is concerned. Oracle Advanced Security options provide us easy ways to protect our databases and be compliant at the same time. This session will give an overview and use cases of several impactful Oracle Advanced Security features we have been using for our SaaS applications in real life production systems. In addition to that, there are several other in-house best practice we have developed over the years which might be beneficial for others.

This presentation will look at which 19c new features that should be investigated for use. This presentation will also have a few 21c new features such as AutoML. This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation – & others). Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. Some features are too new to show example, but only explain. We will also look at the autonomous database and Oracle’s focus on the future of security.

Learn why customers choose Oracle Cloud Infrastructure (OCI) to run PeopleSoft and JD Edwards even when they have existing investments in other Clouds. It comes down to superior economics, single vendor support, application certification, predefined deployment architectures and security postures, the broadest data management platform, lightning fast performance – with the peace of mind of the broadest service level agreement of ANY cloud.

You think you have seen it all… and then you see something new. I have studied literally hundreds of AWR reports and thought through thousands of performance scenarios. While I know how to use an AWR or Statspack report to analyze Oracle performance, I have also learned how to totally mess-up the analysis. There are some obvious ways to totally invalidate your analysis. But there are also some subtle mess-ups that fool you into thinking your time-based analysis is rock solid…yet it’s worthless and probably misleading. Join me for a light-hearted session as we explore what NOT to do.

Solving today’s business problems increasingly relies on machine learning techniques to leverage the volumes of data enterprises both amass and have access to. Oracle Machine Learning empowers data scientists, data analysts, DBAs, application developers, and executives to realize machine learning-based solutions faster and more easily. Automation of the model building process, referred to as AutoML, along with the ability to scale to enterprise data volumes while maintaining data security in Oracle Database, all come together to meet enterprise needs. In this session, learn about the in-database machine learning features and services, including those related to Oracle Autonomous Database. This session will include demonstrations and previews of Oracle Machine Learning functionality.

One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to LOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue. This presentation attempts to fill that knowledge gap.