Lesson 1

Since Oracle7.3, Oracle has supported web connectivity to its databases. One of the most transformative developments since the 1990s has been the ability to access Oracle databases through web-based front-ends. Today, high-volume sites and enterprise applications routinely handle thousands of Oracle transactions per minute via modern web interfaces. This module explores techniques for integrating Oracle Database 23ai with web applications, focusing on performance, scalability, security, and concurrency in cloud-native and on-premises environments.

The fundamental principle has not changed since Oracle7.3: a web-based Oracle application is still an Oracle application — the Internet or intranet simply serves as the delivery mechanism. The core differences today lie in architecture, scalability, and developer productivity. Upon completion of this module, you will be able to:

1. Describe how modern web applications connect to an Oracle 23ai database.
2. Explain the Oracle web architecture, including ORDS and APEX.
3. Use Oracle Web Request Broker concepts in a modern architectural context.
4. Describe how Oracle manages incoming web requests.
5. Design high-performance web applications leveraging Oracle 23ai features.
6. Identify and resolve locking problems in web applications.
7. Describe and implement alternative concurrency mechanisms for stateless web workloads.

Oracle has evolved steadily from early CGI-era tools to modern, low-code, REST-first solutions. The progression reflects both the growth of the web as an application platform and the increasing demands placed on database-backed web applications for scalability, security, and developer productivity:

• Oracle7.3 (mid-1990s): First native web connectivity via Oracle Web Server and CGI. The database could service HTTP requests for the first time.
• Oracle 8i / WebDB: Lightweight browser-based database administration and simple web application development. Suited for small-scale web enablement.
• Oracle 9i / Oracle HTTP Server: Apache-based web tier with mod_plsql for PL/SQL web applications. Introduction of Oracle Portal.
• Oracle 10g / 11g: Oracle Application Express (APEX) introduced as the low-code successor to WebDB. Oracle Web Cache for response acceleration.
• Oracle 12c+: Oracle REST Data Services (ORDS) introduced as the primary REST gateway. WebDB effectively obsolete at this point.
• Oracle 23ai: APEX and ORDS are the primary platforms. JSON Relational Duality, AI Vector Search, True Cache, Automatic Indexing, and sessionless transactions for stateless web workload scalability.

Oracle WebDB was an early lightweight platform for web-enabling databases, used primarily in the Oracle 8i and 9i era. It is long obsolete, superseded by two modern platforms that together cover everything WebDB provided — and orders of magnitude more.

Oracle APEX — The Modern Successor

Oracle APEX (Application Express) is the direct modern successor for building web database applications. It is included at no cost with Oracle Database 23ai and enables rapid development of secure, scalable, data-driven web and mobile applications directly on the database using SQL, PL/SQL, and declarative tools. APEX provides:

• Database Object Management: create, edit, and manage tables, views, procedures, packages, indexes, and sequences via a browser-based interface, or use SQL Developer and SQLcl for command-line access.
• Declarative HTML Components: reports, interactive grids, forms, charts, calendars, dashboards, and maps — built without extensive front-end code. Universal Theme delivers responsive, accessible UIs out of the box.
• Enterprise Web Applications: role-based access control, workflows, auditing, and multi-tenancy with centralized governance. Content areas can be delegated to individual users or groups while the DBA retains oversight.
• AI Integration in Oracle 23ai: Vector Search for semantic query capabilities, AI Agents, AI Interactive Reports for natural language querying, and generative development tools for accelerated application construction.

Oracle REST Data Services (ORDS)

ORDS is the gateway for RESTful web services, APEX applications, and modern microservices. It runs as a mid-tier service — standalone, Tomcat, WebLogic, or containerized — and exposes database functionality via HTTP and REST. ORDS complements APEX by providing REST APIs consumable by any language or framework including JavaScript, Python, and Java, and serves as the APEX runtime layer. In Oracle 23ai, ORDS supports sessionless transactions for improved stateless scalability.

Key Advantages of Oracle 23ai Web Architecture

• Runs natively in the database engine for maximum security and minimum latency.
• Scales across Autonomous Database, Exadata, and Oracle Cloud Infrastructure.
• No per-user or per-application licensing — fully included with Oracle Database at no additional cost.
• Oracle 23ai-specific features: JSON Relational Duality for simultaneous relational and document access to the same data; True Cache for mid-tier acceleration without application changes; lock-free reservations for high-concurrency numeric updates; priority transactions for workload tiering; and JavaScript stored procedures for developers who prefer a JavaScript runtime inside the database.

This module covers Oracle web application tuning across nine lessons. The lesson sequence progresses from connection architecture through request handling, tuning techniques, application design, concurrency, and timestamp management:

• Lesson 2 — Oracle Web Applications: the 8-step request flow from browser to Oracle and back, and performance optimization factors at the network, hardware, database, application, and content levels.
• Lesson 3 — Web Request Broker: components of the Oracle Web Request Broker (WRB) and how it routes requests between the web listener and the database.
• Lesson 4 — Web Listener: the role of the web listener in receiving and dispatching HTTP requests to the WRB.
• Lesson 5 — WRB Cartridges: the cartridge architecture that extends WRB functionality for PL/SQL, Java, and other content types.
• Lesson 6 — Web-Based Tuning Tips: DBA-level techniques for maximizing Oracle performance in web-facing deployments.
• Lesson 7 — Designing Web Applications: design principles for high-performance, scalable Oracle-backed web applications.
• Lesson 8 — Web Application Concurrency: how Oracle manages locking in stateless web workloads and the performance implications of HTTP connection patterns.
• Lesson 9 — Alternative Concurrency Mechanisms: optimistic locking, lock-free reservations, and other strategies for reducing contention in high-concurrency web applications.
• Lesson 10 — Date and Timestamp Management: managing date and timestamp data in web applications, including timezone handling and Oracle 23ai timestamp precision improvements.

The next lesson provides a detailed overview of web application connection mechanisms in Oracle 23ai, tracing the complete request lifecycle from the browser through ORDS to the Oracle database and back.