A dynamic multi-subject data warehouse establishment method based on hot rolling production process

Abstract

The invention provides a dynamic multi-theme data warehouse building method based on a hot continuous rolling production process. The dynamic multi-theme data warehouse building method based on the hot continuous rolling production process comprises the following steps of extraction of service data, visualized analysis of the service data, spiral and dynamical building of a data warehouse and on-line analysis processing. According to the service requirement, based on visualized analysis of the data, a user autonomously and dynamically builds an analysis dimension and an analysis theme, and carries out analysis excavation in the multi-theme data warehouse. According to the characteristic of a large data quantity of the hot continuous rolling production process, the visualized analysis method is provided, the user can observe the data characteristics and select valuable data, the problem of the blind requirement when a user faces mass data is solved, multi-dimensional and multi-theme excavation is dynamically built based on the production process, the requirements for on-site data completeness and efficiency of data warehouse management are met, and the continuously developing service requirement is met. The dynamic multi-theme data warehouse building method based on the hot continuous rolling production process is also applicable to building of a warehouse of process production data in the industrial field.

Description

technical field [0001] The invention relates to the fields of hot continuous rolling production and data warehouses, in particular to a method for establishing a dynamic multi-subject data warehouse based on hot continuous rolling production processes. Background technique [0002] The hot rolling production process is accompanied by a large amount of engineering data such as design, experiment, commissioning, and on-site production, as well as a large amount of system installation and commissioning experience and knowledge. These data are important reference materials for production line design, construction, and rolling model development research. Long-term Since these data have been scattered and stored, they have not been systematically sorted out, let alone analyzed and utilized effectively. Therefore, it is an urgent task to establish a basic database of rolling models and organize, manage and effectively utilize related information resources. [0003] For the technica...

AI Technical Summary

Problems solved by technology

The multi-dimensional and multi-theme data warehouse is built on the basis of massive data, and a large amount of data will block the data channel and hinder users from conducting business analysis. However, there is huge analytical value in these data, so it is necessary to store these important data reasonably and effectively

Images