FathomTrendDatabase tables
If you have used the PROMON utility with an OpenEdge database before, the information displayed in the FathomTrendDatabase tables might look familiar to you. However, there is a difference between the information available through Fathom tables and that through PROMON. Fathom tables store data in one place, making it faster for you to view data. For example, all user information is contained in one table. To access user information with PROMON, you would have to view more than one PROMON screen. Unlike PROMON, Fathom must access only one table to return a view of user statistics.
As with configuration tables, the schema of these tables is dependent upon many subsystems. Figure 3–2 shows the relationship among these tables.
Figure 3–2: Database table relationships
![]()
Figure 3–2 describes the data gathered for each trended database. Every DB_ table contains the sample's ID number. The sample table stores data from the gathered sample, which applies to all the tables. The sample table also contains the sample's Site and Resource IDs. A control record in the control table generates the Sample ID.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |