Internet and Cloud Connectivity in Oracle 23ai

Oracle's connectivity model has evolved dramatically since the early client-server designs of Oracle 9i. Modern releases such as Oracle Database 23ai integrate directly with cloud-native, REST-based, and AI-assisted infrastructures that allow data, multimedia, and web services to interact seamlessly. This lesson examines how Oracle 23ai connects to applications across the internet, focusing on its underlying APIs, architectural patterns, and performance benefits in multi-tier deployments.

Evolution of Internet Connectivity

In Oracle 9i, internet connectivity revolved around the Oracle Internet File System (iFS) and early web service protocols like SOAP and XML. By contrast, Oracle 23ai builds on more than two decades of development, offering lightweight REST endpoints, built-in JSON handling, and cloud scalability designed for both on-premises and hybrid deployments.

• From SOAP to REST: Legacy SOAP-based integration has been replaced by Oracle REST Data Services (ORDS), allowing developers to expose SQL queries and PL/SQL procedures through secure RESTful endpoints.
• JSON-Relational Duality: Oracle 23ai supports native JSON data types, enabling seamless integration between relational and document models for web applications and APIs.
• Autonomous Connectivity: The database can now self-optimize connections using AI-driven network routing and adaptive connection pooling to reduce latency in distributed environments.
• Advanced Network Encryption: TLS 1.3, Perfect Forward Secrecy (PFS), and certificate-based authentication ensure secure client–server communication across public and private networks.

Integrating Multimedia and Internet Applications

Oracle 23ai supports modern data types far beyond text and numbers, allowing images, video, audio, and document metadata to coexist in the same schema. The integration of multimedia follows the same architectural principles as traditional data:

• Secure Large Object (LOB) Storage: Encrypted storage for multimedia files using SecureFiles.
• Oracle Multimedia (Deprecated) → Cloud APIs: While Oracle Multimedia has been retired, its functionality now exists through DBMS_CLOUD and ORDS endpoints that connect directly to Oracle Cloud Object Storage.
• JSON and REST APIs: Multimedia metadata can be retrieved or updated using REST endpoints, making integration with mobile and web front-ends faster and lighter.

Client and Server Communication in Modern Oracle

Traditional client-server communication remains a foundation of Oracle’s design, but the APIs have evolved. Java Database Connectivity (JDBC) continues to be a core interface, allowing applications written in Java, Kotlin, or Scala to connect to Oracle databases using SQL and PL/SQL calls.

// Basic JDBC example in Java SE 22
Connection conn = DriverManager.getConnection(
  "jdbc:oracle:thin:@db23ai_high?TNS_ADMIN=/wallet_path",
  "admin", "password");

PreparedStatement stmt = conn.prepareStatement(
  "SELECT product_name, price FROM products WHERE price > ?");
stmt.setDouble(1, 1000.00);
ResultSet rs = stmt.executeQuery();

The example above uses the oracle:thin driver, the standard for both cloud and on-premises access. In Oracle 23ai, connection pooling is automatically managed by the database when using Autonomous Transaction Processing (ATP) or Autonomous JSON Database.

Two-Tier vs. Three-Tier Architecture

Oracle environments can operate in either two-tier or three-tier configurations. Understanding their differences is essential when designing modern, internet-connected systems.

Two-Tier Architecture

In a two-tier setup, the client connects directly to the database server through Oracle Net Services. This model is simple but limited in scalability, as each client session maintains its own connection to the database. It remains suitable for internal administrative tools and small enterprise applications.

Three-Tier Architecture

The three-tier architecture separates application logic from the client and database. Clients (such as web browsers or mobile apps) interact with an application server—running technologies such as Java EE, Spring Boot, or Node.js—that communicates with Oracle through JDBC or ORDS.

This separation provides:

• Load Balancing: Middleware can pool and reuse connections, improving performance for high-traffic applications.
• Security Control: Application servers handle authentication, authorization, and encryption before data reaches the database.
• Platform Flexibility: Different communication protocols (HTTP/HTTPS, WebSocket, gRPC) can coexist with Oracle’s internal SQL*Net and REST services.

Oracle Cloud and Network Connectivity

Oracle 23ai is engineered for cloud-first deployment. Within Oracle Cloud Infrastructure (OCI), databases are deployed into Virtual Cloud Networks (VCNs) that define secure subnets, gateways, and routing rules. Network performance is optimized through Oracle’s internal backbone, while private endpoints restrict access to trusted applications only.

Connectivity options include:

• Private Endpoints: Direct connections within OCI, isolated from the public internet.
• FastConnect or VPN: Secure, low-latency connectivity from on-premises networks.
• Oracle Connection Manager (CMAN): Acts as a connection concentrator and firewall proxy, optimizing multi-tenant and hybrid deployments.

Module Objectives

By the end of this module, you will be able to:

1. Describe how Oracle 23ai integrates REST, JDBC, and JSON technologies.
2. Explain differences between two-tier and three-tier architectures.
3. Configure secure network connections for cloud databases.
4. Use Oracle Cloud tools like ORDS and CMAN for distributed applications.
5. Understand how multimedia and object data integrate with Oracle 23ai APIs.

The next lesson introduces multimedia management in Oracle 23ai and demonstrates how to connect web-based front-end applications to cloud databases securely.