CN113934801A - Data blood relationship processing method and device and electronic equipment - Google Patents
Data blood relationship processing method and device and electronic equipment Download PDFInfo
- Publication number
- CN113934801A CN113934801A CN202111221570.XA CN202111221570A CN113934801A CN 113934801 A CN113934801 A CN 113934801A CN 202111221570 A CN202111221570 A CN 202111221570A CN 113934801 A CN113934801 A CN 113934801A
- Authority
- CN
- China
- Prior art keywords
- data
- information
- blood relationship
- relationship
- information parameter
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/221—Column-oriented storage; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention provides a method and a device for processing a data blood relationship and electronic equipment, which can be used in the field of big data or the field of finance. In the invention, a pre-generated thinking map of target data is obtained, an information parameter table which corresponds to the thinking map and is displayed in a data item label mode is generated, each row of information parameters in the information parameter table are sequentially obtained, and an initial data blood relationship of the target data is established according to the hierarchical relationship among the information parameters. The method and the device build the initial data blood relationship according to the hierarchical relationship among the information parameters, and compared with a manual registration management mode using an electronic form manually, the accuracy of building the data blood relationship can be improved. Furthermore, the invention can realize the data addition and modification of the data blood relationship and improve the processing mode of the data blood relationship.
Description
Technical Field
The invention relates to the field of data processing, in particular to a method and a device for processing a data blood relationship and electronic equipment.
Background
The data blood relationship is a relationship similar to the human social blood relationship formed among data in the processes of generation, processing, circulation to extinction.
By building the blood relationship among the data, the data of the enterprise can be effectively managed in a unified way. At present, when a data blood relationship is built, an electronic form is manually used for manual registration management, so that the accuracy of the built data blood relationship is poor.
Disclosure of Invention
In view of this, the invention provides a method and an apparatus for processing a data blood relationship, and an electronic device, so as to solve the problem that the accuracy of the constructed data blood relationship is poor.
In order to solve the technical problems, the invention adopts the following technical scheme:
a method for processing data blood relationship comprises the following steps:
acquiring a pre-generated thinking guide graph of target data, and generating an information parameter table which corresponds to the thinking guide graph and is displayed in a data item label mode;
sequentially acquiring each line of information parameters in the information parameter table, and building an initial data blood relationship of the target data according to the hierarchical relationship among the information parameters;
receiving a data processing instruction corresponding to the blood relationship of the initial data;
carrying out ambiguity check on the newly added data and information parameters in the information parameter table under the condition that the data processing instruction is a data adding instruction comprising newly added data, adding the newly added data in the information parameter table after the check is passed, and carrying out node adding operation on the blood relationship of the initial data according to the newly added data to obtain a first data blood relationship;
and under the condition that the data processing instruction is a data modification instruction comprising modification data, modifying the information parameter table according to the modification data, and performing node modification operation on the initial data blood relationship based on a modified part in the information parameter table to obtain a second data blood relationship.
Optionally, the method includes obtaining a pre-generated mind map of the target data, and generating an information parameter table corresponding to the mind map and displayed in a data item label manner, including:
acquiring a pre-generated thinking map of target data, wherein the thinking map comprises data contents of target subdata of the target data, and the data contents comprise belonging business field information, belonging business activity information, belonging department information and belonging product information;
determining a data item tag of the data content;
and acquiring a database table abbreviation and a data item sequence number of the target subdata, and generating an information parameter table of the target data based on the data item label, the database table abbreviation and the data item sequence number of the target subdata.
Optionally, sequentially obtaining each row of information parameters in the information parameter table, and building an initial data blood relationship of the target data according to a hierarchical relationship between the information parameters, including:
sequentially acquiring each line of information parameters in the information parameter table;
for each line of information parameters, sequentially acquiring each information parameter of the line according to the arrangement sequence of the information parameters of the line; each information parameter of the row is provided with a corresponding hierarchical relation according to the arrangement sequence;
and determining the position of the last non-empty information parameter in each information parameter of the row in the blood relationship of the initial data, creating a node corresponding to the position in the blood relationship of the initial data, and using the node as the node corresponding to the information parameter of the row to obtain the blood relationship of the initial data.
Optionally, when the data processing instruction is a data query instruction including a data query mode, the method further includes:
acquiring the data query mode; the data query mode comprises a query mode and a query field;
under the condition that the query mode is a field-level data relationship query mode, screening the query field from the information parameter table, and displaying the information parameters of the query field;
and under the condition that the query mode is a panoramic data blood relationship query mode, screening the initial data blood relationship to obtain the query field, and displaying the query field in the initial data blood relationship in an interface center.
Optionally, in a case that the data processing instruction is a data deletion instruction including a target deletion object, the method further includes:
deleting the node corresponding to the target deletion object from the initial data blood relationship;
and deleting the data associated with the target deletion object in the information parameter table.
A device for processing data kindred relationships, comprising:
the parameter table generating module is used for acquiring a pre-generated thinking guide graph of target data and generating an information parameter table which corresponds to the thinking guide graph and is displayed in a data item label mode;
the relationship construction module is used for sequentially acquiring information parameters of each row in the information parameter table and building an initial data blood relationship of the target data according to the hierarchical relationship among the information parameters;
the instruction receiving module is used for receiving a data processing instruction corresponding to the blood relationship of the initial data;
the first processing module is used for carrying out ambiguity check on the newly added data and information parameters in the information parameter table under the condition that the data processing instruction is a data adding instruction comprising the newly added data, adding the newly added data into the information parameter table after the check is passed, and carrying out node adding operation on the blood relationship of the initial data according to the newly added data to obtain a first data blood relationship;
and the second processing module is used for modifying the information parameter table according to the modified data under the condition that the data processing instruction is a data modification instruction comprising modified data, and performing node modification operation on the initial data blood relationship based on the modified part in the information parameter table to obtain a second data blood relationship.
Optionally, the parameter table generating module includes:
the data acquisition submodule is used for acquiring a pre-generated thinking guide graph of target data, the thinking guide graph comprises data contents of target subdata of the target data, and the data contents comprise information of the affiliated business field, information of the affiliated business activity, information of the affiliated department and information of the affiliated product;
a tag determination sub-module for determining a data item tag of the data content;
and the parameter table generation sub-module is used for acquiring the database table abbreviation and the data item sequence number of the target subdata and generating the information parameter table of the target data based on the data item label, the database table abbreviation and the data item sequence number of the target subdata.
Optionally, the relationship building module includes:
the parameter acquisition submodule is used for sequentially acquiring each line of information parameters in the information parameter table and sequentially acquiring each information parameter of the line according to the arrangement sequence among the information parameters of the line aiming at each line of information parameters; each information parameter of the row is provided with a corresponding hierarchical relation according to the arrangement sequence;
and the node determining submodule is used for determining the position of the last non-empty information parameter in each information parameter of the row in the blood relationship of the initial data, creating a node corresponding to the position in the blood relationship of the initial data, and using the node as the node corresponding to the information parameter of the row to obtain the blood relationship of the initial data.
Optionally, the system further includes a data query module, configured to obtain the data query mode when the data processing instruction is a data query instruction including a data query mode; under the condition that the query mode is a field-level data relationship query mode, screening the query field from the information parameter table, and displaying the information parameters of the query field; under the condition that the query mode is a panoramic data blood relationship query mode, screening the initial data blood relationship to obtain the query field, and displaying the query field in the initial data blood relationship in an interface center; the data query mode comprises a query mode and a query field.
An electronic device, comprising: a memory and a processor;
wherein the memory is used for storing programs;
the processor calls a program and is used for executing the processing method of the data blood relationship.
Compared with the prior art, the invention has the following beneficial effects:
the invention provides a method and a device for processing a data blood relationship and electronic equipment. The method and the device build the initial data blood relationship according to the hierarchical relationship among the information parameters, and compared with a manual registration management mode using an electronic form manually, the accuracy of building the data blood relationship can be improved. Furthermore, the invention can realize the data addition and modification of the data blood relationship and improve the processing mode of the data blood relationship.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flowchart of a method for processing data genetic relationships according to an embodiment of the present invention;
FIG. 2 is a flowchart of another method for processing data context according to an embodiment of the present invention;
FIG. 3 is a flowchart of a method for processing data relationship according to another embodiment of the present invention;
FIG. 4 is a schematic view of a scene of data relationship according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a data blood relationship processing apparatus according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The data blood relationship is a relationship similar to the human social blood relationship formed among data in the processes of generation, processing, circulation to extinction.
By building the blood relationship among the data, the data of the enterprise can be effectively managed in a unified way. At present, when a data blood relationship is built, an electronic form is manually used for manual registration management, so that the accuracy of the built data blood relationship is poor.
In order to solve the technical problem, the inventor finds that the data blood relationship can be established in an automatic mode, so that the problem of low accuracy and efficiency caused by manual construction can be solved. The invention particularly provides a method and a device for processing a data blood relationship and electronic equipment. The method and the device build the initial data blood relationship according to the hierarchical relationship among the information parameters, and compared with a manual registration management mode using an electronic form manually, the accuracy of building the data blood relationship can be improved. Furthermore, the invention can realize the data addition and modification of the data blood relationship and improve the processing mode of the data blood relationship.
It should be noted that the data blood relationship processing method, the data blood relationship processing device and the electronic equipment provided by the invention can be applied to the field of big data or the field of finance. The above description is only an example, and does not limit the application fields of the method, the apparatus and the electronic device for processing the data blood relationship provided by the present invention.
On the basis of the above content, the embodiment of the present invention provides a method for processing data consanguinity, which can be applied to a processor, a server, and other devices. Referring to fig. 1, a method for processing data blood relationship may include:
s11, obtaining a pre-generated thinking map of the target data, and generating an information parameter table which corresponds to the thinking map and is displayed in a data item label mode.
In this embodiment, a mental map of all data within a bank may be constructed. When constructing the mind map, the method needs manual combing and dividing the enterprise-level business field of the enterprise, combing all the existing data items of the bank, and the combing content is shown in the following sequence (not limited to) from high level to low level as shown in table 1:
TABLE 1
The order of the index items from high order to low order is as follows: the method comprises the following steps of belonging to a business field- > belonging business activity- > belonging department- > belonging product- > belonging database table- > field name.
Then manually reviewing all data items of the existing bank or enterprise combed in the previous step and information of the business field, business activity, department and product of the existing bank or enterprise, and making four-level high-level thinking guide graphs (the high-level thinking guide graphs are called as the high-level thinking guide graphs because the high-level thinking guide graphs are drawn to the product level only) containing the business field, business activity, department and product of the enterprise level all related to the data items by using a thinking guide graph method.
That is, the mind map includes data contents of target subdata of the target data (all data in the bank are referred to as target data, and each data in the bank is referred to as target subdata), and the data contents include belonging business field information, belonging business activity information, belonging department information, and belonging product information.
After the thinking map of the target data is generated, an information parameter table which corresponds to the thinking map and is displayed in a data item label mode is generated.
Specifically, referring to fig. 2, the process of generating the information parameter table may include:
s21, acquiring a pre-generated thinking map of the target data.
The thinking guide graph comprises data contents of target subdata of the target data, wherein the data contents comprise information of the affiliated business field, information of the affiliated business activity, information of the affiliated department and information of the affiliated product.
And S22, determining the data item label of the data content.
In this embodiment, the format of the data item tag of each item in the data content may be predetermined, for example, the format of the data item tag of the affiliated service field is a 2-bit affiliated service field number, and the format of the data item tag of the affiliated service activity is a 2-bit affiliated service activity number.
S23, obtaining a database table abbreviation and a data item sequence number of the target subdata, and generating an information parameter table of the target data based on the data item label, the database table abbreviation and the data item sequence number of the target subdata.
In this embodiment, in addition to adding the data content to the information parameter table, a database table abbreviation and a data item sequence number need to be added to the information parameter table. All bytes in the information parameter table may be 20 bytes.
Then, the information parameter table may be in the form of table 2.
TABLE 2
The 6-bit data item number refers to the serial number of the target sub-data, and for example, a certain loan data is represented by 0001, and a certain loan data is represented by 0002. Each piece of target subdata corresponds to one row of data in table 2.
In this embodiment, according to the drawn mind map, the digital bank relates to all the business fields, business activities, departments, and products of the data item, and establishes an information parameter table for the information, and stores the information and the corresponding relationship of the information after the digitization in the form of the parameter table, so as to prepare for the subsequent establishment of a bank or enterprise data relationship digital model.
S12, sequentially obtaining each line of information parameters in the information parameter table, and building the initial data blood relationship of the target data according to the hierarchical relationship among the information parameters.
In this embodiment, before constructing the data blood relationship, a task needs to be created, and then the data blood relationship is constructed in response to the task.
Besides the creation of tasks during the creation of data relationship, the creation of tasks is required during the modification, deletion and addition of data relationship and the generation and storage of the information parameter table. If no task is created, the operation is not free.
When creating a task, it is necessary to select information such as a created batch task number, and the content required for creating a specific task is shown in table 3.
TABLE 3
And selecting whether the maintenance identifier and the content issued by the batch of data interfaces are selected according to a specific scene, taking the maintenance identifier as an example, if the data is newly added, selecting I, and if the data is deleted, selecting D.
After the task is created, the task and the data item tags described above may be stored. In this embodiment, when storing, the structured storage manner may be adopted to store in the relational database. Refer to table 4.
TABLE 4
All the data item labels in table 2 are stored in the filling positions corresponding to the "data item labels" in table 4 in sequence.
Further, after the task of building the initial data context is created, the task may be performed. At the moment, each line of information parameters in the information parameter table are sequentially acquired, and the initial data blood relationship of the target data is established according to the hierarchical relationship among the information parameters.
Specifically, referring to fig. 3, constructing the initial data blood relationship of the target data may include:
and S31, sequentially acquiring the information parameters of each row in the information parameter table.
In this embodiment, the information parameter of each row can refer to table 2.
And S32, sequentially acquiring the information parameters of each line according to the arrangement sequence of the information parameters of the line aiming at the information parameters of each line.
Specifically, each information parameter of the row is provided with a corresponding hierarchical relationship according to the arrangement sequence.
If the hierarchical relationship is:
the method comprises the following steps of belonging to a business field- > belonging business activity- > belonging department- > belonging product- > belonging database table- > field name (the sequence number of a data item is determined through the field name).
That is, the position of the line data in the initial data blood relationship is preferentially determined according to the affiliated business field, then the position is further confirmed according to the affiliated business activity, and then the further position is determined … … according to the affiliated department until the affiliated database table is determined, and finally the data item sequence number is added to the database table.
S33, determining the position of the last non-empty information parameter in the information parameters of the row in the blood relationship of the initial data, creating a node corresponding to the position in the blood relationship of the initial data, and using the node as the node corresponding to the information parameters of the row to obtain the blood relationship of the initial data.
Specifically, the line data is sequentially acquired according to the arrangement order, the business domain is acquired first, whether the content of the business domain is empty is judged, and if the content of the business domain is empty, the processing is ended.
If not, determining whether the business field is added in the initial data blood relationship, and if not, adding the business field in the initial data blood relationship. If yes, directly positioning to the business field in the relationship of the initial data blood relationship.
And then acquiring the affiliated business activity, wherein the processing process is the same as that of the affiliated business field, and sequentially processing until the affiliated database table is processed, positioning the affiliated database table in the initial data relationship, or adding a node corresponding to the data item sequence number after the affiliated database table is added in the initial data relationship, and changing the content of the node into the data item sequence number. And the node where the data item serial number is located is the node of the row of data in the initial data relationship.
And after the information parameters of the row are processed, continuously acquiring the next row until the information parameters of all rows are processed, and constructing to obtain the blood relationship of the initial data.
It should be noted that the affiliated service field, the affiliated service activity, the affiliated department, the affiliated product, and the like are all configured in the initial data context as a node, and if there is no such node, the node needs to be newly added. If the node exists, the node is directly used.
The constructed initial data consanguinity is similar to fig. 4. The initial data blood relationship is able to characterize one blood relationship for all data within the bank. And after the initial data blood relationship is obtained, storing the initial data blood relationship into a graph database in an unstructured storage mode.
And S13, receiving a data processing instruction corresponding to the blood relationship of the initial data.
The data processing instruction in this embodiment may be addition, modification, deletion, query, and the like. Each operation must be authorized by the supervisor to be effective. The data processing instruction in this embodiment also needs to create a task in the above manner, and then perform a corresponding data processing operation.
S14, under the condition that the data processing instruction is a data adding instruction comprising new data, carrying out ambiguity check on the new data and information parameters in the information parameter table, after the check is passed, adding the new data in the information parameter table, and carrying out node adding operation on the blood relationship of the initial data according to the new data to obtain a first data blood relationship.
In this embodiment, the data addition operation is supported, and mainly an online transaction of an added data item is developed, and the added transaction includes two modes of single addition and batch import. The main fields of the single-stroke newly-added online transaction interface comprise: the system comprises a field Chinese name, a field description, a belonging business field, a belonging business activity, a belonging department, a belonging product, a belonging database table, a data type, a data format, a data demand party, whether the field is non-empty and a batch task number. The field Chinese name, the field description, the data type, the data format, the data demand side and whether the field is not empty can be input, and the rest fields are selected from a pull-down menu.
The batch import supports the function of loading one or more data items through an import table after filling the EXCEL import table according to a certain template. When a data item is newly added, the system requires a manager to select a corresponding batch task number, does not select to add a new data item, then performs ambiguity check on a data dictionary item according to information such as a product to which the data item recorded by the manager belongs, and the system allows the data item to be newly added after the checking is passed.
If the data is not checked, the fact that the data similar to the new data exists in the blood relationship of the initial data is shown, such as the fact that the deposit is similar to the deposit and the deposit is similar to the deposit, and at the moment, the new data can be merged, such as the fact that the deposit is merged with the deposit.
If the new data item passes the check, the new data item can be added as new data, and the new data item is added in the information parameter table in the manner of the data item label when the new data item is added. And meanwhile, according to the newly added data, node adding operation is carried out on the blood relationship of the initial data to obtain a first blood relationship of the data.
Wherein the node addition operation is similar to the process of generating nodes in the initial data context.
S15, when the data processing instruction is a data modification instruction including modification data, modifying the information parameter table according to the modification data, and performing node modification operation on the initial data blood relationship based on the modified part in the information parameter table to obtain a second data blood relationship.
In this embodiment, it is supported that a certain data item list is selected from the data item list query to be modified. Specifically, a piece of data may be manually screened out for modification, at this time, a data modification instruction output by a user is received, the instruction includes modification data, and then the information parameter table is modified according to the modification data. After modification, the data item tag is regenerated.
And based on the modified part in the information parameter table, carrying out node modification operation on the initial data blood relationship to obtain a second data blood relationship. The modification process is a process of adjusting data or a position of a node.
Further, in another embodiment of the present invention, data queries are also supported. Specifically, in the case that the data processing instruction is a data query instruction including a data query mode, the method further includes:
1) and acquiring the data query mode.
The data query mode comprises a query mode and a query field. Wherein, the inquiry mode comprises:
a field level data blood relationship query mode and a panoramic level data blood relationship query mode. The query field is a field that the user wants to query.
2) And under the condition that the query mode is a field-level data relationship query mode, screening the query field from the information parameter table, and displaying the information parameters of the query field.
The field level data context query mode is to query specific contents of a certain field or data, such as querying a business field, business activity, and the like to which a certain data belongs. At this time, the query field is directly screened from the information parameter table, and then the information parameter of the query field is displayed.
In addition, the field level consanguinity query can also show all the up-tracing and field downstream dependency retrieval relationships related to the field. At this time, according to the field name of the data item provided by the user input, the data item of which all the field names are matched with the field name input by the user is inquired through fuzzy inquiry, the upper-layer information of the service field, the service activity and the like of the data item related to the upward tracing is obtained by analyzing the recorded 'data item label' field information, the downstream dependent retrieval relationship of the data item is obtained through the 'data demand side' field of the table 4, and the information is displayed in a list form.
3) And under the condition that the query mode is a panoramic data blood relationship query mode, screening the initial data blood relationship to obtain the query field, and displaying the query field in the initial data blood relationship in an interface center.
The panoramic data blood relationship query mode is to display the whole data blood relationship, screen the initial data blood relationship to obtain the query field, and place the query field at the center of the interface, so that a user can visually see the position area of the field to be queried in the data blood relationship. At this time, the process of the present invention,
it should be noted that the display of the blood relationship of the panoramic-level data adopts a relatively visual mind map mode. Because the data blooding border relationship graph displayed in the panoramic level is complex and the generation time is long, the invention only supports the panoramic display of the batch task level, and after each batch of tasks is completed, the system generates the data blooding border relationship graph ending the batch (namely, all data items including the batch-changing tasks less than or equal to the batch) through batch processing during the batch background processing period, and stores the data blooding border relationship graph in the database according to the batch task number as a recording unit. The data interfaces and data kindred relationship maps of the batch can be published after the data kindred relationship maps are generated.
When the panoramic level query is carried out, the system preferentially queries data blood relationship records of related batches in the graph database, if the data blood relationship records exist, the data blood relationship records are preferentially taken out from the graph database and displayed, otherwise, the system calls the data blood relationship graph generation module in real time to generate a data blood relationship graph and display the data blood relationship graph in real time.
Further, in another embodiment of the present invention, a data deletion operation can also be implemented. Specifically, in a case where the data processing instruction is a data deletion instruction including a target deletion object, the method further includes:
and deleting the node corresponding to the target deletion object from the initial data blood relationship, and deleting the data associated with the target deletion object from the information parameter table.
The embodiment provides a deleting function of a data item, wherein the deleting operation mainly includes selecting a specified record in a data item query list, selecting the record, selecting a deleting function button, considering that a data deleting instruction is received at the moment, logically deleting the record after authorization, updating the maintenance date of the record to the currently processed accounting date, updating the maintenance identifier to a deleting identifier D, and after the deleting operation, displaying all nodes related to the deleted data item on a subsequently generated data blood relationship graph.
And when the data is specifically deleted, inquiring the initial data blood relationship to obtain the node corresponding to the deleted object, and carrying out deletion operation. In addition, the data associated with the target deletion object is also required to be deleted from the information parameter table.
In addition, the embodiment of the invention also provides a publishing function, which is mainly used for completing the publishing of the data item interface and the data blood relationship.
In this embodiment, a pre-generated mind map of target data is obtained, an information parameter table corresponding to the mind map and displayed in a data item label manner is generated, each row of information parameters in the information parameter table is sequentially obtained, and an initial data blood relationship of the target data is established according to a hierarchical relationship between the information parameters. The method and the device build the initial data blood relationship according to the hierarchical relationship among the information parameters, and compared with a manual registration management mode using an electronic form manually, the accuracy of building the data blood relationship can be improved. Furthermore, the invention can realize the data addition and modification of the data blood relationship and improve the processing mode of the data blood relationship.
In addition, in this embodiment, a method capable of establishing an end-to-end from a source system and covering all data of a bank is designed by taking the thought of thinking guide, the data blood relationship is constructed based on the thinking guide by comprehensively combing all the current data and the blood relationship thereof, the data blood relationship of all the data of the bank or the enterprise is managed and displayed in a way of combining pictures and texts, and the capacity and the management efficiency of data governance of the bank or the enterprise are improved. And visualization and scientization of data display are also improved, and subsequent data maintenance operation is facilitated.
Optionally, on the basis of the above embodiment of the method for processing data blood relationship, another embodiment of the present invention provides a device for processing data blood relationship, and with reference to fig. 5, the method may include:
the parameter table generating module 11 is configured to obtain a pre-generated mind map of the target data, and generate an information parameter table corresponding to the mind map and displayed in a data item label manner;
the relationship construction module 12 is configured to sequentially obtain each row of information parameters in the information parameter table, and build an initial data blood relationship of the target data according to a hierarchical relationship between the information parameters;
the instruction receiving module 13 is configured to receive a data processing instruction corresponding to the initial data blood relationship;
the first processing module 14 is configured to, when the data processing instruction is a data adding instruction including new data, perform ambiguity check on the new data and information parameters in the information parameter table, add the new data to the information parameter table after the check is passed, and perform node addition operation on the initial data blood-related relationship according to the new data to obtain a first data blood-related relationship;
and the second processing module 15 is configured to, when the data processing instruction is a data modification instruction including modification data, modify the information parameter table according to the modification data, and perform a node modification operation on the initial data blood relationship based on a modified part in the information parameter table to obtain a second data blood relationship.
Further, the parameter table generating module comprises:
the data acquisition submodule is used for acquiring a pre-generated thinking guide graph of target data, the thinking guide graph comprises data contents of target subdata of the target data, and the data contents comprise information of the affiliated business field, information of the affiliated business activity, information of the affiliated department and information of the affiliated product;
a tag determination sub-module for determining a data item tag of the data content;
and the parameter table generation sub-module is used for acquiring the database table abbreviation and the data item sequence number of the target subdata and generating the information parameter table of the target data based on the data item label, the database table abbreviation and the data item sequence number of the target subdata.
Further, the relationship building module comprises:
the parameter acquisition submodule is used for sequentially acquiring each line of information parameters in the information parameter table and sequentially acquiring each information parameter of the line according to the arrangement sequence among the information parameters of the line aiming at each line of information parameters; each information parameter of the row is provided with a corresponding hierarchical relation according to the arrangement sequence;
and the node determining submodule is used for determining the position of the last non-empty information parameter in each information parameter of the row in the blood relationship of the initial data, creating a node corresponding to the position in the blood relationship of the initial data, and using the node as the node corresponding to the information parameter of the row to obtain the blood relationship of the initial data.
The data processing instruction is a data query instruction comprising a data query mode, and the data query mode is acquired under the condition that the data processing instruction is the data query instruction; under the condition that the query mode is a field-level data relationship query mode, screening the query field from the information parameter table, and displaying the information parameters of the query field; under the condition that the query mode is a panoramic data blood relationship query mode, screening the initial data blood relationship to obtain the query field, and displaying the query field in the initial data blood relationship in an interface center; the data query mode comprises a query mode and a query field.
The data processing module is used for processing the data processing instruction to obtain an initial data relationship, and the data processing instruction is used for processing the data processing instruction to obtain a data processing parameter table, further comprising a data deleting module which is used for deleting a node corresponding to a target deleting object from the initial data relationship and deleting data associated with the target deleting object from the information parameter table under the condition that the data processing instruction comprises the data deleting instruction of the target deleting object.
In this embodiment, a pre-generated mind map of target data is obtained, an information parameter table corresponding to the mind map and displayed in a data item label manner is generated, each row of information parameters in the information parameter table is sequentially obtained, and an initial data blood relationship of the target data is established according to a hierarchical relationship between the information parameters. The method and the device build the initial data blood relationship according to the hierarchical relationship among the information parameters, and compared with a manual registration management mode using an electronic form manually, the accuracy of building the data blood relationship can be improved. Furthermore, the invention can realize the data addition and modification of the data blood relationship and improve the processing mode of the data blood relationship.
It should be noted that, for the working processes of each module and sub-module in this embodiment, please refer to the corresponding description in the above embodiments, which is not described herein again.
Optionally, on the basis of the above embodiment of the method and apparatus for processing a data blood relationship, another embodiment of the present invention provides an electronic device, including: a memory and a processor;
wherein the memory is used for storing programs;
the processor calls a program and is used for executing the processing method of the data blood relationship.
In this embodiment, a pre-generated mind map of target data is obtained, an information parameter table corresponding to the mind map and displayed in a data item label manner is generated, each row of information parameters in the information parameter table is sequentially obtained, and an initial data blood relationship of the target data is established according to a hierarchical relationship between the information parameters. The method and the device build the initial data blood relationship according to the hierarchical relationship among the information parameters, and compared with a manual registration management mode using an electronic form manually, the accuracy of building the data blood relationship can be improved. Furthermore, the invention can realize the data addition and modification of the data blood relationship and improve the processing mode of the data blood relationship.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A method for processing data blood relationship is characterized by comprising the following steps:
acquiring a pre-generated thinking guide graph of target data, and generating an information parameter table which corresponds to the thinking guide graph and is displayed in a data item label mode;
sequentially acquiring each line of information parameters in the information parameter table, and building an initial data blood relationship of the target data according to the hierarchical relationship among the information parameters;
receiving a data processing instruction corresponding to the blood relationship of the initial data;
carrying out ambiguity check on the newly added data and information parameters in the information parameter table under the condition that the data processing instruction is a data adding instruction comprising newly added data, adding the newly added data in the information parameter table after the check is passed, and carrying out node adding operation on the blood relationship of the initial data according to the newly added data to obtain a first data blood relationship;
and under the condition that the data processing instruction is a data modification instruction comprising modification data, modifying the information parameter table according to the modification data, and performing node modification operation on the initial data blood relationship based on a modified part in the information parameter table to obtain a second data blood relationship.
2. The processing method according to claim 1, wherein the step of obtaining a mind map of the target data generated in advance and generating an information parameter table corresponding to the mind map and displayed in a data item label manner comprises:
acquiring a pre-generated thinking map of target data, wherein the thinking map comprises data contents of target subdata of the target data, and the data contents comprise belonging business field information, belonging business activity information, belonging department information and belonging product information;
determining a data item tag of the data content;
and acquiring a database table abbreviation and a data item sequence number of the target subdata, and generating an information parameter table of the target data based on the data item label, the database table abbreviation and the data item sequence number of the target subdata.
3. The processing method according to claim 1, wherein sequentially acquiring each row of information parameters in the information parameter table, and building an initial data blood relationship of the target data according to a hierarchical relationship among the information parameters comprises:
sequentially acquiring each line of information parameters in the information parameter table;
for each line of information parameters, sequentially acquiring each information parameter of the line according to the arrangement sequence of the information parameters of the line; each information parameter of the row is provided with a corresponding hierarchical relation according to the arrangement sequence;
and determining the position of the last non-empty information parameter in each information parameter of the row in the blood relationship of the initial data, creating a node corresponding to the position in the blood relationship of the initial data, and using the node as the node corresponding to the information parameter of the row to obtain the blood relationship of the initial data.
4. The processing method according to claim 1, wherein when the data processing instruction is a data query instruction including a data query mode, the processing method further comprises:
acquiring the data query mode; the data query mode comprises a query mode and a query field;
under the condition that the query mode is a field-level data relationship query mode, screening the query field from the information parameter table, and displaying the information parameters of the query field;
and under the condition that the query mode is a panoramic data blood relationship query mode, screening the initial data blood relationship to obtain the query field, and displaying the query field in the initial data blood relationship in an interface center.
5. The processing method according to claim 1, wherein in a case where the data processing instruction is a data deletion instruction including a target deletion object, the method further comprises:
deleting the node corresponding to the target deletion object from the initial data blood relationship;
and deleting the data associated with the target deletion object in the information parameter table.
6. A device for processing data relationship, comprising:
the parameter table generating module is used for acquiring a pre-generated thinking guide graph of target data and generating an information parameter table which corresponds to the thinking guide graph and is displayed in a data item label mode;
the relationship construction module is used for sequentially acquiring information parameters of each row in the information parameter table and building an initial data blood relationship of the target data according to the hierarchical relationship among the information parameters;
the instruction receiving module is used for receiving a data processing instruction corresponding to the blood relationship of the initial data;
the first processing module is used for carrying out ambiguity check on the newly added data and information parameters in the information parameter table under the condition that the data processing instruction is a data adding instruction comprising the newly added data, adding the newly added data into the information parameter table after the check is passed, and carrying out node adding operation on the blood relationship of the initial data according to the newly added data to obtain a first data blood relationship;
and the second processing module is used for modifying the information parameter table according to the modified data under the condition that the data processing instruction is a data modification instruction comprising modified data, and performing node modification operation on the initial data blood relationship based on the modified part in the information parameter table to obtain a second data blood relationship.
7. The processing apparatus of claim 6, wherein the parameter table generating module comprises:
the data acquisition submodule is used for acquiring a pre-generated thinking guide graph of target data, the thinking guide graph comprises data contents of target subdata of the target data, and the data contents comprise information of the affiliated business field, information of the affiliated business activity, information of the affiliated department and information of the affiliated product;
a tag determination sub-module for determining a data item tag of the data content;
and the parameter table generation sub-module is used for acquiring the database table abbreviation and the data item sequence number of the target subdata and generating the information parameter table of the target data based on the data item label, the database table abbreviation and the data item sequence number of the target subdata.
8. The processing apparatus according to claim 6, wherein the relationship construction module comprises:
the parameter acquisition submodule is used for sequentially acquiring each line of information parameters in the information parameter table and sequentially acquiring each information parameter of the line according to the arrangement sequence among the information parameters of the line aiming at each line of information parameters; each information parameter of the row is provided with a corresponding hierarchical relation according to the arrangement sequence;
and the node determining submodule is used for determining the position of the last non-empty information parameter in each information parameter of the row in the blood relationship of the initial data, creating a node corresponding to the position in the blood relationship of the initial data, and using the node as the node corresponding to the information parameter of the row to obtain the blood relationship of the initial data.
9. The processing device according to claim 6, further comprising a data query module, configured to obtain a data query mode if the data processing instruction is a data query instruction that includes the data query mode; under the condition that the query mode is a field-level data relationship query mode, screening the query field from the information parameter table, and displaying the information parameters of the query field; under the condition that the query mode is a panoramic data blood relationship query mode, screening the initial data blood relationship to obtain the query field, and displaying the query field in the initial data blood relationship in an interface center; the data query mode comprises a query mode and a query field.
10. An electronic device, comprising: a memory and a processor;
wherein the memory is used for storing programs;
a processor calls a program and is adapted to perform a method of processing data consanguinity as claimed in any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111221570.XA CN113934801A (en) | 2021-10-20 | 2021-10-20 | Data blood relationship processing method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111221570.XA CN113934801A (en) | 2021-10-20 | 2021-10-20 | Data blood relationship processing method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113934801A true CN113934801A (en) | 2022-01-14 |
Family
ID=79280829
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111221570.XA Pending CN113934801A (en) | 2021-10-20 | 2021-10-20 | Data blood relationship processing method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113934801A (en) |
-
2021
- 2021-10-20 CN CN202111221570.XA patent/CN113934801A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7308704B2 (en) | Data structure for access control | |
| US7350237B2 (en) | Managing access control information | |
| US8930331B2 (en) | Providing unique views of data based on changes or rules | |
| CN108228817A (en) | Data processing method, device and system | |
| CN111708779A (en) | Data management method, system, management equipment and storage medium | |
| KR101475335B1 (en) | Enhancing an inquiry for a search of a database | |
| CN109271561B (en) | Map information retrieval method and device | |
| CN112084270A (en) | Data blood margin processing method and device, storage medium and equipment | |
| CN113157947A (en) | Knowledge graph construction method, tool, device and server | |
| CN107480262A (en) | A kind of general management system of database based on webpage | |
| US20200233541A1 (en) | Interactive dimensional hierarchy development | |
| US6999966B2 (en) | Content management system and methodology for implementing a complex object using nested/recursive structures | |
| CN111427865A (en) | Method and device for managing objects of database | |
| CN108268615A (en) | A kind of data processing method, device and system | |
| US10417234B2 (en) | Data flow modeling and execution | |
| EP2506162A1 (en) | Finding a data item of a plurality of data items stored in a digital data storage | |
| JP4287464B2 (en) | System infrastructure configuration development support system and support method | |
| CN113934801A (en) | Data blood relationship processing method and device and electronic equipment | |
| CN112286879B (en) | Metadata-based data asset construction method and device | |
| CN114880387A (en) | Data integration script generation method and device, storage medium and electronic equipment | |
| CN115409014A (en) | Document template generation method and device, computer equipment and storage medium | |
| CN113868253A (en) | Data relationship capturing and big data relationship tree construction method | |
| CN112860725A (en) | SQL automatic generation method and device, storage medium and electronic equipment | |
| CN112164433A (en) | Hospital background data processing method and system | |
| CN117827252B (en) | Function demonstration method, server and storage medium for system update |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |