Table and field name definitions

The naming of tables and fields in the Fathom database follows certain conventions. Each table and field name consists of a prefix and a suffix, separated by an underscore. The prefix indicates which resource the table or field is related to. The suffix indicates the name of the data and might contain a subsection. The suffix cannot be more than 15 characters long. Table 3–1 explains each prefix.

Table 3–1: Table prefix definitions
Prefix
Table or field contents
Description
Cf_
Configuration data
Tables or fields that store configuration information for such Fathom functions as schedules, resource identification, and alert definitions. See the "Configuration tables" section for more information.
Sys_
System data
Tables or fields that store raw data collected from samplings of such resources as CPU, disk, and memory. See the "System tables" section for more information.
Db_
Database data
Tables or fields that store data gathered from OpenEdge™ databases. Sample data includes I/O, user statistics, and memory management. See the "Compaction details for configuration tables" section and the "Database analysis tables" section for more information.
OE_
OpenEdge Server data
Tables or fields that store data gathered from WebSpeedŽ and AppServer™.

Note: Fathom supports management of the WebSpeedŽ Transaction Server product. Throughout this guide, WebSpeed Transaction Server and WebSpeed are used interchangeably.
Ar_
Archive data
Tables or fields that store data gathered from OpenEdge databases for archiving purposes. Sample data includes all fields and data associated with a given table and archive-specific fields. Data stored in system and database tables can be archived; data stored in configuration tables cannot be archived. See the "Archive tables" section for more information.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095