Skip Headers

Oracle9iAS Clickstream Intelligence Administrator's Guide
Release 2 (9.0.2)

Part Number A90500-02
Go To Documentation Library
Go To Product List
Solution Area
Go To Table Of Contents
Go To Index

Go to previous page Go to next page

Getting Started

This chapter provides an overview of the Runtime Administrator user interface (UI) and architecture, and describes the tasks for which a Clickstream Intelligence Administrator is responsible. You'll find information on the following topics:

Introduction to the Runtime Administrator

The Runtime Administrator is the tool that enables you to specify the criteria with which Oracle9iAS Clickstream Intelligence acquires and processes Web data. After configuring the Runtime Administrator, you will be able to retrieve and process log data from one or more sites on the World Wide Web (WWW), and then load that data into your database. The data stored in the database provides an information resource from which analytical reports can be created.

To get started, you need to first define a Clickstream site from which Web log data will be acquired. For each site created, you must define data collection parameters that determine the type of Web data you want to store in the Clickstream Intelligence database. You must also specify the data source(s) from which log data will be acquired. With Oracle9iAS Clickstream Intelligence, you collect only the data your company needs because you define the parameters that characterize the information obtained from Web server log files.

Launching the Runtime Administrator

To launch the Runtime Administrator, open an Internet browser window and enter the URL provided by your Clickstream Intelligence Administrator. The URL is written in the following format:


The HOST is the name of the computer on your network that provides access to Oracle9iAS Clickstream Intelligence. The PORT is the HTTP port number on which the host (server) listens. To determine the port number for your host, ask your Database Administrator (DBA) or Clickstream Administrator. You can also go to the following configuration file located in the directory in which Oracle9iAS was installed:

(UNIX)  ORACLE_HOME/Apache/Apache/conf/httpd.conf

Upon entry of the appropriate URL, the Clickstream Intelligence Entry page appears with hyperlinks to the Runtime Administrator, Analytics- Discoverer Viewer, and Analytics- Discoverer Plus. From this page, click the link for the Runtime Administrator.

Logging In and Logging Out

After you launch Oracle9iAS Clickstream Intelligence, you must log in from the Login to Clickstream Intelligence Runtime Administrator page. To do this, enter a valid username and password and then click the Login button. If you have not been assigned a username and password, see your Clickstream Administrator.

You can log out of the Runtime Administrator in any of the following ways:

Before configuring sites with the Runtime Administrator, you should first familiarize yourself with the UI components and navigational pathways used to complete the specific tasks described in Chapter 3, "Configuring Clickstream Intelligence" The sections that follow introduce the Runtime Administrator UI and outline a typical navigational scheme to get you started.

The Runtime Administrator User Interface

All UI components can be found within two major functional areas of the Runtime Administrator: the Configure tab and the Manage tab. These first-level tabs are located on the right side of the Horizontal Navigation bar at the top of your screen.

The Configure Tab

The Configure tab is where you define and modify all information related to data collection. It is divided into two sections, each represented by a link on the left side of the Horizontal Navigation bar. The links described below appear only when the Configure tab is selected.

The figure below displays UI components that can be accessed from the Configuration Summary page, located within the Configure tab. Labeled elements are identified below the figure.

Figure 2-1 The Configuration Summary Page

Text description of ch2conf.gif follows.

Text description of the illustration ch2conf.gif

  1. Global Navigation buttons (Logout and Help)

  2. Tabs (Configure and Manage)

  3. Horizontal Navigation bar (the blue bar across the top of your screen that displays specific links when a particular tab is selected).

  4. Tab-specific links on the Horizontal Navigation bar (Site and System - displayed only when the Configure tab is selected)

  5. Site Navigation menu (This is displayed only when the Site link is selected. Similarly, the System Navigation menu appears when the System link is selected)

  6. Site Navigation menu options (Details, User Identification, etc.)

  7. Page button (Create Site)

The Manage Tab

The Manage tab is where you perform operations related to your database. It is comprised of two sections, each represented by a link on the left side of the Horizontal Navigation bar. The links described below appear only when the Manage tab is selected.

The figure below displays the Process Status page, located within the Manage tab. Labeled UI components are identified below the figure.

Figure 2-2 The Process Status Page

Text description of ch2mger.gif follows.

