Research On The Application Of Data Warehouse To Analysis Of Stock

With the investors' attaching more importance to the analysis of investment and developing of modern technology of computer, DSS has been used in securities business to some extent. Traditional DSS has its deficiencies compared with the DSS based on DW. It is very difficult to develop a perfect human-machine interface and make more interactive between man and model for traditional DSS. The DSS based on DW, OLAP and DM is a new form for DSS. A DW is a subject-oriented, integrated, time variant, nonvolatile collection of data in support of management's decision-making process. OLAP is a kind of interactive tool that can provide precise views of enterprise original data rapidly. Through it analysts can analyze the data quickly without programming.Securities business has relative sound OLAP systems and each security company has accumulated a large number of data. Utilizing these data to provide factual reflection of the security company and strengthen competitive advantages has become the tendency of Securities business. DW can strengthen internal management and surveillance, specialize the consulting service and aid manager to make decision. This thesis puts forward a model of aided DSS for analyzing stock, builds a DW and a query program. Aided DSS based on DW has advantages of integrated and precise data, flexible analysis, varied accessing and si .iple maintenance. There are several issues that we should pay attention to when we build DW. They are stability of data source, usability of data and DW system. This thesis builds cube of the dealing sheet, cube of the balance sheet and cube of the profit and profit appropriation statement. The thesis adopts star schema which can simplify query .The thesis mainly uses the program named transform and tool of DTS provided by Microsoft to create new fields in tables of source data and transform these tables to MS SQL Server.