Cube fragment shell algorithm applied in financial warehouse

The financial data of institution of higher education relates to a lot of subjects.Financial data warehouse is a typical kind of high dimensional data warehouse,and its character determined that the users need the accurate information.All these restrict the data cube pre-compute algorithm that can be used in financial data warehouse.The characters of popular data cube precompute algorithms were introduced,and then a fact constellation liked data model of scientific research financial data warehouse was designed,which is a subset of financial data warehouse.Based on the analysis of some data cube pre-compute algorithms,the cube shell and cube fragment shell algorithms were used to implement the data warehouse.The performance compare analyses based on pre-compute time,storage and OLAP efficiency were applied.These analyses proved that the cube fragment shell algorithm can get a balance on these aspects and it is suitable for financial data warehouse.