Method and system for customizing data model
Through the custom data model method, the problem of multiple reuse of grassroots data is solved, flexible definition and security management are realized, data free filling rate and information sharing efficiency are improved, and data security and transparency are enhanced.
Patent Information
- Application Number
- CN202510311175.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-03-17
- Publication Date
- 2025-07-04
AI Technical Summary
The prior art is difficult to realize the entry and multiple reuse of grassroots data at one time, and the lack of flexible data definition and secure data permission management, resulting in insufficient repetitive labor and data security.
Using the custom data model method, we establish an association relationship with ledger reports through data field dictionary, and generate a table data model, combining low-code technology and document-based databases to realize customization and security management of data.
It realizes flexible definition and secure storage of grassroots data, reduces duplicate labor, improves data free filling rate and information sharing efficiency, and enhances data security and transparency.
Smart Images
Figure CN120258710A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer software applications, and specifically provides a method and system for customizing data models. Background Art
[0002] The modern social structure is becoming increasingly complex, and social governance faces many new challenges, such as the accelerating urbanization process, frequent population mobility, and diverse social problems. To better cope with these changes, it is necessary to build a more intelligent and efficient grass-roots governance system. Establishing a grass-roots data model and forming a unified data platform by integrating various relevant information resources helps to enhance the overall understanding of the community situation and improve the scientific level of decision-making. And with the advancement of the modernization of the governance system and governance capacity, more and more attention is paid to improving the effectiveness and accuracy of grass-roots governance, so the grass-roots one-table-through system has begun to be built.
[0003] This system integrates the data and business processes of multiple departments, enabling grass-roots staff to complete multiple work tasks on one platform, thereby reducing repetitive labor, improving information sharing efficiency, and enhancing the transparency and accuracy of services. How to achieve one-time entry and multiple reuse of grass-roots data is an important part of its work. Grass-roots data often has characteristics such as primitiveness, limitations, diversity, and frequent updates, so users are often required to be able to freely define data business fields, with multiple data sources, and at the same time, it is necessary to perform hierarchical permission protection on the data. Summary of the Invention
[0004] The present invention aims at the above-mentioned deficiencies of the prior art and provides a method for customizing a data model with strong practicability.
[0005] A further technical task of the present invention is to provide a system for customizing a data model with reasonable design, safety and applicability.
[0006] The technical solution adopted by the present invention to solve its technical problems is as follows:
[0007] A method for customizing a data model has the following steps:
[0008] S1. Data field dictionary;
[0009] S2. Establish an association relationship with the ledger report;
[0010] S3. Generate a table data model.
[0011] Further, in step S1, sort out the grass-roots data attributes, create different data field dictionaries according to the attributes. In each data dictionary, according to the business attributes, add business segmentation logic to segment and manage the data fields. Perform permission management for each business segment. By authorizing each department, ensure that each department can perform addition, deletion, and modification operations on the data fields under the business segments within its own permissions, while ensuring the security of data usage in the data model corresponding to the data fields.
[0012] Further, in step S2, use low-code technology to create an electronic ledger report. The user can customize the data model of the electronic ledger report, and at the same time establish an association relationship between the data segment of the electronic ledger report and the data field dictionary, thereby realizing data binding.
[0013] Further, in step S3, all grass-roots data are finally stored in a table with their respective attributes, which corresponds to a data table in the database. Use a document-based database to store the data of a table. A document-based database stores, retrieves, and manages semi-structured data, usually in the form of documents.
[0014] For each document in a data table, establish a data model for the document through the association relationship between the ledger report data and the data field dictionary, fuse and store the ledger report data in a table, and set a unique value in each document-based data table.
[0015] A system for customizing a data model. First, construct a data field dictionary, establish an association relationship with the ledger report, and finally, generate a data model for a table.
[0016] Further, in constructing the data field dictionary, sort out the grass-roots data attributes, create different data field dictionaries according to the attributes. In each data dictionary, according to the business attributes, add business segmentation logic to segment and manage the data fields. Perform permission management for each business segment. By authorizing each department, ensure that each department can perform addition, deletion, and modification operations on the data fields under the business segments within its own permissions, while ensuring the security of data usage in the data model corresponding to the data fields.
[0017] Further, in establishing the association relationship with the ledger report, use low-code technology to create an electronic ledger report. The user can customize the data model of the electronic ledger report, and at the same time establish an association relationship between the data segment of the electronic ledger report and the data field dictionary, thereby realizing data binding.
[0018] Furthermore, in generating a table data model, all the underlying data is finally stored in a table corresponding to each attribute. In the database, this corresponds to a data table. A document-based database is used to store the data of a single table. A document-based database stores, retrieves, and manages semi-structured data, usually in the form of documents.
[0019] For each document in a data table, a data model of the document is established through the association relationship between the ledger report data and the data field dictionary. The ledger report data is fused and stored in a single table. At the same time, a unique value is set in each document-based data table.
[0020] Compared with the prior art, a method and system for customizing a data model according to the present invention have the following outstanding beneficial effects:
[0021] In the present invention, users can customize their own underlying data models. Without the need for separate development for different business requirements, all the data in the user's custom ledger reports can be stored, reducing the work development cost. Permission management can be set through the data field dictionary, ensuring data security and providing a certain degree of data isolation protection.
[0022] By fusing and summarizing the underlying data into a single table, operations such as data reference and data recommendation can be effectively carried out, improving the fill-free rate when users fill in ledger report data. BRIEF DESCRIPTION OF THE DRAWINGS
[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for the description of the embodiments or the prior art. Obviously, the drawings in the following description are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.
[0024] Attached Figure 1 is a flowchart of a method for customizing a data model. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0025] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will further elaborate on the present invention in combination with specific embodiments. Obviously, the described embodiments are only some embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.
[0026] The following gives a best embodiment:
[0027] Such as Figure 1As shown in the figure, a method for customizing a data model in this embodiment has the following steps:
[0028] S1. Data field dictionary;
[0029] Sort out the grass-roots data attributes, and create different data field dictionaries according to the attributes, such as the data field dictionary of the population single table and the data field dictionary of the enterprise single table.
[0030] In each data dictionary, according to the business attributes, add business segmentation logic to manage the data fields in segments. Each business segment is managed with permissions. By performing authorization operations on each department, it is ensured that each department can perform operations such as addition, deletion, and modification on the data fields under the business segments within its own permissions, while ensuring the security of data usage in the data model corresponding to the data fields.
[0031] Create a corresponding separate database table for each data field dictionary, such as the population single table and the enterprise single table.
[0032] S2. Establish an association relationship with the ledger report;
[0033] Use low-code technology to create an electronic ledger report. Users can customize the data model of the electronic ledger report, and at the same time establish an association relationship between a section of the data of the electronic ledger report and the data field dictionary, so as to achieve data binding.
[0034] S3. Generate a single-table data model;
[0035] All grass-roots data are finally stored in a single table with their respective attributes. For example, the population single table corresponds to a data table in the database. A document-based database is used for single-table data storage. A document-based database stores, retrieves, and manages semi-structured data, usually in the form of documents.
[0036] Utilize the characteristic that a document-based database does not require all documents to have the same structure to establish a data model for each document in the single-table data table through the association relationship between the ledger report data and the data field dictionary, and fuse and store the ledger report data in a single table.
[0037] At the same time, set a unique value in each document-based data table to ensure data consistency. For example, in the population single table, set the ID number as the unique value for each document. The addition, deletion, and modification operations are all confirmed by the ID number to update which document.
[0038] Based on the above method, a system for customizing a data model in this embodiment first constructs a data field dictionary, establishes an association relationship with the ledger report, and finally generates a single-table data model.
[0039] Furthermore, in constructing the data field dictionary, the grass-roots data attributes are sorted out, and different data field dictionaries are created according to the attributes. In each data dictionary, according to the business attributes, business segmentation logic is added to manage the data fields in segments. Permission management is carried out for each business segment. By performing authorization operations on each department, it is ensured that each department can perform addition, deletion, and modification operations on the data fields in the business segments within its own authority, while ensuring the security of data usage in the data model corresponding to the data fields.
[0040] Among them, in establishing the association relationship with the ledger report, low-code technology is used to create an electronic ledger report. The user customizes the data model of the electronic ledger report, and at the same time, an association relationship is established between a data segment of the electronic ledger report and the data field dictionary, so as to achieve data binding.
[0041] In the data model of a generated table, the grass-roots data are finally all stored in a table with their respective attributes, which corresponds to a data table in the database. A document-based database is used to store the data of a table. A document-based database stores, retrieves, and manages semi-structured data, usually in the form of documents.
[0042] For each document in a data table, a data model of the document is established through the association relationship between the ledger report data and the data field dictionary, and the ledger report data is fused and stored in a table. At the same time, a unique value is set in each document-based data table.
[0043] The above specific implementation manners are only specific cases of the present invention. The patent protection scope of the present invention includes but is not limited to the above specific implementation manners. Any technical solution that conforms to the technical solutions described in the above specific implementation manners of the present invention and any appropriate changes or substitutions made by those of ordinary skill in the relevant technical field shall fall within the patent protection scope of the present invention.
[0044] Although the embodiments of the present invention have been shown and described, for those of ordinary skill in the art, it can be understood that various changes, modifications, substitutions, and variations can be made to these embodiments without departing from the principles and spirits of the present invention. The scope of the present invention is defined by the appended claims and their equivalents.
Claims
1. A method for customizing a data model, characterized in that, It has the following steps: S1. Data field dictionary; S2. Establish an association relationship with the ledger report; S3. Generate a table data model.
2. The method for customizing a data model according to claim 1, wherein In step S1, sort out the grass-roots data attributes, create different data field dictionaries according to the attributes. In each data dictionary, according to the business attributes, add business segmentation logic to segment and manage the data fields. Perform permission management for each business segment. By authorizing each department, ensure that each department can perform addition, deletion, and modification operations on the data fields under the business segments within its own permissions, and at the same time ensure the security of data usage in the data model corresponding to the data fields.
3. A method for customizing a data model according to claim 2, characterized in that, In step S2, use low-code technology to create an electronic ledger report. The user customizes the data model of the electronic ledger report, and at the same time establish an association relationship between a section of the data of the electronic ledger report and the data field dictionary, so as to achieve data binding.
4. A method for customizing a data model according to claim 3, wherein, In step S3, all the grass-roots data are finally stored in a table with their respective attributes, which corresponds to a data table in the database. Use a document-based database to store the data of a table. A document-based database stores, retrieves, and manages semi-structured data, usually in the form of documents; For each document in a data table, establish a data model of the document through the association relationship between the ledger report data and the data field dictionary, fuse and store the ledger report data in a table, and set a unique value in each document-based data table.
5. A system for customizing a data model, characterized in that, First, construct a data field dictionary, establish an association relationship with the ledger report, and finally, generate a table data model.
6. The system for customizing a data model according to claim 5, wherein In constructing the data field dictionary, sort out the grass-roots data attributes, create different data field dictionaries according to the attributes. In each data dictionary, according to the business attributes, add business segmentation logic to segment and manage the data fields. Perform permission management for each business segment. By authorizing each department, ensure that each department can perform addition, deletion, and modification operations on the data fields under the business segments within its own permissions, and at the same time ensure the security of data usage in the data model corresponding to the data fields.
7. The system for customizing a data model according to claim 6, wherein In establishing the association relationship with the ledger report, use low-code technology to create an electronic ledger report. The user customizes the data model of the electronic ledger report, and at the same time establish an association relationship between a section of the data of the electronic ledger report and the data field dictionary, so as to achieve data binding.
8. A system for customizing a data model according to claim 7, characterized in that, In generating a table data model, all the grass-roots data are finally stored in a table with their respective attributes, which corresponds to a data table in the database. Use a document-based database to store the data of a table. A document-based database stores, retrieves, and manages semi-structured data, usually in the form of documents; For each document in a data table, establish a data model of the document through the association relationship between the ledger report data and the data field dictionary, fuse and store the ledger report data in a table, and set a unique value in each document-based data table.