Virtual Data Warehouse Services Functional Area

Send Your Comments

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

NMDOT Consolidated Highway Database (CHDB)
NMDOT Data Warehouse
NMDOT Highway Maintenance Management System (HMMS)
NMDOT SITE Manager
NMDOT Statewide Crash Information System
NMDOT Statewide Pavement Management System
NMDOT Statewide Transit Database
NMDOT TIMS
NMDOT Traffic Safety Division Data System

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.