Skip Headers
Oracle® Business Intelligence Discoverer Configuration Guide
10g Release 2 (10.1.2.1) for Microsoft Windows and Solaris Operating System (SPARC)
B13918-03
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

8 Using OracleBI Discoverer Viewer with OracleAS Web Cache

This chapter describes how to use OracleAS Web Cache to enhance OracleBI Discoverer Viewer performance, and contains the following topics:

8.1 About OracleAS Web Cache

OracleAS Web Cache is a content-aware server accelerator, or reverse proxy server, that improves the performance, scalability, and availability of Web sites that run on OracleAS. By storing frequently accessed pages in memory, OracleAS Web Cache eliminates the need to repeatedly process requests for those pages on middle tier servers and databases.

You can also use OracleAS Web Cache to load balance OracleAS machines in a multiple machine installation (for more information, see Chapter 7, "Installing OracleBI Discoverer in a multiple machine environment").

You manage OracleAS Web Cache using the OracleAS Web Cache Administration page.

Figure 8-1 OracleAS Web Cache Administration page

Description of Figure 8-1  follows
Description of "Figure 8-1 OracleAS Web Cache Administration page"

OracleAS Web Cache sits in front of application Web servers, caching their content, and providing that content to Web browsers that request it. When Web browsers access the Web site, they send HTTP protocol or HTTPS protocol requests to OracleAS Web Cache. OracleAS Web Cache, in turn, acts as a virtual server to the application Web servers. If the requested content has changed, OracleAS Web Cache retrieves the new content from the application Web servers.

Figure 8-2 OracleAS Web Cache overview

Description of Figure 8-2  follows
Description of "Figure 8-2 OracleAS Web Cache overview"

For more information about OracleAS Web Cache, see Oracle Application Server Web Cache Administrator's Guide.

Notes

8.2 What are the benefits of OracleAS Web Cache?

Using OracleAS Web Cache:

For more information about the benefits of using OracleAS Web Cache, see Oracle Application Server Web Cache Administration and Deployment Guide.

8.3 How does OracleAS Web Cache work?

