基于数据仓库的城市交通拥堵疏导数据管理

Data warehouse based data repository for urban traffic congestion management

从分析城市交通拥堵疏导管理决策中数据来源的多样性及异构性出发 ,为实现对各种数据和信息的汇总和综合 ,提出了城市交通拥堵疏导管理数据仓库的体系结构 ,探讨了该体系结构建立中的数据抽取与转换、元数据、中央数据库与数据集市、数据访问与分析等重要组成部分 ,并且 ,通过主题、维度、粒度及分割等概念的引入 ,着重研究了该数据仓库中的数据组织与数据模型的建立 ,从而为城市交通拥堵疏导管理决策提供一个统一。

In order to collect and integrate all kinds of data and information, based on analyzing the diversity and isomerous quality of the data resource in the decision making for urban traffic congestion management, an architecture of urban traffic congestion management data warehouse is proposed and the important components of the architecture are discussed. The components include data extraction and transformation, metadata, central data warehouse and data mart, and data access and analysis, etc. The data organization and data modeling of the data warehouse are investigated in detail. Thus, a uniform and integrative data environment is provided for the decision making of urban traffic congestion management.