基于实时操作数据存储的动态警情分析

J4 ›› 2009, Vol. 47 ›› Issue (6): 1255-1259.

基于实时操作数据存储的动态警情分析

张强¹, 姜占华², 张佳民²

1. 白城师范学院计算机系, 吉林白城 137000； 2. 吉林大学计算机科学与技术学院, 长春 130012

收稿日期:2009-03-10 出版日期:2009-11-26 发布日期:2010-01-07
通讯作者: 姜占华 E-mail:jiangzhanhua@sina.com.

Police Case Analysis Based on Realtime Operational Data Store

ZHANG Qiang¹, JIANG Zhanhua², ZHANG Jiamin²

1. Department of Computer, Baicheng Normal College, Baicheng 137000, Jilin Province, China;2. College of Computer Science and Technology, Jilin University, Changchun 130012, China

Received:2009-03-10 Online:2009-11-26 Published:2010-01-07
Contact: JIANG Zhanhua E-mail:jiangzhanhua@sina.com.

摘要/Abstract

摘要：

通过监控公安业务系统日志, 从业务系统日志中实时抽取细节数据到操作数据存储, 实现操作数据存储与业务系统的秒级实时同步, 建立基于“日志操作数据存储数据仓库”三层体系结构的公安数据仓库, 基于即时在线联机分析查询、操作数据存储的多维数据集动态更新和数据集市的多维数据集, 提供即时在线联机分析服务. 实验结果表明, 该动态数据仓库能够提供实时警情决策分析, 并且具有对业务系统负荷小、实时性强、访问效率高等特点, 较好地满足了公安系统对实时性的要求.

关键词: 操作数据存储, 数据仓库, 在线联机分析, 数据集市

Abstract:

Through realtime monitoring police system log, the detail data of operational data store ODS are realtime elicited from system log to ODS, meanwhile this mechanism synchronizes the ODS data and business system database in second grade. Realtime ODS based mechanism establishes a LogODSDW threelevel model Police DW system, realtime OLAP based query, the cubes of ODS and DW fresh data dynamically, serving realtime OLAP service. The authors put forward a dynamic DW infrastructure which can offer realtime police decision analysis with the features of little burthen on business system, real time, rapid query and meet a need of police system.

Key words: operational data store (ODS), data warehouse (DW), online analytical process (OLAP), data mart

中图分类号:

TP311.13

张强, 姜占华, 张佳民. 基于实时操作数据存储的动态警情分析[J]. J4, 2009, 47(6): 1255-1259.

ZHANG Qiang, JIANG Zhanhua, ZHANG Jiamin. Police Case Analysis Based on Realtime Operational Data Store[J]. J4, 2009, 47(6): 1255-1259.