Top
Systemwalker Service Quality Coordinator User's Guide (WebsiteManagement Functions Edition)
Systemwalker

9.1.5 Integrated analysis with data on the backbone system

This section describes the integrated analysis of information on the Web server and data on the backbone system.


9.1.5.1 Overview of integrated analysis with data on the backbone systm

Systemwalker Service Quality Coordinator provides functions that, through the analysis of the Web site usage using the Web server log, are useful for doing business. The following types of analysis are made possible by integrated analysis of information output by Systemwalker Service Quality Coordinator and sales and customer data on the backbone system:

As shown in the above analysis examples, an analysis that is impossible with only Web server information becomes possible when data on the backbone system is integrated into the analysis. Integrated analysis makes Web sites more effective for business.

Systemwalker Service Quality Coordinator collects log data for a Web server and uses products such as the Symfoware e-Business Intelligence Suite, with advanced analysis functions that include data mining, for integrated analysis that uses data on the backbone system.


9.1.5.2 Method of integrated analysis with data on the backbone system

The following explains how to perform integrated analysis that uses data on the backbone system.

  1. In the analysis target server definition block in the Usage DB environmental definition file, specify combined operation with both the Usage DB and CSV-format log file as the Usage DB operation type.

    DatabaseMode = both


  2. Log data for the Web server is output to the following directory as a CSV-format file by the Usage DB Registration Engine.

    Note: < > indicates a directory.


    (*1) The server directory is created with the name specified in Symbol of the Analysis Target Server Definition Block in the Usage DB environmental definition file.

    (*2) Variables in the CSV-format log file name are listed below. Year/Month/Day is the date when the Usage DB is switched (created).

    yyyy

    Year (1980-)

    mm

    Month (01 - 12)

    dd

    Day (01 - 31)

    nnn

    Sequential number (001 - 099)

  3. Enter the CSV-format log file output as shown above in the DB used by the analysis product (such as Symfoware e-Business Intelligence Suite) that performs integrated analysis with the data on the backbone system.


    See "15.2.6 Usage Log file" for information about the format of CSV format log files.


  4. The analysis product is used to do the analysis.