NYSDOT Home New York State Department of Transportation
Site Index Telephone Numbers E-Mail NYSDOT Publications Search NYSDOT
Regional Architecture Logo
 

Send Your Comments

E-Mail

Virtual Data Warehouse Services Equipment Package

Architecture Geographic Scope

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:

CDTA Transit Archive
CDTC Planning Archive
City of Albany/City of Schenectady/Local TMC Archive
NYS DMV Accident Reporting System
NYSDOT Region 1 TMC Archive
NYSTA ATMS Archive
NYSTA Traffic Count Systems

Processes:

8.4Coordinate Archives
  

User Service Requirements (fully or partially addressed):

7.0INFORMATION MANAGEMENT
7.1ARCHIVED DATA FUNCTION
7.1.0ITS 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.4ADHA shall be capable of supporting user-specified data archiving procedures as follows:
7.1.5The 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.1DWD 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.2DWD shall include a User Data Products (UDP) function.
7.1.5.2.3UDP shall be capable of providing user defined data mining functions on ITS data sources.
7.1.5.2.4UDP shall be capable of performing user defined data fusion functions on data extracted from ITS Archives.
7.1.6The 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.2ICI shall manage user access and security across the interface.
7.1.6.2.2ICI shall be capable of cleansing data to remove source privacy attributes before exporting data to users.
7.1.6.3ICI shall provide a user-interface functionality to existing data warehouse data schema for users to define their data products.
7.1.6.3.1The user-interface shall permit users to define access to multiple databases as data sources for their data products.
  
The detailed process and user service requirement traceability information on this page was extracted from the National ITS Architecture. Consult the National ITS Architecture web site for more information.
Last Update: 09-15-2003