Creating a Database

A complete Site Server Express Analysis installation includes at least one database. This database can be used to archive and analyze log file data from all sites, so you can aggregate data across all of those sites and analyze trends. However, there are two reasons why you might want to create multiple databases:

Performance Smaller databases can be analyzed faster. If two sites don’t ever need to be aggregated, consider keeping their data in separate databases.
Security By keeping data in separate databases, you can control who has access to what data.

Note
iiiiiiiMerging of databases is not currently supported. You can incorporate earlier versions of Usage Import (Market Focus 1.0 and 2.0) into a database by configuring the Log data source in the Server Manager. (See "The Server Manager" in Chapter 5.)

iii

Microsoft Access-Compatible Versions

The installation program creates a database named ANALYST.MDB in your installation directory. This file is your default database, and both the Usage Import and the Report Writer use this database unless you specify otherwise.

The installation program also creates a file, TEMPLATE.ZIP, in your installation directory. This file is a compressed archive of ANALYST.MDB. If you need to create a new database, simply decompress this archive to a new directory.

Note
This archive doesn’t have Internet sites configured, and it contains no log file data.

You can rename or move the original ANALYST.MDB. If you do so, then Usage Import and Report Writer don’t know where it is, so you’ll need to select a new database file when the file browser prompts you. You are given one opportunity to select a valid database. After one failed connect attempt, the program quits.

iiii