Equipment Package: Virtual Data Warehouse Services
Description:
This equipment package provides capabilities to access "in-place" data from geographically dispersed archives and coordinate information exchange with a local data warehouse. While many of the functions performed by this equipment package are similar to the functions inherent in other archived data management subsystem equipment packages (e.g. data management, fusion, analysis) this equipment package also provides the specialized publishing, directory services, and transaction management functions associated with coordinating remote archives. In addition, this equipment package performs functions on an as-needed basis, thereby negating the need to maintain the comprehensive set of data from the remote archives in the local data warehouse.
Included In:
MPO Data Collection and Reporting System
MTO Collision Database
MTO Compass
MTO Traffic Volume Database
NITTEC TOC Archive Management System
NYS DMV Accident Reporting System
NYS Safety and Accident System
NYSDOT Bridge Management System
NYSDOT Infrastructure Restrictions Database
NYSDOT Main Office Highway Data Services
NYSDOT Main Office PPMIS
NYSDOT Transit Data Archive
NYSTA Infrastructure Inventory and Inspection System
NYSTA Statewide Operations Center Archive Management System
NYSTA Traffic Data Storage and Retrieval System
RMN Collision Database
RMN Traffic Volume Database
General Functional Requirements
1 -
The center shall provide capabilities to access "in-place" data from geographically dispersed archives. These capabilities may include analysis, data fusion, or data mining. 2 -
The center shall coordinate information exchange with a local data warehouse. 3 -
The center shall provide the specialized publishing, directory services, and transaction management functions associated with coordinating remote archives. 4 -
The center shall support the collection of archived data from other archives on an as-needed basis. (This minimizes the need to duplicate the comprehensive set of data from the remote archives in the local data warehouse.) 5 -
The center shall use data collected from different archives to build a set of global schema including the data archive definitions for the local archive plus any archives known to the local archive. 6 -
The center shall provide the local archived data schema to other archive systems.
