Design And Implementation Of Business Reporting System In Securities Company Base On Data Warehouse Technology

The securities industry has IT systems,more complex information source,high degree of dependence on data statistics analysis of the characteristics.The traditional collection of statements,statistical way of these drawbacks,great drag on the development of the securities business of the company as a whole.In order to meet the needs of this development,solve the problems in the use of statistics report mode,need to design a set of reporting system solutions.This article attempts through the model based on data warehouse is a kind of solution to provide a solution for this problem.First of all,refine the original data report mode to the source data integration model data index statements.Through data warehouse ETL tools as a scheduling tool,the data from each securities firm in the different times background,in the face of different application developers,such as various kinds of objective premise to establish various business system integration to the data center,formed the reporting system data base.Then,introduced the business logic layer,increase the concept of index,transforming the reporting requirements for the selection of index,the report needs a granular,parent-child relationships between quantitative indicators can be degrees,at the time of the ETL process scheduling according to the index calculation priority to complete each layer between the index of calculation and save.Then,the needs of the business report will from the business department of the literal description,into a business for both the choice of indicators and statistics on the targets of the new requirements.Index and index between the check for the existence of the business logic layer becomes very convenient also,reducing the previous reporting needs the most trouble caused by the different report checked the rework Improve the working efficiency and demand response speed.Under the control of the entire report system in ETL scheduler,regularly collect data from various systems,and according to the different dimensions of statistical indicators,again the report according to the date form each time Fully reflects the data warehouse oriented thematic data integration of data when degeneration,nonvolatile characteristics of data.