A data governance method and terminal based on data element to realize one number and one source
By obtaining the maximum allowable number of associations of data elements and limiting data table creation, the problem that the existing technology cannot achieve "one number, one source" management through technical means is solved, and accurate and efficient management is achieved when data generation is achieved.
Patent Information
- Application Number
- CN202210661535.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-06-13
- Publication Date
- 2025-05-23
- Estimated Expiration
- 2042-06-13
AI Technical Summary
The existing data "one number, one source" management method cannot be implemented through technical means, resulting in multiple sources of data, repeated data collection and storage, resulting in problems such as inability to guarantee data accuracy, uncontrollable data quality, and waste of storage resources.
By obtaining the maximum allowed number of associations for each data element, creating a data table and associating its fields with the data element, limiting the creation of data tables, and realizing the "one number, one source" management when data generation is generated.
It realizes the management of data when data is generated, avoids the problems of repeated creation of data tables, repeated collection and storage of data, and ensures the accuracy and quality of data.
Smart Images

Figure CN115062014B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of electronic information technology, and in particular to a data management method and terminal that implements one number and one source based on data elements. Background Art
[0002] "One number, one source" is the basic principle for some institutions to share basic data. The purpose is to ensure that each basic data has one and only one designated collection agency, which is responsible for the authenticity and accuracy of the data.
[0003] Most of the existing data management methods of "one number, one source" are to sort out data resources, confirm data ownership, and clarify data ownership, that is, to clarify the only entity responsible for source data management. After determining the source of the data, the source department will collect data, perform quality control, update and maintain data, and be responsible for the data.
[0004] According to the existing management method of "one number, one source" for data, "one number, one source" can only be implemented from the management system, and it is impossible to achieve the management of "one number, one source" from the technical means. If the management method is not implemented at the source or there is a human judgment error, there will still be multiple sources of data, repeated data collection and repeated storage, resulting in problems such as the inability to guarantee data accuracy, uncontrollable data quality, and waste of storage resources. In addition, it is often necessary to clean, integrate and trace the technology in the later stage, making it difficult to trace the source of the problem and the cost of troubleshooting is high. Summary of the invention
[0005] The technical problem to be solved by the present invention is: to provide a data management method and terminal based on data element to realize one number and one source, which can realize one number and one source when data is generated.
[0006] In order to solve the above technical problems, the technical solution adopted by the present invention is:
[0007] A data governance method for realizing one number and one source based on data elements, comprising the steps of:
[0008] S1. Obtain the maximum allowed association times for each data element, create a data table according to the maximum allowed association times for each data element, and associate the fields of the data table with each data element, wherein the total number of association times for each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times for non-associated fields in the data element is 1.
[0009] In order to solve the above technical problems, another technical solution adopted by the present invention is:
[0010] A data governance terminal that implements one-number-one-source based on data elements, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the following steps when executing the computer program:
[0011] S1. Obtain the maximum allowed association times for each data element, create a data table according to the maximum allowed association times for each data element, and associate the fields of the data table with each data element, wherein the total number of association times for each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times for non-associated fields in the data element is 1.
[0012] The beneficial effects of the present invention are: a data management method and terminal based on data elements to achieve one number and one source, which obtains the maximum allowed number of associations for each data element set by the main terminal, and requires that fields be associated with data elements when creating a data table to limit the creation of the data table, thereby achieving one number and one source for data management when the data is generated. BRIEF DESCRIPTION OF THE DRAWINGS
[0013] Figure 1 A flowchart of a data governance method for realizing one number and one source based on data elements according to an embodiment of the present invention;
[0014] Figure 2 A schematic diagram of a slave terminal process of a data governance method for realizing one number and one source based on data element in an embodiment of the present invention
[0015] Figure 3 This is a schematic diagram of the structure of a data management terminal that implements one number and one source based on data elements according to an embodiment of the present invention;
[0016] Figure 4 The present invention is a schematic diagram of a display screen of a data management terminal that implements one number and one source based on data elements in an embodiment of the present invention.
[0017] Description of labels:
[0018] 1. A data management terminal that implements one number and one source based on data elements; 2. A processor; 3. A memory. DETAILED DESCRIPTION
[0019] In order to explain the technical content, achieved objectives and effects of the present invention in detail, the following is an explanation in combination with the implementation modes and the accompanying drawings.
[0020] Please refer to Figure 1 , a data governance method for realizing one number and one source based on data element, comprising the steps of:
[0021] S1. Obtain the maximum allowed association times for each data element, create a data table according to the maximum allowed association times for each data element, and associate the fields of the data table with each data element, wherein the total number of association times for each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times for non-associated fields in the data element is 1.
[0022] From the above description, it can be seen that the beneficial effects of the present invention are: a data governance method and terminal based on data elements to achieve one number and one source, which obtains the maximum allowed number of associations for each data element set by the main terminal, and requires that fields be associated with data elements when creating a data table to limit the creation of the data table, thereby achieving one number and one source for data management when the data is generated.
[0023] Furthermore, in step S1, obtaining the maximum allowed association times of each data element includes:
[0024] S11. Obtain a data list and determine the data sources and data resource responsible entities of each data list;
[0025] S12. Obtain corresponding data elements according to the data list, and set the maximum allowed number of associations for each data element.
[0026] From the above description, it can be seen that the confirmation of each data source of the data list and the association of the maximum allowed number of times for each data element are realized.
[0027] Furthermore, the method further comprises the steps of:
[0028] S2, obtain each data table, and associate and integrate them to form a new data list;
[0029] S3. Share the data list.
[0030] From the above description, it can be seen that “one number, one source, and multiple uses of one source” can be achieved through data sharing.
[0031] Furthermore, in step S12, the maximum allowed association times of each data element is set to 1, and the maximum allowed association times of the associated fields are not limited.
[0032] From the above description, it can be seen that the maximum allowed number of associations for each data element is set to achieve one number and one source.
[0033] A data governance terminal that implements one-number-one-source based on data elements, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the following steps when executing the computer program:
[0034] S1. Obtain the maximum allowed association times for each data element, create a data table according to the maximum allowed association times for each data element, and associate the fields of the data table with each data element, wherein the total number of association times for each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times for non-associated fields in the data element is 1.
[0035] From the above description, it can be seen that the beneficial effects of the present invention are: a data governance method and terminal based on data elements to achieve one number and one source, which obtains the maximum allowed number of associations for each data element set by the main terminal, and requires that fields be associated with data elements when creating a data table to limit the creation of the data table, thereby achieving one number and one source for data management when the data is generated.
[0036] Furthermore, in step S1, obtaining the maximum allowed association times of each data element includes:
[0037] S11. Obtain a data list and determine the data sources and data resource responsible entities of each data list;
[0038] S12. Obtain corresponding data elements according to the data list, and set the maximum allowed number of associations for each data element.
[0039] From the above description, it can be seen that the confirmation of each data source of the data list and the association of the maximum allowed number of times for each data element are realized.
[0040] Furthermore, the method further comprises the steps of:
[0041] S2, obtain each data table, and associate and integrate them to form a new data list;
[0042] S3. Share the data list.
[0043] From the above description, it can be seen that “one number, one source, and multiple uses of one source” can be achieved through data sharing.
[0044] Furthermore, in step S12, the maximum allowed association times of each data element is set to 1, and the maximum allowed association times of the associated fields are not limited.
[0045] From the above description, it can be seen that the maximum allowed number of associations for each data element is set to achieve one number and one source.
[0046] The present invention is used to manage data, prevent the same data from being uploaded from multiple sources, causing a problem of multiple sources, and avoid data being collected and stored at multiple ends, making it impossible to determine the accuracy and reliability of the data. For example, a certain type of employee information in the employee information table is uploaded from the Finance Department and the Human Resources Department respectively, resulting in the collection of this type of employee information by the Finance Department and the Human Resources Department respectively, resulting in data diversity.
[0047] Please refer to Figure 1-2 , Embodiment 1 of the present invention is:
[0048] A data governance method based on data element to achieve one data and one source, comprising the following steps:
[0049] S1. Obtain the maximum allowed association times for each data element, create a data table according to the maximum allowed association times for each data element, and associate the fields of the data table with each data element, wherein the total number of association times for each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times for non-associated fields in the data element is 1.
[0050] When creating a data table by referencing a data element or when creating a data table, the field is associated with the data element to establish an association relationship between the field and the data element. A data element with a "maximum allowed association times" of 1 can only be associated once, that is, it cannot be associated again after being associated with a created data table. A data element with a "maximum allowed association times" of N can be associated multiple times. It is required that the data table field must be associated with the data element. If there is no associated data element, the data table cannot be created, thereby avoiding problems such as repeated creation of data tables, repeated data collection, and repeated data storage.
[0051] The method of obtaining the maximum allowed association times of each data element and the number of association times of each data element in all terminals specifically includes:
[0052] S11. Obtain the data list and determine the data sources and responsible entities of each data resource in the data list.
[0053] Specifically, after obtaining the data list, sort out the data list, determine the data source and determine the responsible party for the data resources. The data source is the source of the data, which is the source of the unit that collects data and uploads and enters it.
[0054] S12. Obtain corresponding data elements according to the data list, and set the maximum allowed number of associations for each data element.
[0055] Specifically, in this embodiment, the "maximum allowed number of associations" of non-associated fields other than the primary key is set to a first set value, which is specifically 1. The "maximum allowed number of associations" of associated fields is set according to actual needs. In this embodiment, it is specifically set to N, which is an unlimited number of times.
[0056] S2. Obtain each data table, and integrate them to form a new data list.
[0057] Specifically, data is collected from multiple terminals and correlated and integrated to form a complete data asset, and the data assets are cataloged to form a data list.
[0058] For example, the "employee information table" stores 100 pieces of data, namely the basic information of 100 employees (name: Zhang San, gender: male, age: 20 years old, address: Fuzhou City, Fujian Province)
[0059] Catalog and list the resource "Employee Information Table" on the platform, and use some descriptive information to tell users what this resource is, such as (table name: Employee Information Table, responsible department: Human Resources Department, update frequency: real-time update, including fields: name, gender, age, address). Users only need to look at the list to determine whether this is the data they need.
[0060] S3. Share the data list.
[0061] Catalog data resources and realize “one number, one source, multiple uses of one source” through data sharing.
[0062] Please refer to Figure 3-4 , Embodiment 2 of the present invention is:
[0063] A data governance terminal 1 that implements one number and one source based on data elements includes a memory 3, a processor 2, and a computer program stored in the memory 3 and executable on the processor 2. When the processor 2 executes the computer program, the steps of the above-mentioned embodiment 1 are implemented.
[0064] When the processor 2 executes the computer program, a data management terminal 1 based on data element to realize one number and one source displays a screen such as Figure 4 shown.
[0065] In summary, the present invention provides a data governance method and terminal for realizing one number and one source based on data elements. It obtains the maximum allowed number of associations for each data element set by the main terminal, and requires that fields be associated with data elements when creating a data table to limit the creation of the data table, thereby realizing one number and one source for data management when the data is generated.
[0066] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent transformations made using the contents of the present invention's specification and drawings, or directly or indirectly applied in related technical fields, are also included in the patent protection scope of the present invention.
Claims
1. A data governance method based on data element to achieve one number and one source, It is characterized in that Includes steps: S1. Obtain the maximum allowed association times of each data element, create a data table according to the maximum allowed association times of each data element, and associate the fields of the data table with each data element, wherein the total number of association times of each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times of non-association fields in the data element is 1; S2, obtain each data table, and associate and integrate them to form a new data list; S3, share the data list; In step S1, obtaining the maximum allowed association times of each data element includes: S11. Obtain a data list and determine the data sources and data resource responsible entities of each data list; S12. Obtain corresponding data elements according to the data list, and set the maximum allowed number of associations for each data element.
2. According to claim 1, a data governance method based on data element to achieve one number and one source, It is characterized in that In step S12, the maximum allowed association times of each data element is set to 1, and the maximum allowed association times of the non-association fields are not limited.
3. A data management terminal that implements one number and one source based on data elements, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, It is characterized in that When the processor executes the computer program, the following steps are implemented: S1. Obtain the maximum allowed association times of each data element, create a data table according to the maximum allowed association times of each data element, and associate the fields of the data table with each data element, wherein the total number of association times of each data element is not allowed to exceed the maximum allowed association times, and the maximum allowed association times of non-association fields in the data element is 1; S2, obtain each data table, and associate and integrate them to form a new data list; S3, share the data list; In step S1, obtaining the maximum allowed association times of each data element includes: S11. Obtain a data list and determine the data sources and data resource responsible entities of each data list; S12. Obtain corresponding data elements according to the data list, and set the maximum allowed number of associations for each data element.
4. According to claim 3, a data management terminal for realizing one number and one source based on data element, It is characterized in that In step S12, the maximum allowed association times of each data element is set to 1, and the maximum allowed association times of the non-association fields are not limited.
Citation Information
Patent Citations
Data governance method and data governance system
CN111190881A
Data processing method, device and equipment
CN111666347A