Oracle 23AI & ADBS in Action

"Unlock the power of Oracle Database 23AI and ADB-S — not just a guide, but your roadmap to innovation and transformative thinking. Turn data into insight, and ideas into action."
— Greg Pavlik, Executive Vice President, Oracle

Oracle Database 23AI and Autonomous Database Serverless (ADB-S) represent a major leap forward in intelligent data management. This book offers a comprehensive look at the most impactful new features—designed to enhance performance, security, automation, and AI-driven optimization across enterprise environments.

Learn how Oracle’s support for vector data types and AI-powered vector search transforms data retrieval in modern AI workloads. Understand how schema privilege enhancements and the DB_DEVELOPER_ROLE simplify access control in multi-tenant environments. Explore advanced auditing, SQL Firewall, and data integrity constraints that strengthen compliance and governance.

The book also covers machine learning–based query execution, predictive analytics, and AI-driven query tuning, along with innovations in JSON and XML, JSON-Relational Duality Views, new indexing techniques, SQL property graphs, materialized views, and partitioning. You'll also discover support for lock-free transactions, JavaScript stored procedures, blockchain tables, and automated bigfile tablespace shrinking—all designed to support scalable, high-performance architectures.

What sets this book apart is its strategic, hands-on approach. Each chapter includes industry-relevant case studies and executable scripts, showing how Oracle 23AI and ADB-S can be applied to solve real-world challenges in finance, healthcare, retail, and beyond. Whether you're optimizing workloads, securing data environments, or aligning IT with business goals, this guide equips you to lead in the age of autonomous, AI-powered databases.

What You Will Learn

• Explore Oracle 23AI's latest features through real-world use cases
• Implement AI/ML-driven optimizations for smarter, autonomous database performance
• Gain hands-on experience with executable scripts and practical coding examples
• Strengthen security and compliance using advanced auditing, SQL Firewall, and blockchain tables
• Master high-performance techniques for query tuning, in-memory processing, and scalability
• Revolutionize data access with AI-powered vector search in modern AI workloads
• Simplify user access in multi-tenant environments using schema privileges and DB_DEVELOPER_ROLE
• Model and query complex data using JSON-Relational Duality Views and SQL property graphs