| There is very difference between the Traditional DB and Data Warehouse. The Traditional DB succeeds in OLTP but can' t satisfy the managers' decision-making and analysis. By contrast, Data Warehouse can do it quite well. At present, domestic telecom industry has no perfect system of Data Warehouse, let alone its entire standard.In recent year, information technology has been applied diffusely in telecom industry. Lots of history data has been accumulated according to the use of computer application systems, such as Operating Network System, Integrated Service System, Statistic Fee System, OA System, etc. In traditional conditions, however, large amount of data can' t be turned into useful information for decision-making. OLTP system becomes inflexible because of the lack of detailed data and systematic resource can' t meet the need of business. On the other hand, managers and decision-makers can' t adapt to violent competition because they only get limit information according to the OLTP system. Therefore, Data Warehouse meets the trend.First of all, this article analyzed development and application of Data Warehouse, organization of data, and pivotal techniques, moreover, offered the general construction method of Data Warehouse application system in relation to SAS Data Warehouse. At last, it supplied an example of application to Data Warehouse that named A System of Decision Sustainer and Market Analyzer, and discussed the requirements, design, and implement of the system. Especially, it analyzed detailedly the needs of telecom industry, too.The System of Decision Sustainer and Market Analyzer constructed a fine Data Warehouse application. It can accomplish Rotate, Slice, Drill up/down operation in Data Cube, and all kinds of analysis or predict. At the same time, the system also has some new functions, including to do some basic statistics by usingSlice-Data straightly, to create the results to txt or HTML document expediently which is convenient for managers' reports, and so on. |
PDF Full Text Request