Data model management method, device and equipment

Abstract

The embodiment of the invention provides a data model management method, device and equipment. The management method comprises the steps that a logic model corresponding to a data warehouse is acquired; when the structure of the logic model is changed, determining a first physical model corresponding to the logic model before the change; and managing the first physical model based on the structure change operation corresponding to the logic model to obtain a second physical model corresponding to the changed logic model. According to the technical scheme provided by the embodiment of the invention, when the structure of the logic model is changed, a change statement does not need to be manually generated to adjust the structure of the physical table, and the physical model can be automatically managed based on the structure change operation generated by the logic model, so that the physical model corresponding to the changed logic model is obtained; in this way, the user can be helped to automatically implement the logic model to the physical model, so that the development workload of the physical model is reduced, and the requirement for frequent model change in an application scene can be met.

Description

technical field [0001] The invention relates to the technical field of data warehouses, in particular to a data model management method, device and equipment. Background technique [0002] The data model is to use a structured language to comprehensively analyze the collected data requirements used in the operation, management and decision-making of organizational scenarios, and to reorganize the requirements according to the model design specifications. From the perspective of the content granularity covered by the model, the data model can generally be divided into subject domain model, conceptual model, logical model and physical model. Among them, the subject domain model is the highest level and is basically composed of subject concepts and the relationship between them. The unit model, the theme is the high abstraction of the concept of data expressing the essence of things; the concept model is a model based on data entities and the relationship between them, and the ...

AI Technical Summary

Problems solved by technology

In the actual development process, the logical model often connects to multiple physical storage systems. However, in the development stage of the data model, the structure of the logical model may change frequently, such as: adding fields, modifying fields, deleting fields, and modifying table names etc. Each change requires the user to manually generate a change statement to adjust the physical table structure, which is not only cumbersome and repetitive, but also, with the continuous increase of application scenarios and application data, the workload will also increase synchronously

Images