Oracle 23AI & ADBS in Action: Exploring New Features with Hands-On Case Studies

“Oracle 23AI & ADBS book provides a clear and practical exploration of Oracle’s latest innovations, thoughtfully combining advanced features with real-world, hands-on, and realistic use cases. The book does an excellent job of translating complex capabilities in Oracle 23AI and Autonomous Database into actionable guidance. It is a valuable and timely resource for architects, DBAs, and developers who want to understand not just what’s new, but how to effectively apply these technologies in AI-driven applications in modern enterprise environments.” (Dan Roth, Chief AI Scientist, Oracle AI & Data, Distinguished Professor, University of Pennsylvania)

“Oracle 23ai and ADBS in Action by Asim Chowdhury is a well structured, hands on guide for professionals working with Oracle Database 23ai and Autonomous Database Serverless. The book focuses on practical implementation, explaining AI enabled features, vector search, and serverless scaling through realistic use cases rather than isolated feature descriptions. Technical concepts are presented clearly and with appropriate depth, making it easy to understand how Oracle 23ai behaves in real workloads and production environments. Overall, it serves as a strong companion resource for DBAs, developers, and architects looking to apply Oracle’s latest database capabilities.” (Sandesh Rao, VP Applied AI, Oracle)

“This is a strong practitioner’s guide to Oracle 23AI and ADB-S: step-by-step, implementation-driven, and grounded in realistic scenarios. If you’re building AI-powered applications close to the data—vector similarity search, predictive modeling in-database, or modern JSON/SQL patterns—this book provides a clear path from feature to production-ready approach.” (Egor Pushkin, Chief Architect, Data and AI, Oracle Cloud)

“I’ve been fortunate enough to read a pre-release of the book. This book delivers solid, well-structured coverage across a broad array of Oracle Database 23ai/26ai features. While 23ai is a fast-moving target, which means no single volume can cover absolutely everything, Asim comes very close, striking a good balance between broad coverage of the available features while still going into each with enough depth to explain the feature and get the reader moving forward with it. There is a focus on practical, hands-on examples that you can run yourself, for example on the free edition, making it an excellent resource for applying these new features on your next workplace project.” (Connor McDonald, Architect, Oracle | Database Advocate)

“Oracle 23AI ADBS in Action is a definitive guide to the AI-native database, demonstrating how enterprise data can be transformed into an intelligent, conversational automation fabric. The book shows how Oracle 23AI elevates the data layer into a smart foundation for AI-driven business processes. Building on this core, Oracle Integration seamlessly connects Oracle 23AI with AI agents and automation workflows, enabling secure, event-driven orchestration while maintaining human oversight through approvals, policy enforcement, and auditable decision paths. Through hands-on QuickMart case studies, advanced capabilities—including vector search, JSON duality views, autonomous optimizations, and in-database machine learning—are translated into practical, real-world implementations. The result is an end-to-end, actionable blueprint for DBAs, developers, and data scientists to build high-performance, compliant, and truly intelligent data platforms on Oracle 23AI.” (Jürgen Kress, Director, Product Management, Oracle Integration)

“Oracle 23AI & ADBS in Action: Exploring New Features with Hands-On Case Studies provides a clear and practical guide to Oracle Database 23AI and Autonomous Database Shared. The book effectively explains AI-driven automation, performance and concurrency enhancements, vector data innovations, and advanced partitioning strategies through real-world use cases. By combining architectural insights with implementation-focused examples, it helps readers understand how to design, optimize, and operate modern Oracle database platforms. This book is a valuable resource for DBAs, architects, and enterprise technology leaders adopting next-generation Oracle database capabilities.” (Y. V. Ravi Kumar, Oracle Certified Master | Author | Oracle Cloud World Speaker)

“My colleague Asim’s Oracle 23AI & ADBS in Action is an essential read for database professionals eager to learn Oracle 23AI’s latest advancements. I myself, being a performance consultant, found the book adeptly explains performance enhancements and automation in ADBS, supported by practical, real-world case studies. Clear explanations of new features will empower readers to optimize their workloads with confidence.” (Dibya Mondal, Principal Consultant, Performance Engineering, Oracle)

“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