User Manual

18
1.24.2 Supported Databases
While the general set of data present in the internal databases is
derived from the primary requirements, its partition into specific
databases is a high level architecture decision.
1.1.1
4.2.1 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
•
Gateway id