POSC Meta Model Specifications Version 2.3 |
Logical Data Model |
This is to hold usage statistics on various objects within the meta data
- object_s (M: string(19))
- The instance handle of the object these statistic describe.
- object_t (M: ref_object)
- This is the type of object that these statistics apply to.
- ave_create (O: integer)
- This is the arithmetic mean of the number of rows created during the period considered , using a user defined period as the denominator.
- ave_delete (O: integer)
- This is the average number of rows deleted over the period considered using a user defined time period as the denominator (e.g 1200 per day)
- ave_rows (O: integer)
- The arithmetic mean of the number of rows over the period considered.
- ave_update (O: integer)
- This is the average (arithmetic mean) of the number of updates over the period considered, using a user defined period of time for the denominator.
- end_time (O: date)
- The end of the period over which these statistic apply.
- max_create (O: integer)
- This is the number of rows created over the period of time considered.
- max_delete (O: integer)
- This is the maximum number of rows deleted during a time period specified by the DBA for the period of time considered.
- max_rows (O: integer)
- This is the maximum number of rows over the period of time considered.
- max_update (O: integer)
- This is the maximum number of updates that took place during the user defined time period during the period considered (e.g 10000 per day)
- min_rows (O: integer)
- The minimum number of rows over the period considered.
- start_time (O: date)
- The beginning of the period over which these statistic apply.
- prod_versn (O: prod_versn)
- The projection run that produced the objects these statistics apply to.
- source (O: source)
- The source of the objects these statistics apply to.
Entity projects as table USE_STATS.
Referenced in Diagrams:
© Copyright 1997-2001 POSC. All rights reserved.