Bringing AI to the database: Introducing Oracle Database 23ai

oracle-23ai-database

Share Post:

Author: Philip Godfrey

What is Oracle Database 23ai?

Oracle Database 23ai is the next generation of database, and brand-new release from Oracle.

Originally planned as 23c, the notable amendment in the naming (23ai) is a nod to its Artificial Intelligence (AI) capabilities.

This blog aims to highlight just some of the 300+ features that will be available, to help not only database administrators with functional tasks, but as an enabler of AI within Development Teams and users of the database.

What are some key features¹ of AI within Oracle Database 23ai?

 

Natural
Language

Integration with LLMs such as Cohere and Llama allow you to ask questions of the database using natural language.

 

AI Vector Search

Creating Generative AI pipelines directly within the database, using your business data.

 

JSON Relational Duality
View

Unifying the benefits of relational and document data models within a single database.

 

JSON relational Duality

Natural Language

To enhance user accessibility, Oracle 23ai utilizes LLMs such as Cohere and Llama to provide functionality to ask complex questions in natural language to the Oracle Database.³

This integration allows users to simply ask questions in a conversational manner, currently utilized in Oracle Analytics Cloud, such as:

  • “Show me the last 4 quarters’ sales of products that are popular with the younger generation.”

 

The LLM will then interpret the question, and provide relevant data through SQL queries, ensuring seamless communication and understanding between the user and the database.

Utilizing Select AI⁴ to generate SQL queries directly from natural language:

AI Vector Search

AI Vector Search enables unstructured data (such as documents, videos, and images) to be quickly searched, using a new data representation called vectors.
Users can now combine business data and vectors to answer user queries without moving or synchronizing data or managing multiple products.
The key advantage of having AI Vector Search built into the Oracle Database is that every mission-critical feature of Oracle Database works transparently with AI vectors.
You automatically get all the industrial-strength scalability, consistency, availability, security, and performance you have come to rely on with Oracle Database. Because of this, you can safely use AI Vector Search in the same customer-facing applications that you use Oracle Database for today.

JSON Relational Duality View

JSON Relational Duality View will simplify application development, as developers now have the flexibility of models. The two models, now combined as a View are:

  • Relational model -> data stored as rows, providing data consistency & storage efficiency.
  • JSON document model -> hierarchical data format, accessed as JSON documents.

This view makes application development easier and can be applied to multiple use-cases from a single database.

Interested to know more?

We’d be more than happy to discuss your requirements or questions, please get in touch here.

[1] https://blogs.oracle.com/database/post/key-benefits-of-json-relational-duality-experience-it-today-using-oracle-database-23c-free-developer-release

[2] https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/introduction.html#GUID-about141

[3] https://blogs.oracle.com/database/post/oracle-23ai-now-generally-available

[4] https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/sql-generation-ai-autonomous.html#GUID-8BEF8CA8-D98D-41FB-A819-6C2F862099DC

[5] https://www.linkedin.com/pulse/oracle-database-23ai-brings-power-ai-business-data-juan-loaiza-zq5rc/?trackingId=Dwtg4Cm6SZCNFTNob2kHLw%3D%3D

Contact us today to arrange an assessment or email:

Picture of Philip Godfrey

Philip Godfrey

Principal Data Analytics & AI Consultant at Vertice

Get in touch

Contact us today to learn more about what Vertice can do for you.

Cookies & Privacy

Vertice collects and stores your information to better customise your site experience and to optimise our website. However, your consent is required. Privacy Policy