Oracle Database 23ai is coming

From 11g to 12c to 19c

Today, we welcome 23ai!

Oracle AI Vector Search allows documents, images, and relational data that are stored in mission-critical databases to be easily searched based on their conceptual content

Generative AI can now be used to ask natural language questions about private data stored in Oracle databases

Oracle Corporation announced its latest Database product: Oracle Database 23ai.

This long-term support release specifically introduces AI vector search and contains more than 300 major features designed to simplify the use of AI in conjunction with data, accelerate application development, and support the operation of mission-critical workloads.

AI vector search allows users to search based on the conceptual content of documents, images, and relational data, rather than relying on specific terms, pixels, or data values, improving search accuracy and relevance. In addition, this feature enables AI algorithms to be run in real time within Oracle databases without moving data to other products, enhancing the effectiveness, efficiency, and security of AI operations.

Oracle Database 23ai is available on multiple platforms, including Oracle Exadata Database Service from Oracle Cloud Infrastructure (OCI), Oracle Exadata Cloud@Customer, Oracle Base Database Service. And Oracle Database@Azure (US, Germany, UK).

New features

New features for Oracle Database 23ai include:

1. AI for Data

   1.1. Oracle AI vector search

   • Vector data type
   • Vector index
   • Support Vector data type in JSON type (OSON)
     1.2. Oracle Exadata System software 24ai
     1.3. OCI GoldenGate 23ai

2. Accelerate application development

   2.1. JSON relational duality
   2.2. Operating Graph in SQL (SQL/PGQ)
   2.3. Free developer database

3. Mission-critical data

   3.1. Oracle Global distributed database and RAFT replication
   3.2. True Cache
   3.3. In-Database SQL Firewall

Speed experience

Oracle Database 23ai container version is available for download, and you can quickly experience it.

[root@rocky9 ~]# podman pull container-registry.oracle.com/database/free:latest
Trying to pull container-registry.oracle.com/database/free:latest...
Getting image source signatures
...
Writing manifest to image destination
7510f8869b041dbd0dc782e7432aeee37cc2fd28eb4496e3b03c4ba3c5c4218e
[root@rocky9 ~]# docker run -d --name ora23ai -h shawnyan \
  -p 1521:1521 \
  container-registry.oracle.com/database/free:latest
13df6ec71c28c7d4a88651a4a6806ee4247c6dc57d557cf7591994f5b70c5a33
[root@rocky9 ~]# podman exec -it ora23ai sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Production on Fri May 3 03:56:26 2024
Version 23.4.0.24.05

Copyright (c) 1982, 2024, Oracle.  All rights reserved.


Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05

SQL> SELECT BANNER_FULL FROM V$VERSION;

BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05

As you can see, this version is based on 23.4.0.24.05。

For more information, please refer to the official documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/index.html

– END. –

如果这篇文章为你带来了灵感或启发，就请帮忙点『赞』or『在看』or『转发』吧，感谢！(๑˃̵ᴗ˂̵)