|
|
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: |
Hudson Valley Traveler ITS Operators Operational DB
Long Island ITS Operators Operational DB
NYC ITS Operators ITS Data Archive
NYMTC Member Agencies Data Collection Systems
NYMTC/DCP Regional Planning Database
TRANSCOM Archived Data Management System
|
| Processes: |
8.4 - Coordinate Archives
|
| User Service Requirements: |
7.0 -
INFORMATION MANAGEMENT
7.1 -
ARCHIVED DATA FUNCTION
7.1.0 -
ITS shall provide an Archived Data Function to control the archiving and distribution of ITS data. The Archived Data User Service provides the Historical Data Archive Repositories and controls the archiving functionality for all ITS data with five major functions: 1) the Operational Data Control function to manage operations data integrity; 2) the Data Import and Verification function to acquire historical data from the Operational Data Control function; 3) the Automatic Data Historical Archive function for permanently archiving the data; 4) the Data Warehouse Distribution function, which integrates the planning, safety, operations, and research communities into ITS and processes data products for these communities; and 5) the ITS Community Interface which provides the ITS common interface to all ITS users for data products specification and retrieval. ADUS helps achieve the ITS information goal of unambiguous interchange and reuse of data and information throughout all functional areas.
7.1.4.4 -
ADHA shall be capable of supporting user-specified data archiving procedures as follows:
7.1.5 -
The Archived Data Function shall provide a Data Warehouse Distribution (DWD) function as the ITS data source to support the ITS community user functions.
7.1.5.1 -
DWD shall be capable of supporting the generation of data products for the following transportation agencies:
7.1.5.1(a) -
Planning
7.1.5.1(b) -
Operations
7.1.5.1(c) -
Safety
7.1.5.1(d) -
Research
7.1.5.2 -
DWD shall include a User Data Products (UDP) function.
7.1.5.2.3 -
UDP shall be capable of providing user defined data mining functions on ITS data sources.
7.1.5.2.4 -
UDP shall be capable of performing user defined data fusion functions on data extracted from ITS Archives.
7.1.6 -
The Archived Data Function shall provide users with an ITS Community Interface (ICI) including all ITS users for the specification and retrieval of data products.
7.1.6.2 -
ICI shall manage user access and security across the interface.
7.1.6.2.2 -
ICI shall be capable of cleansing data to remove source privacy attributes before exporting data to users.
7.1.6.3 -
ICI shall provide a user-interface functionality to existing data warehouse data schema for users to define their data products.
7.1.6.3.1 -
The user-interface shall permit users to define access to multiple databases as data sources for their data products.
|
Last updated: 11-02-04 |
