Oracle 23AI & ADBS in Action

Unlock the power of Oracle Database 23AI and Autonomous Database Serverless (ADB-S) with this comprehensive guide to the latest innovations in performance, security, automation, and AI-driven optimization. As enterprises embrace intelligent and autonomous data platforms, understanding these capabilities is essential for data architects, developers, and DBAs.

Explore cutting-edge features such as vector data types and AI-powered vector search, revolutionizing data retrieval in modern AI applications. Learn how schema privileges and the DBDEVELOPERROLE simplify access control in multi-tenant environments. Dive into advanced auditing, SQL Firewall, and data integrity constraints to strengthen security and compliance.

Discover AI-driven advancements like machine learning-based query execution, customer retention prediction, and AI-powered query tuning. Additional chapters cover innovations in JSON, XML, JSON-Relational Duality Views, new indexing techniques, SQL property graphs, materialized views, partitioning, lock-free transactions, JavaScript stored procedures, blockchain tables, and automated bigfile tablespace shrinking.

What sets this book apart is its practical focuseach chapter includes real-world case studies and executable scripts, enabling professionals to implement these features effectively in enterprise environments. Whether you're optimizing performance or aligning IT with business goals, this guide is your key to building scalable, secure, and AI-powered solutions with Oracle 23AI and ADB-S.

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 DBDEVELOPERROLE

• Model and query complex data using JSON-Relational Duality Views and SQL property graphs
  Who this Book is For

  Database architects, data engineers, Oracle developers, and IT professionals seeking to leverage Oracle 23AI's latest features for real-world applications

  Real-world insights into Oracle 23AI and ADB-S with hands-on examples and case studies Ready-to-use scripts to implement advanced features in enterprise environments Covers AI/ML-driven performance optimization, automation, and query tuning for next-gen data platforms

  Autorentext

Asim Chowdhury is a distinguished authority in Oracle database technologies, with nearly two decades of proven excellence in Oracle Database Management, Exadata, and Oracle Cloud at Customer (OCC). Renowned for his deep technical expertise and strategic acumen, Asim has successfully led high-performing teams and delivered transformative solutions for global or­ganizations including Fidelity, NASA, HP, and Citibank.

A Senior Principal Consultant at Oracle India, Asim is also a celebrated thought leader and the acclaimed author of five widely respected technical books, including Oracle SQL & PL/SQL Golden Diary, Oracle Performance Tuning Advice, and Oracle 12c New Features for SQL, PL/SQL & Administration. His writings blend deep internals with practical application, earning recognition from both industry veterans and enterprise architects.

Klappentext

"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 featuresdesigned 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 DBDEVELOPERROLE 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 learningbased 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 shrinkingall 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 DBDEVELOPERROLE

• Model and query complex data using JSON-Relational Duality Views and SQL property graphs

  Inhalt

1.Introduction to Oracle Database 23AI and ADB-S: AI-Driven Innovations & Use Cases.- 2. Performance Optimizations & Concurrency Control.- 3. JSON & XML Enhancements.- 4. AI & Machine Learning in ADB-S.- 5. Cloud and Blockchain Innovations.- 6. Vector Data & AI Innovations.- 7. SQL, PLSQL Enhancements & New Functions.- 8. Database Annotations & Auditing Enhancements.- 9. Security, Data Masking & Privilege Management.- 10. Advanced Data Processing & Integrity Features.- 11. Partitioning & Storage Optimization.- 12. Developer Enhancements & Troubleshooting.- 13.- High-Speed Data Ingestion & in-memory Processing.