About the Data Warehouse

  • Article

You use the Commerce Server Data Warehouse to import, transform, and store Web site data. You use the data stored in the Data Warehouse to analyze user activity on your Web site. Commerce Server 2002 Enterprise Edition provides several business analytic features — such as reports, segment viewer, and affinity lists — in Commerce Server Business Desk. These reports show data from the Data Warehouse formatted in various ways to answer specific business questions about your Web site.

You can perform the following tasks using the Data Warehouse:

  • Import Web log file, user profile, campaign, transaction, and catalog data from your Commerce Server site. You can also import data from other data stores, such as non-Commerce Server Web servers.
  • Resolve Internet Protocol (IP) addresses imported for client hosts that have connected to your site for use in custom reports.
  • Prepare the data in your Data Warehouse for analysis by populating the online analytical processing (OLAP) cubes, which organize the data for retrieval during report execution.
  • Delete imported log file data to reduce the amount of storage space within the SQL Server database required by Commerce Server.
  • Delete all data from the Data Warehouse to remove existing test or archived data.
  • Automatically rebuild analysis models to show current data for prediction, and archive existing analysis models.

The Data Warehouse uses Data Transformation Services (DTS) tasks and OLAP cubes to extract, transform, and load (ETL) data. For detailed information about the ETL process performed by each task, see Extract, Transform, and Load Processes for DTS Tasks.

This section contains:

Copyright © 2005 Microsoft Corporation.
All rights reserved.