| 交通违章分析系统TVAS的设计与实现 |
| |
| 引用本文： | 刘凯.交通违章分析系统TVAS的设计与实现[J].福建公安高等专科学校学报,2012(4):50-54. |
| |
| 作者姓名： | 刘凯 |
| |
| 作者单位： | 福州市公安局台江分局瀛洲派出所,福建福州350009 |
| |
| 摘 要： | 利用数据仓库技术,可以提高交通管理部门的违章事件管理能力。由于当前对提高违规管理能力的实际需求,根据数据仓库的多维建模理论,可建立基于星型模式数据仓库交通违章分析系统TVAS(包括维表与事实表的设计,ETL及调度),并以SQL方式进行违章分析、违章预测等。
|
| 关 键 词： | 数据仓库 多维度建模 星形模式 TVAS 违章分析 违章预测 |
Design and Implementation of Traffic Violations System |
| |
| LIU Kai.Design and Implementation of Traffic Violations System[J].The Study of Social Public Security,2012(4):50-54. |
| |
| Authors: | LIU Kai |
| |
| Institution: | LIU Kai(Ninghua Police Station,Fuzhou Public Security Bureau Taijiang Branch,Fuzhou 350009,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | data warehouse multi-dimensional modeling star-schema TVAS violation analysis viola-tion forecast |
| 本文献已被 CNKI 维普 等数据库收录！ |
