Oracle-based Data Warehouse Technology In The Telecommunications Industry

Data warehouse technology originated from and go on need that dispose of a large number of data, emerge in pace with need that the business uses. Compared with traditional data base technology, data warehouse offer a kind support for making decision and analysis,Jump out category that deal with traditional OLTP. So in recent years, data warehouse technology develop very quickly, and has got application in varios trade.Along with the breaking of the monopolize pattern the competition among the domestic telecommunication operators is fiercer and fiercer, and difference of network service quality, et c. reduce gradually too. Simple Warrior of price cause demage to both sidesin competition. So telecommunication enterprise are seeking method of improving service quality and raising market competitiveness. Faced with the fiercer and fiecer market competition telecommunication enterprise need improving science decisionability urgently, Strengthen correct judgement in such aspects as market management, so telecommunication operator need warehouse technology.On the other hand, telecommunication enterprise has accumulateda large amount of business running data, these are all electronicdata,a lot of valuable information can be found from these user data. for example, consumer behavior of user analyse feature. According to these consumer behavior feature, market department canoffer stronger pertinence tactics for market service, And has economized the cost of the marketing. So a large number of electron data of telecommunication enterprise build data warehouse establishing the technological foundation.At first, this text has explained the background of the article, the application trend of data warehouse, the purpose and content of the research. Second, data warehouse including the concept, the characters and the critical technology of data warehouse is analysed. The System Of Communicate Quantity Analysed that include the construct scheme, the construct programming, the data warehouse platform and the design of the theme analysis is introduced. Then the warehouse ETL process by Oracle Warehouse builder is detailed . Finally the construction status is summurized.