CAJ | 학술논문

通过监控公安业务系统日志, 从业务系统日志中实时抽取细节数据到操作数据存储, 实现操作数据存储与业务系统的秒级实时同步, 建立基于"日志-操作数据存储-数据仓库"三层体系结构的公安数据仓库, 基于即时在线联机分析查询、操作数据存储的多维数据集动态更新和数据集市的多维数据集, 提供即时在线联机分析服务. 实验结果表明, 该动态数据仓库能够提供实时警情决策分析, 并且具有对业务系统负荷小、实时性强、访问效率高等特点, 较好地满足了公安系统对实时性的要求.
통과감공공안업무계통일지, 종업무계통일지중실시추취세절수거도조작수거존저, 실현조작수거존저여업무계통적초급실시동보, 건립기우"일지-조작수거존저-수거창고"삼층체계결구적공안수거창고, 기우즉시재선련궤분석사순、조작수거존저적다유수거집동태경신화수거집시적다유수거집, 제공즉시재선련궤분석복무. 실험결과표명, 해동태수거창고능구제공실시경정결책분석, 병차구유대업무계통부하소、실시성강、방문효솔고등특점, 교호지만족료공안계통대실시성적요구.
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.