Eliminating database I/O latency with Oracle 21c/19c Persistent Memory features

Database I/O latency often posts significant performance bottlenecks on database systems. Oracle Persistent Memory database and the Oracle Memory Speed File system(OMS) introduced Oracle Database 21c and 19c respectively provide the support for Persistent Memory (PMEM) as database storage and significantly reduce database I/O Latency. By mapping database buffer cache directly onto Persistent Memory storage, Persistent Memory Database directly uses data residing in the Persistent Memory storage and eliminates the latency of copying data into the database buffer cache. This session discusses these two features in detail and how we leverage them to achieve the extremely low latency and high throughputs in a high performance database system. This session provides the step by step how-to details of implementing these two Persistent Memory database features, also provides the use cases & performance benefit studies of leveraging these two features in a high performance database system.

Achieving Extreme Scalability &Total Fault Isolation with Oracle Sharding 21c

Oracle sharding architecture horizontally partitions data across discrete Oracle Databases (shards) that also collectively form a single logical database. In this session we will discuss our experience of using Oracle sharding for the business including: what type of application best fit to Oracle sharding, configuring sharded database with HA replication for massive scalability and complete fault isolation and some lessons learned. We will also discuss some new sharding features in Oracle 21c such as sharding with database in Persistent memory. Furthermore we will discuss our experience with Oracle sharding in Oracle Cloud Infrastructure including docker base deployment of Oracle Shard database and Oracle sharding database on Kubernetes. The audiences will not only learn our experience of using Oracle sharding to achieve massive scalability and complete fault isolation. They will also learn Oracle sharding in Oracle Cloud Infrastructure such as Oracle sharding in docker and Kubernetes platform

Oracle In-database Machine Learning with OML4SQL/OML4Py in Oracle Autonomous Databases

As next generation enterprise applications are more data driven and more intelligent, advanced analytics and machine Learning bring great business value. Oracle In-Database machine learning moves the algorithms to database where the data is stored. In this session, we will discuss how Oracle In-database machine learning is provided in Oracle Database including Oracle Autonomous Database with scalability, simplicity and high performance. We will discuss how to build, evaluate and deploys machine learning models natively with large enterprise data using Oracle Machine Learning for SQL(OML4SQL) and Oracle Machine Learning for Python (OML4Py). This session will take some use cases as examples to show the process of machine learning: analyze and prepare data set; build and evaluate and apply machine learning model with Oracle Autonomous Databases environment. Some Oracle 21c new features such as AutoML will also be discussed.