Virtual Data Warehouse Services Functional Area

Description

Provides access to data from geographically dispersed archives and coordinates information exchange with a local data warehouse. Also provides the specialized publishing, directory services, and transaction management functions associated with coordinating remote archives.

Included In

TxDOT Austin District Historical Traffic Database
TxDOT Austin District Pavement Management System
TxDOT Austin District Public Transportation Management System (PTMS)
TxDOT Austin District Roadway Data Collection System
City of Austin Pavement Management System
City of Round Rock Pavement Management System
Capital Area MPO Archive
City of Austin Crash Records Database
City of Round Rock Crash Records Database
City of Austin Traffic Database
Municipal Traffic Database

Functional Requirements

IDRequirement
1The center shall provide capabilities to access "in-place" data from geographically dispersed archives. These capabilities may include analysis, data fusion, or data mining.
2The center shall coordinate information exchange with a local data warehouse.
3The center shall provide the specialized publishing, directory services, and transaction management functions associated with coordinating remote archives.
4The 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.)
5The 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.
6The center shall provide the local archived data schema to other archive systems.