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

Police Case Analysis Based on Real-time Operational Data Store

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

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. Real-time 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.