4

4.4.6 Data Stores

As stated in the Architecture section, the design for CHART II will utilize the Traffic Management Data Dictionary (TMDD) to ensure consistent object names both within the CHART II system and with the ITS industry. However, as the TMDD is still in development, the CHART II design presented within this document is not a full detailed design, TMDD elements have not been referenced in the software design. As a major part of the detail design, a mapping from identified CHART II objects to TMDD will be undertaken. Thus, the tables described in this section are not fully compliant with the TMDD. Instead, the data stores are included solely to further illustrate the concepts of the described software solutions.

Because CHART II is a distributed, complex system, not only do all data stores need to be well defined, but the location of each one and how its data is updated and shared need to be planned as well. In the discussion of the system services, a number of data stores were discussed, including an abbreviated listing of their contents. As a reference, the key databases of CHART II and their functions are listed in the table below.

Database Tables Described in System Services

Name	Description
AORConfig	Contains the rules that the Operator Area of Responsibility service uses to determine what operator is responsible for what zone at a given time or during a specific system event
Assigned AOR	Contains the operator currently assigned to each area of responsibility. When an incident is detected, the operator who is assigned to the area of responsibility will be notified. That operator will be given all necessary privileges to fully respond to the incident
External Import	Contains a list of all External Systems which have data that needs to be imported into the CHART II system. It also contains information that indicates what data is to be imported, where to find it and how often imports are to be run.
ExternalExport	Contains a list of all External Systems which have requested that they receive data from CHART II. It also contains information on how often the data should be prepared, the data source and the data destination.
FaxRequest	Contains a list of a Fax requests and their current status
Legacy-Import	Contains a list of all Legacy Systems which have data that needs to be imported into the CHART II system. It also contains information that indicates what data is to be imported and how often imports are to be run.
Notification	Contains all notification rules defined within CHART II. A notification is undertaken to notify all interested parties of an event that occurred within the system. A Notification table is the series of steps to be taken.
PageRequest	Contains a list of a Paging requests and their current status
ServiceRouting	Contains the rules that Transaction Servers will use to determine how to route a request for service. Every time a request for service is made, it is initially routed to the closest Transaction Server. The Transaction Server looks up the request in this table to determine where to route the request for service.
SystemArchive	Contains a list of all archive procedures to run and when to run them. The System Archive process monitors this table
SystemProcess	Contains a list of all processes within CHART II. Contains information that the system controller service will use to determine the status of the process, who to restart it on failures, and what notification procedure to run if the process cannot be restarted.
VehicleLocation	Contains the most recent location and status of all vehicles being tracked by the AVL system.
WebFeed	Contains a list of all feeds which are scheduled to be sent to the Web server. It also has the frequency of data collection, data source and target.

Other tables are used by the GUI processes to manage their operations. They include:

GUI Based Tables

Name	Description
Devices	Contains a list of all devices within CHART II, and their current status
Current Incident	Contains a list of all current incidents
IncidentDetail	Contains a list of events that happened within an incident
MapIcons	Contains a list of all icons currently on the map.
Links	Contains a list of all links within the system
FPU	Contains a list of all FPUs within the system
Closed-Incident	Contains al list of all closed incidents
Weather	Contains non-archived weather data
Message-Requests	Contains all requests made to change messages on devices
Alarms	Contains a list of all alarms generated by the system
UserLog	Contains a list of all actions performed by operators
Device Failures	Contains a list of all detected device failures.
Operators	Contains a list of all operators within the system, encrypted passwords and current access level
System Defaults	Contains a list of system-wide defaults set by the system administrator
Operator Defaults	Contains a list of display and action defaults selected by an operator