Application Of Data Warehouse Technology For Securities Company

With the financial system reform go fast in China, especially after China became a member of WTO, the China securities market is influenced deeply by globalization and financial industry intersection, the competition in securities industry is getting more and more rough. At the background, how to analyze the operation status of company promptly and effectively; How to make client classification and provide customized service to clients; How to improve client loyalty and attract new clients; How to effectively analyze and reduce client loss; How to forecast the trend of stock market and improving its competitiveness in the whole securities market, etc. has become the urgent demand in current stage of securities industry.Targeting at these demands, the author had paid thorough analysis to the features of IT adopted by securities company at this stage and the features of data in current stage, considering the development of data warehouse technology in domestic and overseas and its application in domestic companies, the author had suggested the system design idea of setting up data warehouse in securities industry and application of data mining technology to securities industry.This thesis had first illustrated the basic idea of data warehouse technology, OLAP technology, data mining technology and the process to realize these technologies. Then, this thesis had analyzed current demand from the securities companies and the feature of existing data, designed the granularity model, dimension model, system structure and function module of data warehouse for securities companies. The author had detailed demonstrated the designing and realizing of multi-dimension dataset, data conversion module, manage and control module, multi-dimensional analysis module, demonstrated the analysis result to client terminal with the example of client transaction analysis. So to provide quick and effective reports and analysis to the decision makers of securities companies in multiple aspects, and upgrade the company's market reaction speed and competitiveness.In the end, in order to further explore deeper information and rules hidden in large quantity of history data, this thesis had applied data mining technology into securities industry. This thesis had mainly analyzed associated data mining model, which is not supplied in Analysis Services of Microsoft SQL Server 2000, Firstly, we carry out pre-process to current data of securities industry and realize the classic Apriori data...