1. Oracle New Zealand
  2. Database

Database Features

Learn more about all of Oracle's database technologies

Key features

Artificial Intelligence and machine learning

Bring AI to your data with AI Vector Search

Use large language models (LLMs) to search your private business data. Perform similarity search with ease and use retrieval-augmented generation (RAG) techniques to achieve more accurate and contextually relevant results—all without having to manage and integrate multiple databases.

AI Vector Search 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. These new capabilities support retrieval-augmented generation (RAG), a breakthrough generative AI technique that combines LLMs with private business data to deliver responses to natural language questions. RAG enables you to receive more-accurate responses to LLM queries, without having to expose private data by including it in LLM training data.

Explore AI Vector Search

Faster, better data-driven decisions

Oracle Database accelerates machine learning (ML) with powerful algorithms that run inside the database so customers can build and run ML models without having to move or reformat data. Data scientists leverage Python, R, SQL, and other tools to integrate ML capabilities into database applications and deliver analytics results in easy-to-use dashboards.

Explore machine learning technologies

Analytics and data warehousing

Data warehousing on-premises or in the cloud

Advanced data warehousing and analytics technologies, such as Oracle Database In-Memory and Oracle Multitenant, enable analytics teams to complete more in-depth analyses of scalable data warehouses in less time. Customers develop deeper, data-driven insights using Oracle Database technologies on-premises or in Oracle Cloud Infrastructure.

Explore data warehousing technologies

Explore Oracle Analytics Cloud


Features include:

Use simple SQL to query property graphs

Build graph analytics and applications with SQL using existing SQL development tools and frameworks. Oracle Database 23ai is the first commercial database to implement the new SQL:2023 standard, making it simple for anyone with SQL knowledge to define and query property graph models.

Explore the operational property graphs (PDF)

Application development

Comprehensive, scalable app development

Developers can quickly create scalable, high performance applications using SQL, JSON, XML, and a range of procedural languages. Oracle Database 23ai offers a range of built-in development tools, such as APEX, and converged database capabilities.

Explore application development technologies


Features include:

Extreme flexibility for developers

JSON Relational Duality is a transformative data modeling capability in Oracle Database 23ai that solves the age-old problem of object-relational mismatch. JSON Relational Duality combines the simplicity of the JSON document model with power of the relational model.

Explore JSON Relational Duality

Data sovereignty and data residency

Addressing data sovereignty and residency challenges

Store data in the cloud across multiple physical databases in multiple locations instead of one database while exposing a single database image to applications. Oracle Globally Distributed Database is used to achieve hyperscale and to help fulfill data residency and data sovereignty requirements. RAFT replication between the physical databases enables automatic failover with zero data loss in single-digit seconds, simplifying the creation and administration of fault-tolerant distributed databases and eliminating the need for manual processes to maintain active-active availability.

Explore Oracle Globally Distributed Database

Database manageability

Integrated, enterprise-wide Oracle Database management

Increase enterprise-wide database performance and availability with consistent management processes via a single-pane-of-glass management dashboard. DBAs reduce their workloads by consolidating the monitoring and management of databases running on premises, in Oracle Cloud Infrastructure, and in third-party clouds with Oracle database management solutions.

Explore Oracle Enterprise Manager


Database security

Protect crucial data

Oracle’s database security solutions reduce the risk of data breaches and make it easier for customers to meet compliance requirements. Encryption, data masking, privileged user access controls, activity monitoring, and auditing enable IT teams to strongly secure Oracle Database environments and understand potential vulnerabilities.

Explore database security technologies


Features include:

Database cloud services

Agile, flexible, and secure database management

Oracle Cloud Infrastructure’s suite of optimized database capabilities enable customers to operate efficiently and at low cost, by closely aligning resources to their specific needs.

Companies implement digital transformations with Oracle’s full portfolio of database cloud services, including the fully managed Autonomous Database and the automated Exadata Database Service, with Exadata Cloud@Customer in distributed data centers and in Microsoft Azure using deeply integrated Oracle Database services in OCI that are colocated in Azure data centers.

Explore Oracle Database Cloud technologies


Features include:

High availability

Comprehensive, high availability capabilities

Oracle Database includes built-in capabilities and options, including Oracle Active Data Guard and Oracle Real Application Clusters, that enable efficient, scaling and consolidation of customer databases. IT teams use the same capabilities on-premises and in Oracle Cloud Infrastructure to protect crucial customer databases and maximize their availability.

Explore high-availability technologies

Explore Oracle Maximum Availability Architecture


Features include:

Performance and scalability

Optimized database performance throughout the enterprise

Meet stringent performance requirements in real-time environments and data center deployments, with a range of capabilities designed for optimized low-latency and high-throughput.