Impact of business intelligence on incident management in the control center of a security company

The main objective of this article is to implement business intelligence (BI) technology to improve incident management in the control center of a security company; making use of the Ralph Kimball method for the development of the data mart, contemplating the phases: planning of projects, definition of requirements, design of technological architecture, performing a dimensional modeling a star with 9 dimensions and 1 table made, also used the structured query language (MySQL) database, extract, transform, and load (ETL). Development the pentaho data integration, which allowed the migration, transformation and cleaning of the data from the online transaction processing (OLTP) and online analytical processing (OLAP) database, obtaining as a result that the BI managed to increase the level of the service by 28.42% and reducing the frequency index by 25%.本文的核心目标为部署商业智能（Business Intelligence, BI）技术，以优化某安防企业中控室的事件管理流程。本研究采用拉尔夫·金博尔（Ralph Kimball）方法开展数据集市（data mart）的开发工作，涵盖项目规划、需求定义、技术架构设计等实施阶段，并构建了包含9个维度与1张事实表的星型维度模型；同时采用基于结构化查询语言（Structured Query Language, SQL）的MySQL数据库，以及抽取-转换-加载（Extract, Transform, Load, ETL）流程。本次研究开发的Pentaho数据集成工具，实现了联机事务处理（Online Transaction Processing, OLTP）与联机分析处理（Online Analytical Processing, OLAP）数据库中数据的迁移、转换与清洗工作。最终结果显示，该商业智能系统将服务水平提升了28.42%，并将事件频次指标降低了25%。