Data standardization construction method and system of data warehouse

The invention discloses a data standardization construction method of a data warehouse. The method include 1, acquiring source data tables for the data warehouse standardization construction; 2, splitting the source data tables into one fact table mainly containing N metrics and M dimension tables; 3, splitting the dimension tables split and stored in Cartesian products into dimension tables corresponded to multiple single dimensions; 4, establishing a star-shaped connecting network on the basis of the relationship of the generated fact table and dimension tables, and allowing the data warehouse to have the star-shaped structure relationship database after the data standardization. Each source data table includes M records about dimensions and N records about metrics, and the M and N are integers larger than zero. The invention further provides a data standardization construction system of the data warehouse.