摘要
利用数据仓库技术,可以提高交通管理部门的违章事件管理能力。由于当前对提高违规管理能力的实际需求,根据数据仓库的多维建模理论,可建立基于星型模式数据仓库交通违章分析系统TVAS(包括维表与事实表的设计,ETL及调度),并以SQL方式进行违章分析、违章预测等。
Data warehouse technology improves the ability against violations. In line with the theory of multi-dimensional modeling of the data warehouse, creates a system based upon the data warehouse with star-schema,known as TVAS （i. e. Traffic Violations Analysis System） （including the design of the dimen-sion tables,fact tables,ETL and scheduling） ,and finally illustrates in a SQL mode the solutions to a range of issues concerning violation analysis and violation prediction as well.
出处
《福建警察学院学报》
2012年第4期50-54,共5页
Journal of Fujian Police College
关键词
数据仓库
多维度建模
星形模式
TVAS
违章分析
违章预测
data warehouse
multi-dimensional modeling
star-schema
TVAS
violation analysis
viola-tion forecast
