| The construction of data warehouse is in order to satisfy the commodity exchange demands for transaction data query,analysis and so on.The whole process can be described specifically as following: on the basis of the member service system transaction,settlement system and market monitoring system,after conversion and processing of business data,and displaying the data in a multi angle,flexible and rich style,then form a complete a complete data sharing platform,so as to improve the degree of coordination between different departments.This paper mainly based on data warehouse as the theme,discusses may encounter problems in the process,in particular to a data warehouse research needs,the design of data warehouse model,the pumping data,conversion and loading,data loading algorithm,ETL scheduling design and so on.The purpose is to reflect the full construction process of data warehouse,and the specific function of each hierarchy depth of understanding in the warehouse,finally satisfy the Commodity Exchange's data warehouse reporting requirements,using IBM Cognos will conduct a variety of business KPI indicators show the Commodity Exchange's data.Mainly I do the work is the data extraction and query.Extracted makes the data save in the form of files from the source system database,and the data files by extracting process through FTP upload to ETL server;Query is according to the exchange of business data query and analysis of demands,filtered The extracted data in SQL language according to demand,packaged the available data,and using Cognos and Framework tools makes self-service query report forms,for business personnel data query,and provide decision-making information for decision makers more intuitive to the current problems and prospects.Through the analysis of the data,the Commodity Exchange's can adjust the business and new business development.Through this process,we can find the data warehouse plays a major role in the financial sector. |
PDF Full Text Request