Design And Realization Of The Market Analyse System Based On Data Warehouse Technology

With the constant enlargement of the range of application of computer, the technology of the database has been used and developed greatly, people try data in database (DB) is it reprocess to go on, form a comprehensive one, face environment that analyze, with easy to support decision analyze, form the warehouse technology of datum (Data Warehousing, abbreviated as DW). The domestic telecommunication operator and in a good position in the fierce market competition day by day the modern market environment that adapts to regarding customer as the centre. Need big time carry on reform and optimize in such aspects as institutional framework, management mode, management system, management not merely, in the lead, but traditional database use system to face business is it design to operate than rival at market tactics, on the middle and senior level leader in enterprise analyze decision help strong. This page purpose of thesis is it builds one-face systems of the policy-making level to lie in. This Paper has introduced the technology, such as data warehouse, ASP.NET, XML, etc. at first; Direct against data warehouse design process and key technology issue among them if datum integrated, have displayed etc. and probed into and provided the solution in detail. To the market competition current situation of mobile communication trade, a large amount of historical data accumulated in order to utilize the mobile communication company for a long time effectively, the thesis structures a market analytical system based on datum warehouse, according to the characteristic based on theme of data warehouse, at first through demand analyze confirm theme land, analyze to the source data list structure that understands, have carried on model design, grain size level dividing , storehouse form structural design of the system structure of the data warehouse ,etc. sequentially, and prove emphatically in several key parts of the data warehouse , have represented the construction course of this data warehouse platform from the technological level: If source file handling , data change, is it deal with to upgrade, data collect, data display and follow-up punish. Adopt ASP.NET technology structure dynamic webpage in realizing in system, is it use personnel can choose to analyze the function through interface conveniently to make, the analysis result trends show with the chart; And has fully utilized treatment technology of running side by side, has considered the loss which sets up the index and resource proportionally, make systematic efficiency be optimized. Pass the imperial examinations at the provincial level several systematic example of practical application in thesis, if customer state analysis, income analysis, conversation situation analysis, is it transfer to situation analysis, rival analyze etc. to breathe out, having proved the system through the actual inspection of market analysis personnel, the analysis conclusion drawn from it is accurate, can be believed, and because of is it with chart, it makes to be very clear to analyze person, can catch the focal point easily to mix, have convincingness even more as to policy-making level of enterprises. System produce high benefit relatively already at present, can is it grasp message, consumption situation of customer in real time to realize easily through it, turn from enterprise policymaker to network analysis monthly demand of conclusion into and require that analyses rival's situation every day, draw occupation rate of market key index can know system become market important basis source of decision already, so, the realization of this project has greater actual meaning.