User's Manual

12
Internal Databases
The utility server software shall support access to and maintenance of the following internal databases, independently
for each utility supported. The databases referred to in this section are abstract entities introduced for the purposes of
requirements analysis and will not necessarily be implemented as databases in the sense of an JDBC (or other
protocol) database entity. The assignment of data to specific tables and the assignment of tables to specific databases
will be done in part in the system architecture design and in part in the utility server design.
Database Record Type Item Comment
Network
Configuration,
Network Planning
Gateway Gateway id.
Gateway WAN Type
Hardware revision number
Software revision number
Operating system revision number Gateway
application (gw.zip) revision number Classes.zip
revision number Patch file contents and revision
numbers Location information
Patch file may be a
separate record type
or even in a separate
table. Location
information may
include lat, long,
elevation and pole #.
Relay Relay id
Relay hardware revision number
Relay software revision number
Location information
Location information
may include lat, long,
elevation and pole #.
Meter Utility Id (AKA utility serial number, pin
number)
Meter type
Location information
Calibration Factor (for water meters)
Location information
may include lat, long,
elevation and pole #.
Supported
WANs
WAN type designation
WAN PIN number
Gateway-IMU
association
information
Gateway id
IMU id that is registered with gateway
Option relay id that IMU is registered with
Software/Hardwar
e version
compatibility
Use to keep
track of which
gateways,
relays and
meter versions
are compatible
with other
versions.
This is intended to
act as an error
checking mechanism.
This database is
static from the
utilities point of view,
and would be
supplied by Innovatec
each time a new
gateway, relay or
IMU version came
out.
Alarm
configuration
Alarm activity
information
IMU id
Alarm type
Alarm active or inactive
Time of last activation (or should this be an
alarm history?)
Alarm
notification
information
IMU id
Alarm type
Notification type specification