Dev Track

We are entering a new era in database with the introduction of the first ever Autonomous Database Cloud. Oracle Database has also switching to a new annual release model to support this new era. But what does this mean to you and how will it change how you interact with the Oracle Database? This session provides a clear understanding of how our unique Autonomous Database Cloud works and illustrates how it will impact both DBAs and developers. It also provides a unique opportunity to get ahead of the curve and learn what’s new in Oracle Database 20c directly from the Oracle Database development team.

When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time and resources, but more importantly the same also applies to restores. RMAN has always provided a solution as incrementally updated image copies, but they are much less manageable than backupsets. This presentation goes into detail on how to successfully implement incremental-forever database backup strategy together with a capable storage system like Netapp or ZFS Storage Appliance, and on how to build more advanced features on top that platform, like automation and cloning. Prerequisites: Attendees should be familiar with RMAN and have an overview how backup and recovery works in Oracle. In addition attendees should have... Read More

The plan for a SQL statement can seem complicated and hard to understand. Determining if the plan you are got is the best plan can be a daunting task. This session examines the different aspects of a plan, and explains what info you should be gleaming from the plan and how it affects the execution.

Everybody is talking about machine learning. What is it all about and how can I use it? In this presentation we will see some examples of solving real life use cases with machine learning. We will define Tasks and see how those tasks can be addressed using machine learning.

A converged database, such as Oracle Database, is a smart choice for your enterprise data platform since it greatly simplifies application development, security and administration. However there are still cases in which carefully chosen specialized databases can help to complement a converged architecture for specific uses. In this session we will discuss two specialized databases: Oracle TimesTen In-Memory database for ultra-low response times for extreme OLTP, and Oracle NoSQL database for the ultimate in globally scalable key value processing. Both of these databases can be used to augment a converged architecture with their unique capabilities and deep integration with Oracle Database.

What is deep learning? Where can it be used and how does it work? What are convolutional neural networks and how do they work? In this presentation we will get answers to these questions and many more.

Another year goes by, and most likely, another data access framework has been invented. It will claim to be the fastest, smartest way to talk to the database, and just like all those that came before it, it will not be. Because the best database access tool has been there for more than 30 years now, and that is PL/SQL. Although we all sometimes fall prey to the mindset of “Oh look, a shiny new tool, we should start using it,” the performance and simplicity of PL/SQL remains unmatched. This session looks at the failings of other data access languages, why even a cursory knowledge of PL/SQL will make you a better developer, and how to get the most out... Read More

This session will focus on basics of what Machine Learning is , different types of Machine Learning and Neural Networks , supervised and unsupervised machine learning , autoML for training models and this ends with an example of how to predict workloads using Average Active sessions and different algorithms as an example and also how to predict maintenance windows for your databases. We will also use different open source frameworks as well as some of the tools in the Autonomous Database cloud to do this. If you are a DBA and want to learn something about machine learning and use the tools to perform your tasks more efficiently and automatically

Oracle APEX, the low code application framework included with Oracle Database, has quietly grown into a mature, modern and robust application development and deployment platform loved by hundreds of thousands of developers around the globe. Using a minimal amount of code, developers are able to quickly build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Best of all, APEX is included for free with all versions of Oracle Database, including the free Oracle Database Express Edition (XE) and the Oracle Autonomous Database on the Oracle Cloud Free Tier. Oracle APEX delivers on the promise of low code, and enables organizations to be more agile and solution driven. Oracle APEX appeals to professional developers, line of business... Read More

Discover how Transparent Data Encryption (TDE) protects your critical data by enabling data-at-rest encryption in the database. It protects the privacy of your information, prevents data breaches and helps meet regulatory requirements. TDE enables data-at-rest encryption by encrypting the physical files of the database. Data is encrypted automatically, in real time, prior to writing to storage and decrypted when read from storage. As a result, hackers and malicious users are unable to read sensitive data from tablespace files, database backups or disks.

Autonomous Database is one of the hottest Oracle products where we have attempted to use Machine Learning for several aspects of the service. We take a view on our current state of ML in the Autonomous Database Cloud and how do we process this data in ADW/ATP with zeppelin notebooks to find anomalies in them to troubleshoot them at a scale of several petabytes a year and conduct AIOps. We will cover some sample notebooks to some use cases we will cover are a Log Anomaly timeline which we reduce significant amounts of logs using semi-supervised machine learning techniques to reduce logs and match them in near real time. Some of the other use cases is to use convolution filters... Read More

In this presentation I will introduce MySQL to Oracle Database Administrators. I will show key features and tasks, including database creation, security, data selection and manipulation, backup and recovery. I will give an overview of key MySQL concepts, highlighting MySQL features that will surprise and impress someone familiar with Oracle.

Starting with Oracle Database 12c a new In-Memory column store is available and it is compatible with all existing applications. But how does it work and what steps are required to get started? Rather than answering these questions with a traditional PowerPoint presentation, this session will be conducted via SQL*Plus. Step by step examples will demonstrate how Oracle’s in-memory dual format enables both superfast analytics and online transaction processing. This session will also show how Database In-Memory integrates with Oracle’s existing performance features (i.e. the optimizer, indexes, PQ, etc.). By attending this session, you will arm yourself with the necessary knowledge to not only get started with Database In-Memory but to dramatically improve the performance of your analytic workload.

NDB Cluster 7.x has been focused on Telco and networking applications. With NDB Cluster 8.0 we extend the scope to more application categories such as Key-value stores, financial applications, computer gaming applications and even distributed file systems. We will show a number of benchmarks that shows the limits on database sizes, transaction throughput and query processing capabilities. These benchmarks are all executed in the Oracle Cloud Infrastructure.

At Wix Engineering, we are using JSON in blobs Data Type as far back as MySQL 5.5. In this talk, we will share both our wins and losses, our successes and our challenges, when it came to migrating our blob JSON data to JSON data types, and how we use the new data type to improve search time and reduce IO cost.

MySQL shell is the MySQL client of the future. It will help you in your daily operations, whatever they are. It doesn’t matter if you are a developer or an administrator, if you want to work with relational or non relational data, if you want to setup or monitor your cluster, if you want to work with SQL language or javascript or python.