Table and field name definitions

The naming of tables and fields in the OpenEdge Management 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 OpenEdge Management 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: OpenEdge Management 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 © 2006 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095