Oracle Database 23ai: Key Features

A converged database to manage mission-critical workloads effectively with the power of AI and ML. Let’s discover the key features of Oracle Database 23ai.

AI Vector Search:
Develop apps with AI Vector Search in Oracle Database, using vector data types, indexes, and SQL to query semantic content from unstructured data, supporting Retrieval Augmented Generation (RAG).
JSON Relational Duality:
Build apps using either relational or JSON paradigms with a single data source, leveraging both models' strengths. Data is stored once but accessed and modified through either approach.
JavaScript Stored Procedures:
Develop high-performance apps by writing JavaScript stored procedures with GraalVM and importing libraries into the database, minimizing round trips by executing business logic directly in the data tier.
JSON Schemas:
Ensures only valid data is entered into the JSON column through industry-standard JSON schemas.

Property Graphs:
Analyze relationships, predict trends, and gain insights with database-native property graph views. Use SQL-standard property graph queries for graph analytics on relational and JSON data.
Data Use Case Domains:
Centralize domain knowledge to describe data use, ensuring consistent handling across applications and bringing domain expertise closer to the data for better management.
Schema Annotations:
Annotate data model attributes for tables, columns, and views, offering a central, lightweight method to register and share usage properties across applications.
Resources:
Provides up to 2 CPUs for foreground processes, 2 GB of RAM, and 12 GB of user data on disk.

Overview

Innovations in Oracle Database 23ai

It offers three key focused areas:

AI for Data

The goal of AI for data is to help:

App Developers - Easy integration of AI functionality into data-driven applications.
Oracle Database Users - Incorporate GenAI capabilities into their products to enhance productivity.

We can achieve these results by utilizing Artificial Intelligence's power to streamline processes, extract new insights from data, simplify database queries, and swiftly and efficiently perform object similarity searches.

AI for Data: Key Features

Augmenting a new generation of AI models:

Oracle Database 23ai introduces AI Vector Search, which offers the benefits of a new generation of AI models for generating and storing vectors. It gives you the power to combine similarity searches with searches on your business data using simple SQL.

Secure encoding of data

Oracle Database 23ai supports the ONNX standard, allowing you to load your own AI models directly into the database. This ensures secure encoding of objects upon insertion, enabling near real-time inferencing without the need to share sensitive data with third-party services.

Asking questions naturally

While SQL is powerful, it can be challenging for beginners, so Oracle Database 23ai integrates with LLMs like Cohere and Llama to allow natural language queries. By sharing table metadata with the LLM, the system converts user questions into SQL queries, enabling complex data retrieval and facilitating questions about all aspects of the Oracle Database.

Finding new insights in data

Since Oracle Database 9iR2, built-in ML algorithms have enabled direct pattern detection and behavior prediction without complex ETL operations. Enhanced over the years, Oracle Database now offers sophisticated data mining capabilities for tasks like customer recommendations and fraud detection.

Dev for Data

Oracle Database 23ai is designed to make easy application development and eliminate the complexity associated with database interaction. As a result, it helps with faster development cycles, which is necessary in today’s ever-changing digital landscape.

Dev for Data: Key Features

JSON Relational Duality
With this technology, you will get the benefit of the relational and simplicity of JSON development approaches all within a single application. JSON provides an elegant data modeling approach where all of the relevant data needed to answer a query is contained in a single object without the need to perform complex joins across tables. The relational approach offers a flexible, storage-efficient, consistent data model that is easy to query with languages such as SQL.

JSON Relational Duality helps you maximize the benefits of both approaches without the need to use complex and unwieldy Object Relational Mapping frameworks (ORMs).
Simpler SQL Statements
SQL remains a crucial component of data management due to its versatility in querying business data. Oracle Database 23ai enhances it with new features like Boolean and Vector datatypes, Data Usecase Domains, and improved readability in simple SQL statements. These enhancements simplify interactions with the database and enhance functionality.
Property Graphs modeling complex relationships
Oracle Database 23ai embraces new standards that integrate graph capabilities with SQL, simplifying creating property graph views and writing powerful queries, anticipating broader enterprise adoption and enhanced data relationship modeling.

Mission Critical for Data

Oracle Database is popular for its robust data protection and powering critical applications, excelling in features like Oracle Real Applications Clusters (RAC) for all-active, shared disk databases. Oracle Active DataGuard and Oracle GoldenGate offer unmatched flexibility for both homogeneous and heterogeneous data replication architectures.

Mission Critical for Data: Key Features

Shard better, faster, simpler
Oracle Database 23ai provides support for Raft replication, a consensus protocol that helps with the automatic configuration of replication across all shards. During shard failure or reconfiguration, the data is automatically rebalanced. The new Raft protocol ensures business continuity by enabling sub-second failover.

Oracle database 23ai includes many enhancements, including Local Rolling Database Maintenance, support for a new Data Guard Per Pluggable Database (PDB), and improved integration and management of PDBs within Oracle Clusterware.
Simpler caching data
Introducing a new feature called “True Cache,” a diskless Oracle instance that runs in front of the primary database. It uses Active Data Guard technology to ensure automatic updates as data changes in the primary database instance. This new caching technology offers the benefit of simple configuration and minimal code changes.
Safer SQL execution
Oracle Database 23ai introduces SQL Firewall to prevent the execution of unauthorized SQL. It enables the database to be trained on what SQL is permitted to be executed. This results in reduced overhead on SQL execution and an easy-to-train and set-up SQL Firewall.

See The Team In Action

Learn More About Oracle Database

High Availability in Oracle Cloud: A Comprehensive Guide

Ready to Connect?

Please fill the following form, we will get back to you within a business day.

General Contact Form

Schedule an
Appointment Now

Meet with an Astute expert today, we would love to help you think about your enterprise applications, and how the cloud can deliver greater value to your customers.

Oracle Database 23ai: The Power of AI Into Your Database

Simplified app development and mission-critical workloads with the power of Artificial Intelligence.

Feel free to reach out anytime.

Oracle Database 23ai: Key Features

A converged database to manage mission-critical workloads effectively with the power of AI and ML. Let’s discover the key features of Oracle Database 23ai.