Senior Enterprise Data Architect
Viscosity North America
Artificial Intelligence (AI) and Machine Learning (ML) are a lot like preserving the Earth’s environment: Almost everyone is talking about what should be done to save it, but very few people have committed to actually doing something about it. This session demonstrates a few real-life opportunities to discover unseen patterns and relationships within sample financial and election data by leveraging the AI and ML capabilities already built into Oracle Autonomous Database.
You’re a busy Oracle DBA. Your phone rings. It’s your most troublesome user, once again complaining that her query is running slow. You take a quick look at the execution plan, find a possible choice for a new index to improve its performance, and drop it in place: Problem solved. Or is it? Even an experienced DBA may not immediately realize the impact that new index will have on the performance of dozens of other queries and DML statements. Finally, there’s a better way: Let the database decide. This session will show how Automatic Indexing (AI) – one of the newest features of Oracle Database 19c – provides an intriguing alternative to reactive performance tuning methodologies for index creation. We’ll look at how AIC reacts to a heavy hybrid application workload and then holistically builds, tests, and implements the most appropriate secondary indexes needed to improve database performance.