The invention particularly relates to a hierarchical
data model design and generation method and
system. According to the hierarchical
data model design and generation method, firstly, a
conceptual model is designed, and entities and relationships are constructed; storing the
conceptual model, and generating an initial framework of the logic model on the basis of the structure of the
conceptual model; performing logic model design, supplementing attributes of entities, and associating the attributes with
data element standards; generating an initial framework of the
physical model on the basis of the structure of the logic model; designing a
physical model, supplementing field information for the entity, and adding foreign keys and indexes; and selecting a
physical model and a target
data source, generating a DDL statement according to the structure of the physical model and the type of the target
data source, running the DDL statement in the target
data source, and generating the
library table. According to the layered
data model design and generation method, repeated work and errors are reduced, the efficiency and accuracy of data model design are effectively improved, the cost of later maintenance and upgrading is reduced, and the layered data model design and generation method is suitable for various
data modeling scenes.