DSS Based On Data Warehouse And Its Application In Shaanxi Telecom

In order to operate the business conditions of 2008,and have a scientific prediction of company's development tendency in 2009,Shaanxi Telecom decides to let the data warehouse sector develop 09 business indicators.This paper introduces the relevant background and technical knowledge of the data warehouse, design and implement roaming state of some non-target statistics in a system of 09 performance indicators mobile voice part (call frequency, call duration, and natural talk time). Including ETL processes, stored procedure development, as well as the data warehouse to determine the relevant interfaces, and study their data warehouse infrastructure, including the logical architecture and network topology. Testing, analysis and improvement of work in the completion of development provide a guarantee of the ultimate on-line and stable operation for system.This design of the article achieves the desired design requirements, so that group's decision-makers can better grasp the company's development situation, timely institute development of strategic goals and business strategies, then well guide the company's development and bring new opportunities in enterprise development.