ORACLE CLICKSTREAM INTELLIGENCE 11i

Clickstream Intelligence 1.0
Oracle Clickstream Intelligence empowers end-users with analysis of Web site performance, visitor traffic, the effectiveness of Web content, and customer loyalty. Oracle Clickstream Intelligence integrates a set of open data warehousing technologies available in the Oracle database and tools to provide key elements and requirements of a robust clickstream data mart solution, such as:

• The ability to read Web server logs and parse cookies and query string data to identify unique visitors and sessions, and capture other critical application data
  
• The ability to transform server log data into business facts such as page impressions and sessions
  
• The ability to integrate Web traffic with business transaction data such as orders and marketing campaigns
  
• A flexible reporting structure which employs standard reports for rapid deployment and supports user-defined reporting
  
• Performance, scalability, and manageability consistent with the potentially enormous data volumes generated by large-scale Web environments
  
• Extensibility to accommodate new user-defined data sources over time, such as call centers, ad servers, etc.
  

Pre-Packaged Data Mart
Oracle Clickstream Intelligence leverages a multidimensional data mart to answer a broad range of questions regarding your customers' experience of your Web site and the Web site's performance. The data mart prepackages the loading and transformation of data from Web logs and provides user-configurable interface tables to link Web session activity with your transaction data.

The clickstream data mart model and related Web log transformations are delivered in the form of an Oracle Warehouse Builder (OWB) repository. OWB is a comprehensive, extensible framework for the design, deployment, and management of e-business intelligence systems. OWB allows you to customize the prepackaged data mart.

Web-Based Administration
Clickstream Intelligence provides a Web-based administration tool for specifying how Web site-specific clickstream data is processed. Through a wizard-like interface, the Configurator streamlines the configuration of:

• Log File Formats
• User Identification
• Visitor Identification
• Session Identification
• Dynamic Pages
• Resource Types
• Application Parameters

Portal-Based Dashboard Report: Average Session Duration by Week

Portal-Based Reports
Clickstream Intelligence delivers a Web-based "dashboard" with reports and graphs that provide easy access to relevant Key Performance Indicators. This dashboard may be customized to meet the management needs of individual users. Users may drill down on charts and reports to access supporting detail.

User-defined reports may be added using Oracle Portal. Oracle Portal is a complete framework for the development and deployment of Web-based portlets. It includes user administration, security, content customization, and development features to create and maintain basic reports, charts, and form-based applications.

Performance & Summary Management
Web sites generate enormous volumes of log data that must be loaded, transformed, and summarized to meet the reporting and analytical requirements for understanding e-business. The data mart infrastructure fully leverages the unique data warehousing features in the Oracle8i database that support the performance and manageability requirements of large-scale e-business intelligence applications, including:

• Materialized Views
  Materialized views allow the creation of summary tables to which the database query optimizer may redirect queries to reduce response times. Oracle Clickstream Intelligence provides a full set of materialized views to optimize query performance for the included set of reports. DBAs may utilize Oracle Enterprise Manager or other tools to implement additional materialized views to support user-defined reports and queries.
  
  
• Partitioning
  Clickstream Intelligence provides a mechanism for systematically removing data when it is no longer needed, or simply to manage the size of the database. Clickstream Intelligence leverages the partitioning feature of Oracle 8i to implement a "rolling window" partitioning scheme which allows detail data to be removed independently of summary data.
  
  
• Parallelism
  In order to optimize the loading of large volumes of data, Clickstream Intelligence transformations and aggregations are designed to run in parallel.

Extensibility
While Oracle Clickstream Intelligence realizes immediate business value, the product is extensible to support unique e-business intelligence needs that go beyond Web traffic analysis. Built on an OWB framework, Clickstream Intelligence leverages OWB bridges for sharing metadata with Oracle's BI tools. OWB can also be used to extend the Clickstream Intelligence data mart model by modeling new user-transaction tables.

Integrated Solution
Oracle provides software to meet all your Data Warehousing needs, for example:

• Oracle Data Mining Suite to find unexpected trends, patterns, and relationships in your data
  
• Pure Integrate to cleanse and standardize the name and address, household, and other demographic data on your customers
  
• OWB Integrators to ease data cleansing and provide data migration from Oracle Applications, and SAP R/4
  
• Pure Extract to integrate data from mainframe systems