Multi-bin modeling method and system for ceramic production line

The invention aims to provide a data warehouse modeling method for a ceramic production line. The method comprises the following steps: dividing an original data layer, a detail data layer, a wide table data layer and a data application layer according to a data warehouse division mode; wherein the detail data layer comprises a detail theme layer and a dimension data layer; storing original data of ceramic production to the original data layer; taking a ceramic production process as a theme, and establishing a theme model table on the detailed theme layer; constructing a data analysis dimension table in a dimension data layer according to the general and common dimensions and the dimensions required by the data application layer; performing correlation analysis on the topic model table and the data analysis dimension table, and constructing a production flow wide table which is connected with the whole ceramic production process in series in a wide table data layer; and performing association ...