Skip Headers
Oracle9
i
Clickstream Intelligence Data Model Reference
Release 2 (9.0.2)
Part Number A96129-01
Home
Solution Area
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Intended Audience
Documentation Accessibility
Structure
Related Documents
Conventions
1 Introduction
Introduction to Oracle9i Clickstream Intelligence Builder
Using the Clickstream Intelligence Builder
Extending the Data Model
Extending Clickstream Analytics
2 The Agent Dimension
Agent Dimension Hierarchies
The Agent Client Software Hierarchy
The Agent Operating System Hierarchy
Agent Dimension Levels
CLK_L_CLIENT_TYPE
CLK_L_CLIENT
CLK_L_CLIENT_VERSION
CLK_L_PLATFORM
CLK_L_OPERATING_SYSTEM
CLK_L_AGENT
3 The Client Host Dimension
Client Host Dimension Hierarchies
The Client Geography Hierarchy
The Client Organization Hierarchy
Client Host Dimension Levels
CLK_L_REGION
CLK_L_COUNTRY
CLK_L_DOMAIN_TYPE
CLK_L_DOMAIN
CLK_L_CLIENT_HOST
4 The Date Dimension
Date Dimension Hierarchies
The Date Calendar Hierarchy
The Date Fiscal Hierarchy
The Date Week Hierarchy
Date Dimension Levels
CLK_L_CALENDAR_YEAR
CLK_L_CALENDAR_QUARTER
CLK_L_CALENDAR_MONTH
CLK_L_FISCAL_YEAR
CLK_L_FISCAL_QUARTER
CLK_L_FISCAL_MONTH
CLK_L_WEEK
CLK_L_DAY
5 The Event Type Dimension
Event Type Dimension Hierarchies
The Event Type Hierarchy
Event Type Dimension Levels
CLK_L_EVENT_TYPE
6 The Page Dimension
Page Dimension Hierarchies
The Page Category Hierarchy
The Page Resource Hierarchy
Page Dimension Levels
CLK_L_PAGE_CAT6
CLK_L_PAGE_CAT5
CLK_L_PAGE_CAT4
CLK_L_PAGE_CAT3
CLK_L_PAGE_CAT2
CLK_L_PAGE_CAT1
CLK_L_RESOURCE_TYPE
CLK_L_RESOURCE
CLK_L_PAGE
7 The Referrer Dimension
Referrer Dimension Hierarchies
The Referrer Campaign Hierarchy
The Referrer Category Hierarchy
The Referrer Geography Hierarchy
The Referrer Organization Hierarchy
Referrer Dimension Levels
CLK_L_CAMPAIGN
CLK_L_REF_CAT3
CLK_L_REF_CAT2
CLK_L_REF_CAT1
CLK_L_REGION
CLK_L_COUNTRY
CLK_L_DOMAIN_TYPE
CLK_L_DOMAIN
CLK_L_REF_SITE
CLK_L_REF_URL
8 The Search Dimension
Search Dimension Hierarchies
The Search Hierarchy
Search Dimension Levels
CLK_L_SEARCH_CAT3
CLK_L_SEARCH_CAT2
CLK_L_SEARCH_CAT1
CLK_L_SEARCH
9 The Server Dimension
Server Dimension Hierarchies
The Server Hierarchy
Server Dimension Levels
CLK_L_SERVER_FARM
CLK_L_SERVER
10 The Server Status Dimension
Server Status Dimension Hierarchies
The Server Status Hierarchy
Server Status Dimension Levels
CLK_L_STATUS_TYPE
CLK_L_STATUS
11 The Session Type Dimension
Session Type Dimension Hierarchies
The Session Type Hierarchy
Session Type Dimension Levels
CLK_L_SESSION_TYPE
12 The Site Dimension
Site Dimension Hierarchies
The Site Hierarchy
Site Dimension Levels
CLK_L_SITE
13 The Time of Day Dimension
Time of Day Dimension Hierarchies
The Time of Day Hierarchy
Time of Day Dimension Levels
CLK_L_HOUR
CLK_L_MINUTE
CLK_L_SECOND
14 The User Dimension
User Dimension Hierarchies
The User Age Gender Hierarchy
The User Company Hierarchy
The User Geography Hierarchy
User Dimension Levels
CLK_L_AGE_GROUP
CLK_L_GENDER
CLK_L_INDUSTRY
CLK_L_COMPANY
CLK_L_REGION
CLK_L_COUNTRY
CLK_L_STATE
CLK_L_USER
15 The Visitor Dimension
Visitor Dimension Hierarchies
The Visitor Hierarchy
Visitor Dimension Levels
CLK_L_VISITOR_TYPE
CLK_L_VISITOR
16 The Impression Fact
Impression Fact Attributes
Foreign Keys
Measures
17 The Session Fact
Session Fact Attributes
Foreign Keys
Measures
Index
Copyright © 2002 Oracle Corporation.
All Rights Reserved.
Home
Solution Area
Index