Dear All,
In this post i am sharing oracle 23ai database related information .
Oracle 23ai Database Introduction:
====== ============ ========
=========== ==============
Oracle 23ai is available cloud-first, i.e. in
Ø
Oracle Exadata Cloud@Customer,
Ø
OCI Exadata Database Service and OCI Base
Database Service and in Oracle Database@Azure.
For More updated information follow this metalink id (Doc ID
742060.1)
Ø
Autonomous Database Always Free available in
Oracle Cloud Infrastructure (OCI)
Ø
Autonomous Database Container Image available as
a downloadable image
Ø
Oracle Database 23ai Free packaged for
ease-of-use and available via download as a Container Image, VirtualBox VM, or
Linux RPM installation file. Use the following Get-Started link to download your
preferred packaged database software: Oracle Database Free Get Started
Ø
Security , performance , Availability and scalability
Oracle 23ai DB >>
the Autonomous Intelligent concept by automating many traditional database
management tasks using AI (Artificial intelligence) and ML (Machine
Learning)
Ø
Oracle Autonomous Database, which embodies the
vision of a self-driving, self-securing, and self-repairing database.
Ø
Oracle Database 23c ( Renamed to 23ai) brings
cutting-edge features to make the database more intelligent and capable of
autonomous operation when paired with Oracle's cloud infrastructure.
Ø
The autonomous database uses machine learning to
automatically upgrade, patch and tune itself while running.
Ø
Security updates are automated with no downtime
required.
Ø
Machine learning is used to make sure the
database consumes less compute and storage thanks to automatic compression of
data.
Ø
The result is a faster, more reliable and
cheaper database than the traditional database
AI is much better at eliminating complexity, human error and ensuring security than we humans .
The Difference between Oracle Database 23c
announced last year and Oracle Database 23ai?
Ø Given the importance of the
breakthrough AI technology in this release, Oracle renamed Database 23c as
Database 23ai. Oracle Database 23ai is the version 23.4.0.0.0 and will be
referred to as such moving forward
Ø
Oracle provides upgrade paths from either Oracle
Database 19c or Oracle Database 21c to 23ai. All other versions of the database
need to upgrade to one of the versions listed prior, and then to 23ai.
What is Automation database ?
Oracle database below functionality’s are Automated
Ø
Automated provisioning, scaling, and patching.
Ø
Automatic backup and recovery operations.
Ø
Automated index creation and performance tuning
In Oracle.
What is Intelligence In Oracle database
23ai ?
Ø
AI-powered query optimization.
Ø
Self-repairing capabilities to minimize
downtime.
Ø
Proactive detection of anomalies using built-in
AI models.
Oracle 23ai Autonomous Features:
Ø
Autonomous Data Warehouse (ADW): Optimized for
analytics.
Ø
Autonomous Transaction Processing (ATP):
Tailored for OLTP workloads.
Ø
Autonomous JSON Database: Designed for
NoSQL-style JSON document storage and processing.
Oracle Database 23ai Intelligent
Features:
Oracle Database 23ai enhances its intelligent features with:
Ø
AI/ML Integration: Built-in AutoML, SQL-based
machine learning, and direct support for developing and deploying ML models.
Ø
Adaptive Query Plans: Queries are adjusted in
real-time based on changing data patterns or resource availability.
Ø
Proactive Monitoring: Intelligent diagnostics
and performance tuning using Oracle AI capabilities.
Ø
AI-Driven Insights: Integration with OCI AI
services for predictive analytics and NLP.
Oracle 23ai DB Key Features:
================= =========== ==============
Oracle Database 23ai brings more than 300 new features
compared to the previous generation , such as
Ø
Oracle AI Vector Search,
Ø
True Cache,
Ø
Property Graph,
Ø
JSON relational duality,
Ø
Priority Transactions,
Ø
Data Use Case Domains,
Ø
increased limits, new data types and many more
features with a focus on simplifying the use of AI with data, accelerating app
development, and running mission-critical workloads.
Ø
AI Vector Search: Combines relational
database processing with similarity search and retrieval augmented generation ,
AI Vector Search is a collection of features that includes a new vector data
type, vector indexes, and vector search SQL operators that enable Oracle
Database to store the semantic content of documents, images, and other
unstructured data as vectors and use these to run fast similarity queries.
>>> AI Vector Search uses
vectors to enable fast and simple queries on business data in conjunction with
LLMs.
>>> A vector is a numerical
representation of text, images, audio, or video that encodes the meaning of the
data, not the underlying words or pixels. For more information about AI
vector search go through this link https://www.oracle.com/database/ai-vector-search/
Ø
Automatic Transaction Rollback: Prevents
transactions from blocking other high-priority transactions
Ø
Logical replication: Supported via Oracle
GoldenGate
Ø
Rolling upgrades: Supported using Active
Data Guard
Ø
Distributed transactions: Supports
transactions that involve blockchain tables
Ø
Partition-based bulk dropping:
Efficiently drops expired rows
Ø
Oracle Globally Distributed Database:
Distributes data geographically and at scale
Ø
Raft protocol: Automatically failsover
within seconds
Ø
Oracle True Cache: Improves app response
times while reducing the load on database servers
Other features of Oracle Database 23ai:
================ ================ ===============
Ø
Dev for data, Secure data encoding, Natural
language processing, Simplifies application development, Speeds up development
cycles, Makes SQL execution safer
What all other products announced with Oracle
Database 23ai?
This announcement
focuses on cloud first, developer first.
OCI:
·
Oracle Database 23ai on Exadata Cloud@Customer with Exadata Systems
Software 24ai
·
Oracle Database 23ai on Exadata Database Service with Exadata Systems
Software 24ai
·
Oracle Database 23ai on Base Database Service
·
OCI GoldenGate 23ai
Azure:
·
Oracle Database 23ai on Exadata Database Service with Exadata Systems
Software 24ai
Developers:
·
Always Free Autonomous Database23ai
·
Autonomous Database 23ai Free Container Image
·
Oracle Database 23ai Free
·
GoldenGate 23ai Free
Why should we upgrade from Oracle Database 19c to
23ai?
Ø Oracle
Database 23ai is the next long-term support release of Oracle Database,
superseding 19c.
Ø A
long-term release of Oracle Database offers five years of premium support and
three years of extended support.
Ø Oracle Database 19c Premier Support ends on
April 30, 2026, and while Oracle waived the additional fees for Extended
Support from May 1, 2024 to April 30, 2026, Extended Support will end on April
30, 2027, giving you a longer support overlap with Oracle Database 23ai. 2032
Free trial available for Oracle Database 23ai?
Ø
Oracle offers free trials for Oracle Database 23ai through
Oracle Cloud Infrastructure (OCI) with Autonomous Database Free Tier.
Ø Users
can sign up for a free trial account and explore the features and capabilities
of Oracle Database 23ai on OCI.
Alternatively, Oracle Database 23ai Free is available for download as a Linux RPM file, an Oracle Linux-based Docker image, Oracle Virtual Box VM, or packed with Vagrant
Thanks,
Srini
