Data warehouse visual modeling method and device and medium

Abstract

The invention relates to a technical scheme of a data warehouse visual modeling method and device and a medium, and the method comprises the steps: global planning: enabling a data warehouse for business to create a business data bus from the top to the bottom; data introduction: configuring a corresponding project space and a physical data source according to the service data bus based on the global planning; specification definition: constructing a visual data model according to the service data bus and a physical data source; and visual analysis: performing visual display on the distribution and details of the data source through a visual interface. The method has the beneficial effects that based on the enterprise dimension, the business process, the atomic index and the derived indexwhich are defined according to the specification, the development dimension table, the fact table and the summary table are further refined through automatic codes; an enterprise data warehouse modelis generated, data application of business layering is facilitated, and meanwhile calculation and storage are optimized; data is rich and fused, and thematic service is more intelligent.

Description

technical field [0001] The invention relates to the field of computers, in particular to a data warehouse visualization modeling method, device and medium. Background technique [0002] In the case of rapid data growth, enterprises are faced with more data problems: data is not unified, calculation logic is inconsistent; data is not connected, and the phenomenon of isolated islands is serious; source system or business changes are out of sync with data, resulting in difficulties in maintenance; repeated construction leads to data timeliness The performance is poor; the data processing is intricate, and few people can clearly remember the processing process of the left and right fields, and the blood relationship of the data is nowhere to be found. [0003] Because there are many business systems and data sources, the data requirements required for business operations are frequent and diverse. However, the data system is complex, the data is not unified, the speed of data an...

AI Technical Summary

Problems solved by technology

[0002] In the case of rapid data growth, enterprises are faced with more data problems: data is not unified, calculation logic is inconsistent; data is not connected, and the phenomenon of isolated islands is serious; source system or business changes are out of sync with data, resulting in difficulties in maintenance; repeated construction leads to data timeliness Poor performance; data processing is intricate, few people can clearly remember the processing process of the left and right fields, and the blood relationship of the data is nowhere to be found

However, the data system is complex, the data is not uniform, the speed of data analysis and the accuracy and consistency of data are difficult to guarantee, and strategic decision-making and data-based operations are hindered

The existing data processing technology cannot quickly process a large amount of intricate business data; there is no standard definition for data modeling, which leads to different processing methods for different modelers; the more complex the data, the more difficult the data processing is, resulting in data processing threshold and cost Often high and inefficient, low reusability

Images