Design and Implementation of a Data Parsing Module for Power Information Equipment Log Management System

Yi Ting Zhang,Bin Wang,Zhi Hui Zhang
DOI: https://doi.org/10.4028/www.scientific.net/amr.765-767.1092
2013-01-01
Advanced Materials Research
Abstract:in order to manage the log information of Windows servers, Linux servers, network devices and security devices in a unified, so as to query log data, analysis and audit log data conveniently, a program is put forward, in which a variety of power system information devices log data be converted into a unified relational model and integrated into the database. The data parsing module uses the Windows Workflow procedure to select, clean and merge the massive log data. The database is created and operated by Microsoft SQL Server 2005 development platform. All of the log files have to be converted into a unified format and saved in centralized storage. Experiments and test results show that the module has a good efficiency of data processing and integration, and it greatly increases the proportion of valid data. It provides supports for efficient log auditing and fault diagnosis in the future.
What problem does this paper attempt to address?