Your host during morning is:
Better Designed Than Sorry – Let’s Design Our DB Schema
speaker: Liron Amitzi
Schema design is an important part of any application design. It can affect performance, the development process and even your SQL queries. Thinking about design in advance is very important as design is not something we can easily change down the road. Yet, sometimes we get fixated on a specific design without thoroughly considering other, potentially better, options.
In this session I hope to challenge your design mindset by discussing a few design challenges and a few ways to solve them. What are the implications of each solution? Which way is the best? Is there even a “best” way to solve these cases?
AutoML heralding a new era of Machine Learning
speaker: Sandesh Rao
We are entering a new era in the database with the introduction of the Oracle Autonomous Database. AI and Machine Learning are center stage to most projects and assist in making complex decisions which were not possible before. Most data science projects don’t get beyond the data scientist and rarely operationalize their predictive models. There is new toolsets and methods available every day, which make this an incredibly dynamic space. There are different categories of users who want to use the algorithms, the toolsets but don’t know where to start. Also a lot of stuff is now present in AutoML where users do not need to be ML experts to use this. Whether you are a data scientist who wants to play with data and build your models or make use of the database features with the built-in models or use the specific AI services within a specific vertical such as Insurance or Healthcare. We will take a glimpse at Oracle’s Machine Learning Zeppelin-based notebooks for Oracle Autonomous Data Warehouse Cloud to how Oracle uses AIOps and Applied Machine learning for its operations and the Oracle AI Platform Cloud Service to provide an all-rounded view of what Oracle is up to in this space.
Why PL/SQL is still the best data access language
speaker: Connor McDonald
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 of PL/SQL when it comes to database performance.
8:00am (CEST) (this session will be in Russian language)
Introduction to Oracle Blockchain tables
speaker: Rustam Khodjaev
One of the most exciting technologies on the horizon in recent times is Blockchain. However, despite the fact that blockchain is discussed everywhere, there are still many questions around this technology. In this session will be explained Blockchain tables architecture in Oracle Database. Also will be described how to use and implement Oracle Blockchain tables in your projects to protect your data. In the end of presentation will be Live Demo of creating, using and showing features of Oracle Blockchain tables on Oracle Autonomous Database.
Your host during afternoon is:
The Superpowers of the Oracle Database
speaker: Philipp Salvisberg
PL/SQL combines static SQL with a procedural language. This makes processing within the database easy. But why inside the database? No unnecessary data transports. Consistent data. Optimal use of resources. Good response times. That’s why.
However, the real superpowers of the Oracle database are its features. In this talk, I will connect a superpower of each founding member of the Justice League to an Oracle database feature. With live demos and links to more information to get you started. Some covered features are:
– Advanced Queuing
– Flashback Data Archive
– Virtual Private Database
– Oracle Spatial
– Oracle Text
At the end of the talk, I will cover the benefits of file-based development and show how you can use testing tools and static code analysis tools to achieve and maintain good code quality.
Do you provide solutions based on the Oracle database? Then you must not miss this presentation. You will for sure learn something new, regardless of your level of experience.
Oracle Database 21c is out – and there are a lot of new things regarding database upgrades and migrations. This includes certainly the migration to Oracle Multitenant but also a new default technique to upgrade PDBs. And much much more.
We will cover it all and give you technical insights into the new 21c upgrade and migration features: The good, the bad – and some really cool ones.
This will be a technical talk free of any marketing or advertising. But we will include as many demos as possible to really demonstrate new features.
What a DBA should know about the Oracle REST API
speaker: Julian Frey
With the release 19.2 of Oracle REST Data Services Oracle introduced functionalities for DBAs to operate a database via a REST API. The main focus of this presentation is on the architecture and what a DBA needs to know to run this API safely. It enables automation processes to directly communicate with the database without interaction with the server but there are some questions to be answered before we implement ORDS. Who can use this API? How do they authenticate? Where should the Webserver be placed? Is it safe?
Managing DBA Applications With APEX
speakers: Michael J Gangler
Are you in an environment that has more than ten databases with multiple environments and technologies?
If not, you’re lucky. However, this session can help you along with the DBA with many and multiple databases and environments. This presentation will attempt to gap the usage of Oracle’s Free tool—APEX—with normal database operations to organize and gather information from your database and identify performance, backup, and utilization patterns. This won’t replace Oracle’s OEM and AWR warehouse but act as a first step to understand where to look in the OEM or other 3rd party tools.
This application can be used by DBAs or managers who want to understand the database resources that are currently used (total CPU, memory, etc.). Plus, it has multi-tier and department usage and can be set up by any level DBA.
Creating Order in the Database Patching Chaos
speakers: Liron Amitzi
Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install? What are the risks? Is there anything I should do after the patch? This becomes even more stressful in a complex environment: How to install patches on RAC? What about standby databases?
This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.