User`s guide

SPECTRUM Data Types
Statistics
Data Structure of SQL Tables Data Export User’s Guide
C-12 Version 5.0rev1
Statistics
Description: Statistical data collected during the specified time period
Standard Format
Columns: ts The time stamp, a date field
lh The landscape handle, a 4-byte integer
mh The model handle, a 4-byte integer
at#1 Value of attribute #1 for the time and model
handle*
at#2 Value of attribute #2 for the time and model
handle*
at#n Value of attribute #n for the time and model
handle*
* Where the actual names of columns at#1 through
at#n are derived from the first 24 characters of the
selected logged attributes.
Indexed by: ts + lh + mh
* The size depends on the attribute type shown in Table C-12.
**The number of attributes (at#n) depends on the number selected in the
Statistics Filter dialog box when the export definition file was created.
Table C-10. Format for Statistics (Standard Format)
Time Stamp
(ts)
Landscape
Handle (lh)
Model Handle
(mh)
Value of Attribute #
(at#1 through at#n)**
15-April-1998
15:10:12
4194304 10485760 4235
15-April-1998
15:10:12
4194304 10485761 6831
15-April-1998
15:10:12
4194304 10485760 2874
15-April-1998
15:10:12
4194304 10485762 372
date 4-byte integer 4-byte integer Format dependent on
attribute type (see
Table C-12)
ÑÑÑÑÑ I N D E X ÑÑÐÑÑ