Financial Data Warehouse Based on Fact Constellation Liked Model
Ling Yuan · Journal of Wuhan University · 2012
The present situation of university financial system and data was analyzed.The financial data warehouse based on factual constellation model was designed,and the subset financial data on scientific research at the university formed the basic data for our experiment.We extract the key dimensions of financial data and construct corresponding dimensional tables.We also construct the fact tables for the main facts,including the accounts in financialdatabase.The attributes of these fact tables have corresponding key and metric value.A formal description for the establishment of the data warehouse was presented using data mining query language DMQL.