Rockwell Automation Emonitor with an Oracle Multi-User Database - Manual (Page 12)

I NSTALLING E MONITOR S OFTWARE WITH AN O RACLE M ULTI -U SER D ATABASE
8
• •
•
•
•
Table descriptions
These tables expand the most as items are added to them. The amount and type of
expansion are described below.

MULTI_VALUE_DATA
This table experiences exponential growth. This table holds data with multiple
components, such as spectrum and time waveform data. The amount of growth
depends on how often data is collected and the type of data collected.

SINGLE_VALUE_DATA
This table also experiences ongoing growth. This table holds magnitude measurement
data, as well as numeric, calculated, and enumerated measurement data (known
collectively as process measurements.) The amount of growth depends on how often
single-value measurements are collected.

LOCATION
This table also experiences ongoing growth, because it is related to the number of
locations created in Emonitor.

MEASUREMENT_DEF
This table also experiences ongoing growth. The growth is related to the number of
measurement definitions created in Emonitor.

HIERARCHY_LIST
This table also experiences ongoing growth. The growth is related to the number items
in the Hierarchy Tree in Emonitor (plants, equipment trains, machines, and possibly
components).

ALARM
This table expands as alarms are added to the measurement definitions. One
measurement definition can have multiple alarms associated with it. However, once
users have set up most of the alarms, this table will not expand as quickly.

CATEGORY
This table expands as categories are added to the software. The demo data contains
three pre-defined categories that users can use. However, users will likely want to
tailor those categories to fit their needs, so the table may expand in the beginning.
Once the users set up the categories, these tables will not expand.
Creating tablespaces and users
The default names for the entek tablespaces are entekd and enteki. You can rename them
but remember to modify the entekora.sql script as needed to reflect the new tablespace
naming. The same applies to the econfig tablespaces (econfigd and econfigi).