Lesson 1

Tuning Oracle for Web Applications

Oracle WebDB wasn't directly deprecated with the launch of the Oracle Cloud Suite starting from Oracle 12c. However, it's a more nuanced situation. Here's a breakdown:

Oracle WebDB: This was a lightweight web application development platform included with Oracle Database versions before 12c. It allowed developers to build simple web applications with limited functionality.
Oracle Cloud Suite: Launched with Oracle 12c, the Oracle Cloud Suite offered a broader range of cloud-based services, including Database as a Service (DBaaS) options. These cloud-based database offerings provided a more scalable and managed solution compared to the on-premises Oracle Database with WebDB.

What Happened to WebDB?
While WebDB wasn't officially deprecated, it gradually became less relevant due to several factors:

Shift to Cloud: The focus on cloud-based solutions like Oracle Database Cloud Service (now Oracle Database Service in Oracle Cloud Infrastructure) offered a more robust and scalable environment for web application development.
Limited Functionality: WebDB's capabilities were more suited for simple web applications. As web development needs evolved, developers required more advanced features and frameworks.
Focus on Developer Tools: Oracle prioritized development tools and frameworks like Oracle Application Development Framework (ADF) and Oracle Jet for building modern web applications.

In essence, Oracle WebDB wasn't formally deprecated, but it became overshadowed by the advancements in cloud-based database offerings and more powerful development tools.** Developers seeking to build modern web applications typically look beyond WebDB for their projects.

Oracle Databases on the Web

One of the most exciting new developments of the 1990s was the capability to access an Oracle database through a Web-based front-end. Today, large Web sites such as e-Bay support hundreds of Oracle transactions a minute via Web-based interfaces. This module will explore the techniques for using an Oracle database on the Web and look at some of the most important issues surrounding the use of Web pages to access Oracle databases. When you have completed this module, you will be able to:

History of Oracle Web

Ever since Oracle release 7.3, the ability to interface Oracle databases with Web applications has existed. It is very important to remember as we go through this module that the only difference between a Web-based application and a standard SQL*Forms application is that we are using the Internet as the front end. We always need to bear in mind that Oracle applications are essentially no different simply because they are using the Web as their front end. In this module we are going to be taking look at new features that can be used with Oracle Web server products, and techniques that the DBA can use to ensure that they get the best performance and response time, when using the Internet as a front-end for their Oracle databases

Describe how Web applications connect to an Oracle database
Describe the function of the Oracle Web Architecture
Use the Oracle Web Request Broker
Describe how Oracle manages incoming Web requests
Design Web applications for high performance
Show locking problems with Web applications
Describe and implement alternative concurrency mechanisms for Web applications

What is Oracle WebDB?

Oracle WebDB is a complete solution for building, deploying, and proactively monitoring web database applications and content-driven web sites. WebDB provides a fast and easy way to "web-enable" Oracle databases.

Manage database objects: Developers can create, view, and edit database objects through the easy-to-use, HTML-based WebDB interface. These objects include tables, views, procedures, functions, packages, indexes, sequences, synonyms, and triggers.
Develop HTML components: WebDB provides tools for creating HTML-based interfaces to database data. These interfaces include reports, forms, charts, calendars, menus, hierarchies, and frame drivers.
Build content-driven web sites: Web sites created with WebDB (WebDB sites) are divided into manageable areas that can be delegated to individuals or groups. The tools for managing WebDB sites are provided within the site itself, enabling content creators to make changes to and ensure the quality of their own areas of the site, instead of relying on the webmaster. The next lesson is an overview of Web application connection mechanisms.

Oracle Enterprise Manager 13c