Text description of the illustration ch2mger.gif

  1. Global Navigation buttons (Logout and Help)

  2. Tabs (The Manage tab is selected; the Confgure tab is not selected)

  3. Horizontal Navigation bar (the blue bar across the top of your screen that displays specific links when a particular tab is selected).

  4. Tab-specific links on the Horizontal Navigation bar (Processes and Data Sources - displayed only when the Manage tab is selected.

  5. Page header (Process Status)

  6. Page subheader (Currently Running)

  7. Page button (Undo)


The administrative tasks for which you will use the Runtime Administrator follow a logical navigation scheme, as outlined in the following sections.

Workflow Outline

A general workflow, from creating a site to loading the database, is briefly outlined below. For details about any of the following tasks, please reference the appropriate sections of this Administrator's Guide.

  1. Create a site (Configure tab, Site link).

  2. Configure the options on the Site Navigation menu.

    (Definition of global page parameters is optional and not required for site validation.)

  3. View the Configuration Summary and modify as needed.

  4. Successfully validate the site (Site link, Configuration Summary page).

  5. Define one or more process definitions (System link, Process Definitions page).

  6. Load data into the database by starting a process type, such as "Load Clickstream" (Manage tab, Process Status page).

Task Summary by Interface Region

The paragraphs below summarize the types of tasks you can complete within specific navigational regions of the Runtime Administrator.

Oracle9iAS Clickstream Intelligence Architecture Revisited

The sections that follow take a closer look at Oracle9iAS Clickstream Intelligence architecture.

Detailed Overview

The Oracle9iAS Clickstream Intelligence architecture is represented in the following diagram. The blue arrows (1) represent data flow from the server farm to the Oracle9iAS Clickstream Intelligence database. Log files containing clickstream data are produced by Web servers, such as Oracle HTTP Server in Oracle9iAS, or on other "non-iAS" servers. A Collector Agent is installed on the server machine, or data source. It breaks log files into data packets, which are then compressed to facilitate transmission to the Collector Server. The Collector Server retrieves and uncompresses the data packets; the Clickstream Loader then parses and transforms the log data prior to database loading.

To define data collection parameters and processes, simply access the Runtime Administrator from your Web browser. The green arrows (2) represent the flow of information during Clickstream Intelligence set-up and management. All configuration data is accessed via Web browser and stored in the Runtime Administrator tables, located within the clkrt database schema.

The red arrows (3) represent data flow when you run the pre-defined reports that comprise Clickstream Analytics. All Clickstream reports created with Oracle9iAS Discoverer technology can be accessed with a Web browser. Both Oracle9iAS Discoverer Plus and Oracle9iAS Discoverer Viewer enable you to view analytical reports based on data from your Web sites. To create and run reports that contain your Web data, Discoverer uses information in the Discoverer End User Layer (EUL), located in the clkana database schema. Discoverer also utilizes data from the summary layer and star schema, both located in the clkrt database schema. For more information about Clickstream Analytics, see the Oracle9iAS Clickstream Intelligence User's Guide. For more information about Oracle9iAS Discoverer, please reference the Oracle9iAS Discoverer Configuration Guide and the Oracle9iAS Discoverer Plus User's Guide.

Figure 2-3 Oracle9iAS Clickstream Intelligence Detailed Architecture

Text description of ch2arch.gif follows.

Text description of the illustration ch2arch.gif

The list that follows describes some of the components displayed in the architecture diagram:

Loading Web Data

Each time Web log data is loaded into the Clickstream Intelligence database, it is first stored in a generalized staging table (see the figure below). This staging table is used to populate both the Impression fact table and the Session fact table when you perform a Clickstream Load process.

The Impression fact table stores the most granular data in the database. Every page view that is recorded in a Web log corresponds to one row in the fact table. Columns consist of measures and dimension table foreign keys. (Clickstream Intelligence computes some measures, while others are derived directly from the Web log). Because measures are calculated on the session rather than on the impression level, data in the Session fact table is less granular than data in the Impression fact table. Collectively, both fact tables comprise the base structure of information that is stored in the database and used to produce business reports via Clickstream Analytics.

Figure 2-4 Staging and Fact Tables in the Clickstream Database

Text description of ch2fact.gif follows.

Text description of the illustration ch2fact.gif

Populating the Dimensions

The Clickstream database is comprised of 14 pre-defined dimensions. Dimensions can be populated with data from incoming Web log files, or can be populated with dimension keys and level attributes that you load into the interface tables. To populate the dimensions with external (non-Web) data, your company's Clickstream Administrator (or System Administrator) must first load data into the interface tables. Then use the Runtime Administrator load data into the database dimensions by executing a Load Dimensions process.

Interface tables are organized hierarchically; interface tables within a given hierarchy are related via foreign and natural keys. The foreign key of the parent interface table (the table that is lower in the hierarchy) is related to the natural key of the interface table above it (the child).

When you run a Load Dimensions process,data from the interface tables is loaded into the corresponding dimension level tables. Relationships among level tables in a hierarchy are established with foreign and primary keys. The foreign key of each level table relates to the primary key of the level table above it.

Data from all dimension level tables, in one or more hierarchies, comprise a dimension. Columns in a dimension correspond to the attributes from all dimension level tables; the number of rows in a dimension corresponds to the number of rows in the lowest dimension level table. To learn more about the Clickstream Intelligence data model, see the Oracle9i Clickstream Intelligence Data Model Reference.

Your Role as Clickstream Intelligence Administrator

As an Oracle9iAS Clickstream Intelligence Administrator, you will typically perform the following tasks:

The Clickstream Administrator should also understand the design and function of the Web site(s) and other information sources that provide Web log data and support your company's decision-makers. To facilitate site configuration (and thereby report creation), you must understand what types of data fit your company's analytical needs. Moreover, you should be familiar with the contents and design of the database, as you will have access to (and control of) tables, views, and other database objects.

Go to previous page Go to next page
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Go To Product List
Solution Area
Go To Table Of Contents
Go To Index