Method and system for dynamically configuring physical data table

Abstract

The invention discloses a method for dynamically configuring an entity data table. The method comprises: acquiring configuration information of the entity data table, wherein the configuration information comprises attribute information and value information; storing the configuration information in the form of a configuration table, namely storing the attribute information into an attribute information subtable of the configuration table and storing the value information into a value information subtable of the configuration table; and generating the attribute information in the attribute information subtable and corresponding value information in the value information subtable into columns, importing the columns into the entity data table, and displaying the entity data table. The invention correspondingly discloses a system for dynamically configuring the entity data table. The invention can meet the service demands of dynamic attributes of the data table, and avoid heavy secondary development of an initial entity data table when the variation of the attributes of the initial entity data table is required in the late operating stage.

Description

technical field [0001] The present invention relates to the technical field of data processing, and more specifically, to a method and system for dynamically configuring entity data tables. Background technique [0002] In many existing software application systems, in some cases, it is necessary to change the structure of the data table in the database after the product is launched or when the software is running. Or it is necessary to implement the dynamic properties of the entity. Dynamic attributes are attributes that are dynamically increased, decreased or changed when the entity object is running, which cannot be considered at the initial stage of software design, or some attributes are required to be added by the software user on site according to the actual situation, for example: the data table is established at the initial stage of design A "student" entity, the height of the student needs to be recorded when the software is running later, but there is no attribut...

AI Technical Summary

Problems solved by technology

However, it is often difficult to determine the later requirements at the beginning of the design to deal with the change of entity attributes in the later stage of the software by means of reserved fields. Too many columns will affect the performance of the system

[0006] It can be seen that the existing technology cannot meet the business needs of the dynamic attributes of the data table. When the attributes of the original data table need to be changed in the later stage of operation, heavy secondary development of the original data table is still required.

Images