RelationalDBDesignRelationalDBDesign 


Web Applications   «Prev  Next»
Lesson 1

Tuning Oracle for Web applications

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:

Ever since Oracle release 7.3, we see the ability to interface Oracle databases with Web applications. It's 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're using the Web as their front end. In this module we're 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
  1. Describe how Web applications connect to an Oracle database
  2. Describe the function of the Oracle Web Architecture
  3. Use the Oracle Web Request Broker
  4. Describe how Oracle manages incoming Web requests
  5. Design Web applications for high performance
  6. Show locking problems with Web applications
  7. Describe and implement alternative concurrency mechanisms for Web applications
The next lesson is an overview of Web application connection mechanisms.