CN-121996656-A - Configuration item management method and system based on dynamic form

CN121996656ACN 121996656 ACN121996656 ACN 121996656ACN-121996656-A

Abstract

The invention discloses a configuration item management method and a configuration item management system based on a dynamic form, which belong to the technical field of computers and comprise the steps of obtaining front-end control types according to interaction requirements of actual service scenes, carrying out modular encapsulation on the front-end controls of all types to obtain a standardized form assembly, constructing the dynamic form by using the standardized form assembly, storing rule configuration items of the dynamic form and dynamic form service data input by a user into a configuration table in a database according to a JSON format, extracting core service fields in the configuration table according to service query requirements, creating a corresponding virtual query column for each core service field, constructing a database index based on the virtual query column, and carrying out query on the configuration table based on the virtual query column and the database index to obtain a final query result. The technical problems that development efficiency, suitability and query efficiency of configuration items are difficult to improve in the prior art are solved.

Inventors

Yu Peifei
YAN HAIDONG
WU YUNJUN
ZHANG YANG

Assignees

新途(嘉兴)数字科技有限公司

Dates

Publication Date: 20260508
Application Date: 20251229

Claims (10)

1. The configuration item management method based on the dynamic form is characterized by comprising the following steps: acquiring front-end control types according to the interaction requirements of actual service scenes, and carrying out componentization encapsulation on the front-end controls of each type to acquire a standardized form component; Building a dynamic form by using a standardized form assembly, and storing rule configuration items of the dynamic form and dynamic form service data input by a user into a configuration table in a database according to a JSON format; core service fields in the configuration table are extracted according to service query requirements, a corresponding virtual query column is created for each core service field, a database index is built based on the virtual query columns, and the configuration table is queried based on the virtual query columns and the database index to obtain a final query result.
2. The dynamic form based configuration item management method of claim 1, wherein the front end control types include at least a character control, a numerical control, a drop-down box control, a date control, and a region control.
3. The method for managing configuration items based on dynamic forms according to claim 1, wherein the step of performing component-based encapsulation on front-end controls of each type to obtain standardized form components includes: the technical base unification, the interface standard unification and the architecture layering unification are carried out on the front-end controls of all types; And packaging the general logic in the source code corresponding to each type of front-end control into an independent tool function, replacing the general logic in the source code by using the tool function, acquiring the capability boundary of each type of front-end control based on an actual service scene, and packaging the special logic in the source code corresponding to each type of front-end control into built-in logic according to the capability boundary, thereby acquiring the standardized form component.
4. The method for managing configuration items based on dynamic forms according to claim 3, wherein the interface standard unification specifically comprises that all types of front-end controls expose a general input interface and an output interface; The architecture layering unification specifically comprises the architecture that all types of front-end controls follow a basic layer, a business layer and a configuration layer.
5. The method for managing configuration items based on dynamic forms according to claim 1, wherein storing rule configuration items of dynamic forms and dynamic form service data input by a user into configuration tables in a database according to JSON format comprises: storing the rule configuration items into a configuration table in a database according to a JSON format according to the mapping relation between the rule configuration items and the JSON configuration fields; And acquiring the dynamic form service data according to the rule configuration items, and storing the dynamic form service data into a configuration table in a database according to the JSON format based on the mapping relation between the rule configuration items and the JSON configuration fields.
6. The dynamic form based configuration item management method of claim 5, wherein the configuration table comprises a general configuration table and an independent configuration table.
7. The dynamic form based configuration item management method according to claim 1, wherein extracting core service fields in the configuration table according to service query requirements and creating a corresponding virtual query column for each core service field comprises: And taking the service field with the query frequency larger than the preset query frequency in the database log as a core service field, recording the JSON path of the core service field, extracting the value of the core service field along the JSON path, checking the error type of the JSON path if the value is not matched with the actual value of the core service field, correcting the JSON path according to the error type, creating a corresponding VIRTUAL query column for each core service field by using VIRTUAL according to the corrected JSON path, and otherwise, creating a corresponding VIRTUAL query column for each core service field by using VIRTUAL according to the JSON path.
8. The method for managing configuration items based on dynamic forms according to claim 1, wherein the querying the configuration table based on the virtual query column and the database index to obtain the final query result comprises: and converting the user query requirement into an SQL query statement, querying the virtual query column through the SQL query statement to obtain an initial query result, and querying the configuration table according to the initial query result and the database index to obtain a final query result.
9. A dynamic form based configuration item management system adapted to the dynamic form based configuration item management method of any one of claims 1 to 8, comprising: The packaging module is used for acquiring the types of the front-end controls according to the interaction requirements of the actual service scene, and carrying out componentization packaging on the front-end controls of each type to acquire a standardized form component; The storage module is used for constructing a dynamic form by using the standardized form assembly, and storing rule configuration items of the dynamic form and dynamic form service data input by a user into a configuration table in a database according to a JSON format; And the lightweight query module is used for extracting core service fields in the configuration table according to service query requirements, creating a corresponding virtual query column for each core service field, constructing a database index based on the virtual query column, and querying the configuration table based on the virtual query column and the database index to obtain a final query result.
10. A computer device comprising a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory in communication over the bus when the computer device is running, the processor executing the machine-readable instructions to perform the steps of the dynamic form-based configuration item management method of any of the preceding claims 1-7.

