Send Your Comments

Virtual Data Warehouse Services Equipment Package

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:

BUS Transit Planning System
Cameron County Congestion Management System
Hidalgo County Congestion Management System
Lower RGV Development Council Transit Planning System
Lower RGV MPO Transportation Data Archival System
Rainbow Lines Transit Planning System
The Wave Transit Planning System
TxDOT Pharr District Transportation Operational Data Archive
TxDOT/DPS Crash Record Information System

Processes:

8.4	Coordinate Archives

User Service Requirements (fully or partially addressed):

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.

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 updated on 07-16-2003 using Ronald C. Ice and Associates Web Spinner Technology.