If you missed my day 4, you can view it here.

The main bulk of the conference was over, with all the keynotes presented. Today was more Oracle, partners, customers and end users sessions to wrap up the conference.

20x Faster Analytics, 25x Faster Machine Learning with MySQL HeatWave on AWS

I’m not so familiar MySQL and I hadn’t heard of HeatWave this CloudWorld, so I thought I’d try something different and went to this session. Mandy Pang, Senior Principal Product Manager at Oracle explained how MySQL HeatWave is one database for OLTP, OLAP and Machine Learning.

She went on to explain the continuous innovation in MySQL HeatWave.

It was here where I came to fully understand that MySQL HeatWave is the traditional MySQL database for the backend but has a in-memory layer on top called “HeatWave” which effectively accelerates OLAP and Machine Learning.

It’s very similar to the Oracle Autonomous Database as in many common tasks are automated and it has extreme performance.

Next Nitin Kunal, Director, Software Development at Oracle explains how MySQL HeatWave is faster then RedShift, Snowflake, Big Query and Synapse.

It’s also better price performance than Redshift, Snowflake, Big Query and Synapse.

He also went onto explain:

Innovative in-memory hybrid columnar engine

Massive Parallel Architecture using high-fanout partitioning

Multi engine query optimisation

Zone map

Lazy decompression

Auto Query Plan Improvement

Auto Scheduling, reducing wait time for mixed (OLTP & OLAP) workloads

Auto Data Placement, ML prediction of optimal in-memory partitioning column

After the session I had a wonder in the DevNucleus area and saw the RedBull racing simulators and the world’s largest Raspberry Pi cluster!

Using Machine Learning Models to Assist Programming of Cochlear Implants

My next session was one that was an interesting topic as my parents are both profoundly deaf, so I was intrigued to how Machine Learning Models could assist programming of cochlear implants.

It was early days but Max Storr, Data Analytics Engineer from DSP-Explorer explained how a cochlear implant has 22 channels and that they need to be fine tuned which a highly skilled clinical staff would do over several appointments. With the Machine Learning, they were able to predict the settings reducing the overall tuning period. As still early days, there was more proving and convincing the National Institute for Health Research for the Machine Learning to be incorporated into the process and helping patients.

Oracle Database Service for Microsoft Azure Best Practices

Next session was one I was interested in, as would give me better insight into the more recently new services of Oracle Database Services in Azure.

Suzanne Holliday, Senior Principal Product Manager, Oracle Cloud Database Services and Tammy Bednar, Senior Director of Product Manager, Oracle Cloud Database Services presented this one.

The services effectively allows Azure customers to provision an Oracle Database in OCI directly from Azure. It allows direct access to the database over private Azure-OCI interconnect, unlocking all the benefits of Oracle database Services to Azure customers.

All the networking is provisioned automatically, and the Azure ExpressRoute and OCI FastConnect data and port charges are all included.

Some pre-provisioning best practices in both Azure and OCI.

In summary, a lot of automation simplify the user experience, single sing-on using Azure AD credentials, manage from Azure portal with integrated monitoring and finally get collaborative support from Microsoft and Oracle for any issues.

AutoUpgrade 2.0: Internals and New Features

Next session was about AutoUpgrade tool, talking about new features.

Rodrigo Jorge explains the first of many new features, the ability to apply Release Updates via AutoUpgrade.

Next Daniel Overby Hansen, explained how AutoUpgrade can now handle encryption but a keystore needs to be configured.

Next Rodrigo explains when you have multiple PDBs and RAC cluster with low number of CPUs per node, then distributed upgrades of the PDBs can be done over 2 nodes to parallel run PDB upgrades to reduces the overall time by utilising 2nd node CPUs.

Finally went over some new console commands.

Automatic Index Management in Oracle Database

The penultimate session, about Automatic Index Management, which is an exclusive Exadata feature.

Explaining how managing indexes has become a specialist skillset and how we rely on experts to manage.

What Automatic Indexing does, is being that “expert” 24 by 7 at no extra cost.

It works in the background without inputs or action but does allow for preferences and give ability to check activity through reports.

Similar to how manual indexing is done, identify potential new indexes, verify they give better execution plans, decide to implement, validate whilst invisible, then if validated then make visible and monitor for usages. If not used for 3 months, drop index.

Encryption is Easy – Make Key Management Easy Too with Oracle Key Vault

The final session of Oracle CloudWorld is about Oracle Key Vault.

Oracle Transparent Encryption (TDE) has been around since 2005 and has been getting easier over time.

TDE innovations over time, online encryption, column encryption, split TDE in Data Guard, etc.

Encryption introduces key management needs of key governance and compliance, secure key sharing and archiving such as in RAC, key management at scale!

Oracle Key Vault resolve all this with a High Availability and Diester Recovery architecture, so it doesn’t become a single point of failure. No keys no data!

This now concluded Oracle CloudWorld, and it was starting to get empty at The Venetian.

Time to take one last photo!

Also getting empty at the Caesars Forum!

The date for next year, 18th to 21st of September 2023. Hopefully I’m back!

As I go to the monorail to take me back to my hotel, I pass through Hall A-D as they already start to get cleared up!

The conference may have ended but tomorrow is the Oracle Ace Adventure and we’re off to Grand Canyon 😎😁👍🏽

You can view my day 6 here.

If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this Oracle blog via WordPress/e-mail.

Thanks

Zed DBA (Zahid Anwar)