Description

Configuration item management method and system based on dynamic form Technical Field The invention relates to the technical field of computers, in particular to a method and a system for managing configuration items based on dynamic forms. Background Along with the technical evolution of the configuration item management field, the method is developed around two core requirements of efficiency improvement and service suitability all the time, and three key stages of hard coding development, wide-table static storage and low-code dynamic form are successively experienced. However, with the improvement of service complexity, the traditional scheme gradually exposes the following technical bottlenecks that 1, independent development efficiency is low, each configuration item needs to be independently designed with read-write logic, the development period required by each configuration item is usually as long as several days, so that hundreds of configuration items have huge workload, 2, the wide-table scheme has poor flexibility, the front end is required to customize a field mapping relation when the configuration items are newly added through reserved field mapping, the adaptation cost is high, 3, the general configuration performance is poor, because the configuration items are semi-structured data, the semi-structured data do not have effective indexes for internal fields, when the configuration items are more, only the whole data table can be queried, then target data meeting the conditions are obtained by analyzing the contents one by one, and the query efficiency is low. Therefore, how to improve the development efficiency, suitability and query efficiency of the configuration items is a technical problem that is difficult to solve in the prior art. Disclosure of Invention Aiming at the technical problems that the development efficiency, the suitability and the query efficiency of the configuration items are difficult to improve in the prior art, the invention provides a configuration item management method and a configuration item management system based on dynamic forms, standardized form components are obtained by carrying out modularized encapsulation on front-end controls of all types, the dynamic forms are built by using the standardized form components, and the rule configuration items of the dynamic form and the dynamic form service data input by the user are stored in the configuration table in the database according to the JSON format, so that the development efficiency and suitability of the configuration items are improved, the configuration table is queried through the constructed virtual query column and the database index, and the query efficiency of the configuration items is improved. The technical problems that development efficiency, suitability and query efficiency of configuration items are difficult to improve in the prior art are solved. In order to solve the technical problems, the invention provides a configuration item management method based on a dynamic form, which comprises the following steps: acquiring front-end control types according to the interaction requirements of actual service scenes, and carrying out componentization encapsulation on the front-end controls of each type to acquire a standardized form component; Building a dynamic form by using a standardized form assembly, and storing rule configuration items of the dynamic form and dynamic form service data input by a user into a configuration table in a database according to a JSON format; core service fields in the configuration table are extracted according to service query requirements, a corresponding virtual query column is created for each core service field, a database index is built based on the virtual query columns, and the configuration table is queried based on the virtual query columns and the database index to obtain a final query result. Preferably, the front-end control type at least comprises a character control, a numerical control, a drop-down box control, a date control and a region control. Preferably, the step of packaging each type of front-end control in a componentized manner to obtain a standardized form component includes: the technical base unification, the interface standard unification and the architecture layering unification are carried out on the front-end controls of all types; And packaging the general logic in the source code corresponding to each type of front-end control into an independent tool function, replacing the general logic in the source code by using the tool function, acquiring the capability boundary of each type of front-end control based on an actual service scene, and packaging the special logic in the source code corresponding to each type of front-end control into built-in logic according to the capability boundary, thereby acquiring the standardized form component. Preferably, the interface standard unification specifically comprises that all types of front