Query And Analysis Of BSSM's Alarm Logs Based On Date Warehouse

With the information technology developed with high speed and extending and applying steadily, telecommunications has made great progress in our country. Telecommunications is industry of high technology content, large scale and marked benefit, as well as data denseness. Mobile communication network includes four systems of switch, base station, transform and power, each one of them is composed of many equipments with different type and function, so the data of network management is very great. Faults management is an important and very difficult task in network, the key and difficult point of which is fault diagnoses that depends on the correlative knowledge especially in warning information and relating faults knowledge. The knowledge can be accessed from analysis of warning information. So the fault diagnosis is object of warning information analysis, and the process of which is necessary approach of fault diagnoses. Under situation of current service level and furious competition of network quality, only one analyzes data correctly provided by network management equipment to obtain useful knowledge can carry more advanced network maintenance and network optimization, lower rate of network faults, higher network quality.On the basis of warning information form CDMA BSSM(Base Station Subsystem Manager)of Nortel Networks which is equipment belongs to China Unicom Corporation Chongqing Branch and with references to appliance model of BSSM log management with BSSM network management System, this paper mainly researches query, statistic, analysis and application of BSM warning information with use of data warehouse and data mining.This paper deeply analyzes technology of data warehouse and data mining, with combination of analysis and application of data pretreatment, OLAP and characteristic of warning log, explores query of warning log in CDMA mobile communication, designs and realizes data warehouse architecture, data model, data pretreatment, operation and show of OLAP respectively with prototype system. Based on the constituted data warehouse, we do data mining research with analysis service function...