How Oracle 23c’s Converged Database Simplifies Multi‑Model Development

Converged Database Concept

Oracle introduced the idea of a converged database at Oracle OpenWorld 2019, aiming to combine relational, document, and graph data models in a single engine. Prior to this, applications that needed multiple models had to integrate separate systems such as Oracle Database, MongoDB, Neo4j, and data lakes, which increased architectural complexity, development effort, and operational cost.

New SQL Engine Capabilities in Oracle 23c

Oracle 23c extends the SQL engine with several developer‑friendly features that were previously only available in open‑source databases.

SQL macros that can be placed in SELECT, WHERE, and other clauses to encapsulate reusable logic.

A built‑in microservice framework that lets developers expose SQL‑based services without an external application server.

Lock‑free reservations that avoid session blocking when many concurrent sessions update numeric counters.

Enhanced immutable‑table syntax:

NO DROP [UNTIL number DAYS IDLE]
NO DELETE { [LOCKED] | (UNTIL number DAYS AFTER INSERT [LOCKED]) }

which declaratively protects critical tables from accidental drops or deletes.

An integrated SQL firewall that provides database‑level protection without requiring third‑party plugins.

Data‑Driven Application Simplification

With a converged database, complex spatial queries can be expressed in a single SQL statement. For example, a query can locate all theaters within a five‑kilometer radius of a user that are showing a specific movie, eliminating the need for heavyweight integration frameworks.

Built‑In Microservice Framework

The framework allows developers who know SQL to create backend services quickly. After defining a JSON relational duality view, the service becomes callable directly from front‑end applications. Registration is performed with a simple DDL statement, and the generated endpoint can be invoked via HTTP or REST‑like calls.

High‑Concurrency and Data‑Protection Features

Lock‑free reservations work by automatically creating a system trigger that logs each incremental update to a numeric column. The trigger does not acquire row‑level locks; instead, at commit time the logged deltas are applied atomically, preventing blocking in high‑concurrency environments.

Immutable table enhancements use the NO DROP and NO DELETE clauses to enforce declarative protection. Example syntax:

CREATE TABLE critical_data (
    id NUMBER PRIMARY KEY,
    value NUMBER
) NO DROP UNTIL 30 DAYS IDLE
  NO DELETE (UNTIL 60 DAYS AFTER INSERT LOCKED);

Integrated SQL Firewall

Oracle embeds a SQL firewall directly in the database engine. The firewall inspects incoming statements, enforces policy rules, and blocks malicious patterns without requiring external appliances or plug‑ins, reinforcing the all‑in‑one nature of the converged database.

Industry Trend and Outlook

Oracle 23c’s adoption of features such as SQL macros, lock‑free mechanisms, and built‑in microservice support reflects a broader industry movement toward database convergence, simplification of application stacks, and purpose‑built solutions for specific workloads.