Contents

• Contents
• List of Figures
• Introduction
  • The Clickstream System
  • A Clickstream User Scenario
• The Clickstream Architecture
  • The Life Cycle of a Click
  • The Clickstream Client
    • The ArsDigita Community System
  • The Clickstream Server
    • Downloading and Loading Data
    • Populating the Warehouse
    • Reports
  • The Clickstream Data Model
• Background
  • Data Warehousing
  • Gathering User Data
  • Related Work
    • Accrue
    • Oracle
    • Other software providers
  • Definitions
    • Session
    • Hit
    • Performance and Scalability
• The Clickstream Design
  • Privacy
    • Preserving Privacy
    • Aggregation
  • Performance and Scalability
    • Granularity
    • Minimizing Data Collection
    • Client-side Performance
  • Transparency
    • Design
  • Platform Independence
    • Design
  • Extensibility
    • Dimensional Data Warehouse
    • Reports
• Implementation
  • Server-Side Performance
    • Materialized Views and Query Rewrite
    • Direct Path Inserts
    • Disabling Constraints
    • Hints
    • Dynamic PL/SQL
    • Reducing the Data Warehouse Size
  • Client-Side Logging
  • Reports
    • The Dynamic Site Map
    • The Entry Pages Report
  • Additional Features
    • Multiple Tablespaces
    • ACS 4.0
• Testing and Results
  • Privacy
    • Methodology
    • ArfDigita
    • Results
  • Performance and Scalability
    • Results
  • Transparency
  • Platform Independence
  • Extensibility
  • Accuracy
• Conclusion
  • Future Work
    • Performance and Scalability
    • Multiple Data Source Integration
    • Portability
    • Evolutionary Improvements
  • Lessons Learned
• Clickstream Data Model
• Bibliography