Customers analyze Commerce data in order to identify trends, problems and opportunities in historical data and then use that information to adjust the WebSphere Commerce settings to maximize customer experience and profit.
WebSphere Commerce Analyzer reads the data from the WebSphere Commerce and Tivoli Web Site Analyzer databases and manipulates it, using extract, transform and load (ETL) processes, into a new schema called datamart which is optimized for analytics reporting. Customers can then perform datamining on some of the data in the datamart.
When extending the WebSphere Commerce database, customers should follow instructions in the WebSphere Commerce Analyzer online help on how to add database modifications to the extract, transform and load (ETL) processes. Customers can also create datamining algorithms (demographic clustering) to mine existing data or additional data added through customization, in different ways.
Professional, Business, and Express (except data mining) Edition
Task | Description | Role |
---|---|---|
Update data mart |
Selected tables from the WebSphere Commerce and Tivoli Web Site Analyzer databases are replicated, or copied, to the datamart for processing. DB2's Replication technology copies only the changes made since the last replication, not the entire table. Data from the replicated WebSphere Commerce and Tivoli Web Site Analyzer tables is processed and manipulated into the WebSphere Commerce Analyzer datamart tables, which are optimized for reporting. This manipulation also completes some summarizing and effectiveness calculations on the data. |
Business intelligence analyst |
(C) Copyright IBM Corporation 1996, 2004. All Rights Reserved.