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