Ohio DPS Crash Database - Archived Data Management Functionality
Subsystem Description
The Archived Data Management Subsystem (ADMS) collects, archives, manages, and distributes data generated from ITS sources for use in transportation administration, policy evaluation, safety, planning, performance monitoring, program assessment, operations, and research applications. The data received is formatted and tagged with attributes that define the data source, conditions under which it was collected, data transformations, and other information (i.e. meta data) necessary to interpret the data. The subsystem can fuse ITS generated data with data from non-ITS sources and other archives to generate information products utilizing data from multiple functional areas, modes, and jurisdictions. The subsystem prepares data products that can serve as inputs to federal, state, and local data reporting systems. This subsystem may be implemented in many different ways. It may reside within an operational center and provide focused access to a particular agency's data archives. Alternatively, it may operate as a distinct center that collects data from multiple agencies and sources and provides a general data warehouse service for a region.
Functional Area: ITS Data Repository
Collect and maintain data and data catalogs from one or more data sources. May include quality checks, error notification, and archive coordination.
| ID | Requirement | Status |
|---|---|---|
| 1 | The center shall collect data to be archived from one or more data sources. | Existing |
| 2 | The center shall collect data catalogs from one or more data sources. A catalog describes the data contained in the collection of archived data and may include descriptions of the schema or structure of the data, a description of the contents of the data; e.g., time range of entries, number of entries; or a sample of the data (e. g. a thumbnail). | Existing |
| 3 | The center shall store the archived data in a focused repository that is suited to a particular set of ITS data users. | Existing |
| 4 | The center shall include capabilities for performing quality checks on the incoming archived data. | Existing |
| 5 | The center shall include capabilities for error notification on the incoming archived data. | Existing |
| 6 | The center shall include capabilities for archive to archive coordination. | Existing |
| 7 | The center shall support a broad range of archived data management implementations, ranging from simple data marts that collect a focused set of data and serve a particular user community to large-scale data warehouses that collect, integrate, and summarize transportation data from multiple sources and serve a broad array of users within a region. | Existing |
| 8 | The center shall perform quality checks on received data. | Existing |
Functional Area: On-Line Analysis and Mining
Advanced data analysis and mining features to support discovery of information, patterns, and correlations in large ITS archives.
| ID | Requirement | Status |
|---|---|---|
| 1 | The center shall support the interface with Archive Data User Systems for requests for analysis of the archive data. | Existing |
| 2 | The center shall provide the capability to perform activities such as data mining, data fusion, summarizations, aggregations, and recreation from archive data. This may include multidimensional analysis, selective summarization and expansion of data details, and many other advanced analysis services. | Existing |
| 3 | The center shall receive the user’s systems requests and develop the request to retrieve the data from the archive. | Existing |
| 4 | The center shall respond to users systems requests for a catalog of the archived data analysis products available. | Existing |