Data Warehouse Application On Telecommunication Company Of Guiyang

The data warehouse is a distributed different kind of more excellent solution of constructing system integration of database , it related to the fact that use in the data warehouse data process draw, change, filter in advance each information source, And other data carry out amalgamation with corresponding data source, leave a central data base in according to the theme, Because the data have solved the conversion of different data models in the central data base, conversion of different database languages, Complicated problems, such as different conversion that show, etc., have unified modes, unified data, so to distributed to construct data complicated visit of source turn into and go on simple operation that inquire about impromptu at database directly while being different originally. This kind of method is especially suitable for the 1. The customer needs some appointed information; 2.Users need to inquire about fast; 3.The application in this environment needs high performance; 4. Users need to visit the information that the information source can't be kept for a long time. The requests of this and DSS are unanimous basically, just because of this, the warehouse technology of the data is used widely at first in DSS .The construction of the data warehouse of enterprises, is based on accumulation of existing enterprise's business system and a large number of business data. The data warehouse is not a static concept , only assign information to the user who need the information in time, support them make and improve their business deal decision, the information could function ,the information is meaningful . So put information in order and sum up and recombinate , then offer to corresponding management policy-makers in time, it is a basic task of the data warehouse .The article have analysed the subject matter of basic conception of the data warehouse and present research and some research results in detail in this thesis, having analysed the warehouse technological development trend of the data, and the applicationes in telecommunications of Guiyang, etc., have introduced telecommunications of Guiyang and utilize warehouse technology of the data to build the statistical analysis system of the business decision and design the situation in detail, technological route, solution, etc., At the same time according to the reality of Guiyang telecommunication put forward a solution of medium and small scale telecommunication service operation datum warehouse and a new thought of telecommunication enterprise subject analysis and its application situation of Guiyangtelecommunication.