OracleAS Web Cache uses cacheability rules to determine which documents to cache. A cacheability rule indicates whether you want the documents specified within a particular URL to be cached or not cached. Cacheability rules are defined using regular expressions (for more information about Oracle's implementation of regular expressions, see Oracle Application Server Web Cache Administration and Deployment Guide).

The document specified within a URL included in a cacheability rule is not actually cached until a browser requests it.

Figure 8-3 The URL and document request process

Description of Figure 8-3  follows
Description of "Figure 8-3 The URL and document request process"


Key to figure:
a. The first time a browser requests a particular URL, OracleAS Web Cache detects that the required document is not in the cache (referred to as a cache miss). OracleAS Web Cache therefore forwards the request to an application Web server, which sends the request to the database.
b. The database returns the data to the application Web server, which forwards a document and its URL to OracleAS Web Cache. If the URL is specified as one of the URLs to cache, OracleAS Web Cache caches the document for subsequent requests.
c. The next time a browser requests the URL, OracleAS Web Cache detects that the document is already in the cache (referred to as a cache hit).
d. OracleAS Web Cache serves the document from the cache to the browser.

8.4 When to use Discoverer Viewer with OracleAS Web Cache

Using Discoverer Viewer with OracleAS Web Cache to improve Web site performance, scalability, and availability will be most appropriate in the following cases:

The OracleAS Web Cache caching rules are automatically pre-configured for Discoverer Viewer during installation.

For security reasons, OracleAS Web Cache only caches Discoverer Viewer pages that are accessed using a public connection.

OracleAS Web Cache is particularly suitable for optimizing Discoverer Viewer performance when controlling access to data is relatively unimportant (e.g. where the same public connections are used by several users to access workbooks). OracleAS Web Cache is less suitable in restricted environments where controlling access to data is an issue (e.g. where private connections are used by individuals to access their own workbooks). If you are considering using OracleAS Web Cache in a restricted environment, note that a malicious user might be able to access pages that have been cached for another user (for more information about OracleBI Discoverer security in general, see Chapter 14, "Maintaining security with OracleBI Discoverer").

8.5 How to use Discoverer Viewer with OracleAS Web Cache

To use Discoverer Viewer with OracleAS Web Cache, do the following:

8.5.1 How to create Discoverer caching rules

Although OracleAS Web Cache is installed with OracleAS, it is disabled by default. To make use of OracleAS Web Cache, you must create caching rules. For example, you might want to cache Discoverer Viewer pages, or use a Discoverer middle tier machine to provide load balancing.

To enable OracleAS Web Cache for Discoverer Viewer:

  1. Display the Discoverer Home page in Application Server Control (for more information, see Section 5.1.2, "How to start Application Server Control and display the System Components page").

  2. In the Components table, select the Web Cache link in the Name column to display the Web Cache Home page.

  3. Display the Administration tab.

    Description of wc2.gif follows
    Description of the illustration wc2.gif

  4. Select the Rules link in the Properties - Application area to display the Caching area.

    Description of wc3.gif follows
    Description of the illustration wc3.gif

  5. Click Create to display the Create Rule page.

    Description of wc5.gif follows
    Description of the illustration wc5.gif

  6. Create a new rule as follows:

    1. In the Name field, type Discoverer caching rule or a similar unique name.

    2. In the Match URL By field, select Path Prefix from the drop down list, and type /discoverer/app in the adjacent text box.

      Do not change the default values of the other fields.

    3. Click OK to save the rule.

      If you created the rule correctly, a confirmation message is displayed at the top of the Rules page that says 'Rule created successfully. This change will not take effect until Web Cache is restarted'.

  7. Click Create to display the Create Rule page.

    Description of wc5.gif follows
    Description of the illustration wc5.gif

  8. Create a new rule as follows:

    1. In the Name field, type Discoverer caching rule 2 or a similar unique name.

    2. In the Match URL By field, select Path Prefix from the drop down list, and type /discoverer/servlet/GraphBeanServlet in the adjacent text box.

    3. Click Show HTTP Methods and Parameters to display the HTTP Methods details.

      Description of wc6.gif follows
      Description of the illustration wc6.gif

    4. Select the GET with query string check box.

    5. Select the POST check box.

    6. Click OK to save the rule.

      If you created the rule correctly, a confirmation message is displayed at the top of the Rules page that says 'Rule created successfully. This change will not take effect until Web Cache is restarted'.

  9. Click Restart Web Cache, and click Yes at the confirmation page.

    OracleAS Web Cache will now cache Discoverer Viewer pages, which will improve Discoverer performance.

8.5.2 How to enable OracleAS Web Cache for Discoverer Viewer

Although OracleAS Web Cache is installed with Oracle Business Intelligence, it is disabled for use with Discoverer Viewer by default. To make use of OracleAS Web Cache with Discoverer, you must enable it. For example, you might want to cache Discoverer Viewer pages, or use a Discoverer middle tier machine to provide load balancing.

Note: Although Application Server Control might display the status of OracleAS Web Cache as 'Enabled' in the Components table, this does not mean that it is enabled for use with Discoverer Viewer. You must make sure that the Use WebCache check box is selected on the Discoverer Viewer Configuration page, as described below.

To enable OracleAS Web Cache for Discoverer Viewer:

  1. Display the Discoverer Home page in Application Server Control (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

    Description of em_main.gif follows
    Description of the illustration em_main.gif

  2. In the Components table, select the Discoverer Viewer link in the Name column to display the Discoverer Viewer Home page.

    Description of em_view.gif follows
    Description of the illustration em_view.gif

  3. Select the Caching link to display the Caching area.

    Description of em_view2.gif follows
    Description of the illustration em_view2.gif

  4. Select the Use WebCache check box.

  5. Click OK.

    OracleAS Web Cache is now enabled and starts caching Discoverer Viewer pages.

8.5.3 How to configure Discoverer Viewer to enable maximum caching

To maximize caching of Discoverer Viewer pages, you can optionally limit the end user options available in Discoverer Viewer. For example, if you remove the worksheet layout toolbar, you limit the amount of worksheet manipulation allowed by end users, which makes it easier for OracleAS Web Cache to cache pages.

To configure Discoverer Viewer to enable maximum caching:

  1. Display the Application Server Control Discoverer Home page for the machine that you want to configure (for more information, see Section 5.1.3, "How to display the Application Server Control Discoverer Home page").

  2. In the Components table, select Discoverer Viewer in the Name column to display the Discoverer Viewer home page.

    Description of em_view.gif follows
    Description of the illustration em_view.gif

  3. Select the Delay link to display the Viewer Delay Times area.

  4. Set the Query Progress Page value and Request value to a high value (e.g. 60 seconds).

  5. Click OK to return to the Discoverer Viewer Home page.

  6. Display the Customization tab.

  7. Select Layout from the Customize drop down list and click Go to display the Customize Layout page. Description of layout.gif follows
    Description of the illustration layout.gif

  8. In the Action Links area, clear as many of the check boxes as possible, making sure that you enable the end users to perform any necessary tasks (e.g. Print, Send as Email).

  9. In the Others area, clear the Tool Bars check box.

  10. Click Apply to save the changes you have made.

  11. Run Discoverer Viewer and open a workbook.