WO2023098593A1

WO2023098593A1 - Data processing method and apparatus

Info

Publication number: WO2023098593A1
Application number: PCT/CN2022/134455
Authority: WO
Inventors: 王学文; 康泰; 黄玮
Original assignee: 阿里云计算有限公司
Priority date: 2021-11-30
Filing date: 2022-11-25
Publication date: 2023-06-08
Also published as: CN113849524A; CN113849524B

Abstract

Provided in the present application are a data processing method and apparatus. If a database that comprises a plurality of pieces of data needs to at least be searched for fourth data associated with third data, it is unnecessary to analyze all the data in the database to obtain the fourth data associated with the third data, and thus it is also unnecessary to respectively load each piece of data in the database into a memory, instead, a data identifier of the fourth data associated with the third data can be analyzed and obtained only according to a mapping relationship set, which is found from the above correlation and corresponds to a set identifier, and then the fourth data is acquired from the database according to the data identifier of the fourth data.

Description

Data processing method and device

This application claims the priority of a Chinese patent application with application number 202111436096.2 and titled "A Data Processing Method and Device" filed with the China Patent Office on November 30, 2021, the entire contents of which are incorporated herein by reference.

technical field

The present application relates to the field of new generation information technology, in particular to a data processing method and device.

Background technique

In some cases, the server that provides external services has a database, and the database stores multiple data, and there is an association relationship between multiple data, such as parent-child relationship or dependency relationship, and the association relationship between multiple data Complex and multi-layered. In the scenario where the server provides external services, the server often needs to query the data with related relationships from the database, and then provide external services through the data with related relationships. However, since the association relationship between multiple data in the database is complex and has many association levels, the process of querying the data with association relationship from the database takes a long time and the query efficiency is low.

Contents of the invention

In order to solve the problems in related technologies, the present application shows a data processing method and device.

In the first aspect, the present application shows a data processing method, including: when a plurality of data are stored in the database, for any first data in the plurality of data, determine in the database the difference between the first data and the first data The second data that has a direct relationship between them; generate the mapping relationship corresponding to the first data, and the mapping relationship corresponding to the first data includes: between the data identifier of the first data and the identifier set including the determined data identifier of the second data Mapping relationship; in the case of obtaining the mapping relationship corresponding to each data in the multiple data, the mapping relationship corresponding to at least two data whose data identifiers have intersections are combined into a mapping relationship set, and any two mappings There is no intersection between the data identifiers in the relationship set; in the corresponding relationship between the set identifiers of the mapping relationship set and the data identifiers of the data, the set identifiers of the mapping relationship set and the identifier set including the data identifiers in the mapping relationship set are stored.

In a second aspect, the present application shows a data processing method, including: obtaining the data identification of the third data when at least the fourth data associated with the third data needs to be searched in a database including multiple data; In the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, find the set identifier of the mapping relationship set corresponding to the data identifier of the third data; obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set , the obtained mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the third data, and the mapping relationship corresponding to any one of the at least two data includes: the data identifier of the data and the data associated with the data The mapping relationship between the identification sets of the data identifications of the data having a direct association relationship; according to the data identifications included in at least two mapping relationships in the acquired mapping relationship set, at least the fourth data is searched in the database.

In a third aspect, the present application shows a data processing device, including: a first determining module, configured to store a plurality of data in the database, for any first data in the plurality of data, in the database Determine the second data that has a direct relationship with the first data; the first generation module is used to generate the mapping relationship corresponding to the first data, and the mapping relationship corresponding to the first data includes: the data identifier of the first data and the The determined mapping relationship between the identification sets of the data identifications of the second data; the combination module is used to obtain at least the intersection of the included data identifications in the case of obtaining the corresponding mapping relationship of each data in the plurality of data. The mapping relationships corresponding to the two data are combined into a mapping relationship set, and there is no intersection between the data identifiers in any two mapping relationship sets; In the corresponding relationship, the set identification of the mapping relationship set and the identification set including the data identification in the mapping relationship set are stored.

In a fourth aspect, the present application shows a data processing device, including: a third acquiring module, configured to acquire the fourth data associated with the third data in a database including multiple data at least to find The data identifier of the third data; the third search module is used to search for the set identifier of the mapping relationship set corresponding to the data identifier of the third data in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data; the third Four acquisition module, used to acquire the mapping relationship set corresponding to the set identification of the found mapping relationship set, the acquired mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the third data, at least two data The mapping relationship corresponding to any one of the data includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifier of the data that has a direct relationship with the data; the fourth search module is configured to The data identifiers respectively included in at least two mapping relationships in the relationship set are searched for at least the fourth data in the database.

In a fifth aspect, the present application shows an electronic device, and the electronic device includes: a processor; a memory for storing instructions executable by the processor; wherein the processor is configured to execute the method as shown in any of the preceding aspects .

In the sixth aspect, the present application shows a non-transitory computer-readable storage medium. When the instructions in the storage medium are executed by the processor of the electronic device, the electronic device can execute the method as shown in any of the preceding aspects. .

In a seventh aspect, the present application shows a computer program product. When the instructions in the computer program product are executed by the processor of the electronic device, the electronic device can execute the method as shown in any one of the foregoing aspects.

The above summary is for illustrative purposes only and is not intended to be limiting in any way. In addition to the illustrative aspects, embodiments and features described above, further aspects, embodiments and features of the present application will be readily apparent by reference to the drawings and the following detailed description.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the following will briefly introduce the accompanying drawings that need to be used in the description of the embodiments or related technologies. Obviously, the accompanying drawings in the following description are only For the embodiments of the application, those skilled in the art can also obtain other drawings according to the provided drawings without creative work.

FIG. 1 shows a flowchart of the steps of a data processing method of the present application.

FIG. 2 shows a schematic diagram of a data association relationship in the present application.

FIG. 3 shows a schematic diagram of a data association relationship in the present application.

FIG. 4 shows a flow chart of the steps of a data processing method of the present application.

FIG. 5 shows a flowchart of steps of a data processing method of the present application.

FIG. 6 shows a flowchart of steps of a data processing method of the present application.

FIG. 7 shows a structural block diagram of a data processing device of the present application.

FIG. 8 shows a structural block diagram of a data processing device of the present application. as well as

Fig. 9 shows a structural block diagram of a device of the present application.

Detailed ways

The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

Referring to FIG. 1 , it shows a schematic flowchart of a data processing method of the present application, and the method 100 includes steps S101-S104.

In step S101 , if a plurality of data are stored in the database, for any first data among the plurality of data, second data having a direct association relationship with the first data is determined in the database.

The databases in this application include relational databases and the like. The data in the database may include metadata and the like.

In this application, a plurality of data are stored in the database, and among the plurality of data, some data have a direct relationship, such as a direct dependency relationship and a direct parent-child relationship.

Wherein, there may not be a direct relationship between one piece of data and another piece of data, but there may be a relationship between the one piece of data and the other piece of data (such as an indirect relationship, etc.).

For example, in one example, there is a direct relationship between the one data and another data, and there is a direct relationship between the other data and the other data, even if there is no direct relationship between the one data and the other data. Association relationship, but the one data is associated with the other data (such as indirect association, etc.).

In the present application, two data being related may be understood as: two data are directly related or indirectly related.

In this step, the first data is any one of multiple data in the database.

When determining the second data that has a direct relationship with the first data in the database, the second data that has a direct relationship with the first data can be determined through the detailed content of the data (for example, including the attributes of the data, etc.) , the specific determination method can refer to the currently existing methods, and the present application does not limit the specific determination method.

In step S102, a mapping relationship corresponding to the first data is generated, and the mapping relationship corresponding to the first data includes: a mapping relationship between a data identifier of the first data and an identifier set including the determined data identifier of the second data.

The data identification of the data includes the ID (Identity Document, identity identification number) of the data, etc.

Wherein, there may be one or more than two second data determined in the database and having a direct association relationship with the first data.

In this application, the determined data identifiers of the second data can be combined into an identifier set (even if one second data is determined, the data identifier of the second data can be regarded as an identifier set), and then A mapping relationship between the data identifier of the first data and the identifier set including the determined data identifier of the second data is generated, and used as the mapping relationship corresponding to the first data.

In an embodiment, the mapping relationship between the data identifier of the first data and the identifier set including the determined data identifier of the second data may be embodied in the form of a key-value pair "key-value".

For example, "key" may include "the data identifier of the first data", "value" may include "the identifier set including the determined data identifier of the second data", "the identifier including the determined data identifier of the second data The "set" may be embodied in the form of an array, and the array includes the determined data identifiers of each second data and the like.

For each of the other data in the multiple data stored in the database, the process of step S101 to step S102 is also executed, so as to obtain the mapping relationship corresponding to each of the multiple data stored in the database.

The mapping relationship corresponding to any piece of data includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifiers of the data directly associated with the data, and the like.

Wherein, an example is used to illustrate the present application, but it is not intended to limit the protection scope of the present application. For example, assume that the database includes data 1, data 2, data 3, data 4, data 5, and data 6, etc.

The association relationship among data 1, data 2, data 3, data 4, data 5, and data 6 can be referred to as shown in FIG. 2 .

Among them, there is a direct relationship between data 1 and data 2. There is an association relationship between data 1 and data 3 . Data 2 also has an association relationship with data 4 . Data 2 also has an association relationship with data 5 . Data 3 also has an association relationship with data 6 .

Then the mapping relationship corresponding to data 1 includes: the mapping relationship between the "data identifier of data 1" and the identifier set including "data identifier of data 2+data identifier of data 3".

The mapping relationship corresponding to data 2 includes: a mapping relationship between "data identifier of data 2" and an identifier set including "data identifier of data 1+data identifier of data 4+data identifier of data 5".

The mapping relationship corresponding to data 3 includes: the mapping relationship between the "data identifier of data 3" and the identifier set including "data identifier of data 1+data identifier of data 6".

The mapping relationship corresponding to the data 4 includes: the mapping relationship between the "data identifier of the data 4" and the identifier set including the "data identifier of the data 2".

The mapping relationship corresponding to the data 5 includes: the mapping relationship between the "data identifier of the data 5" and the identifier set including the "data identifier of the data 2".

The mapping relationship corresponding to the data 6 includes: the mapping relationship between the "data identifier of the data 6" and the identifier set including the "data identifier of the data 3".

Referring to Fig. 1 again, in step S103, in the case of obtaining the corresponding mapping relationship of each data in the plurality of data respectively, the mapping relationship corresponding to at least two data whose data identifiers are intersected respectively is combined into a mapping relationship Set, there is no intersection of data identifiers in any two sets of mapping relationships.

In this application, among the mapping relationships corresponding to each of the multiple data in the database, some of the mapping relationships with intersections are combined into one mapping relationship set, and the other mapping relationships with intersection sets are combined into another mapping relationship set... ...and another part of mapping relations with intersections is combined into another set of mapping relations and so on.

In a possible case, multiple different sets of mapping relationships can be obtained. And there is no intersection of data identifiers in any two sets of mapping relations.

In this application, the data identification of the data is stored in the mapping relationship corresponding to each data, and is used to record the direct association relationship between the data. If there is an intersection of the data identification of the data in the mapping relationship corresponding to two data , then the data in the mapping relationship corresponding to the two data identifies that the corresponding data are related (have a direct relationship or an indirect relationship). In this way, the mapping relationships corresponding to the two data can be located in the same mapping relationship set, which is used to record that the data corresponding to the data identifiers in the mapping relationships corresponding to the two data are associated.

For example, in the case of obtaining the mapping relationship corresponding to each data in the plurality of data, the mapping relationship corresponding to at least two data whose data identifiers are intersected are combined into a mapping relationship set.

In this way, it is possible to associate the mapping relationships corresponding to the associated data in multiple data, that is, the data corresponding to the data identifiers in each mapping relationship in a mapping relationship set are associated (including direct association and indirect connection, etc.).

In an embodiment of the present application, in a possible situation, there may be more than two sets of mapping relationships obtained.

Following the example in step S102, the data identifiers in the mapping relationship corresponding to data 1 and the data identifiers in the mapping relationships corresponding to data 2 to 6 all have intersections. Therefore, the mapping relationship corresponding to data 1 and the data identifier corresponding to data 2 can be combined. The mapping relationship, the mapping relationship corresponding to data 3, the mapping relationship corresponding to data 4, the mapping relationship corresponding to data 5, and the mapping relationship corresponding to data 6 are combined into a mapping relationship set.

Following the example shown in FIG. 2 , it is assumed that the database also includes data 7 , data 8 , data 9 , and data 10 .

Data 7, data 8, data 9 and data 10 can be referred to as shown in FIG. 3 .

Wherein, data 7 and data 8 have a direct relationship, data 8 and data 10 have an association relationship, and data 7 and data 9 also have an association relationship.

Then the mapping relationship corresponding to the data 7 includes: the mapping relationship between the "data identifier of the data 7" and the identifier set including "the data identifier of the data 8 + the data identifier of the data 9".

The mapping relationship corresponding to the data 8 includes: the mapping relationship between the "data identifier of the data 8" and the identifier set including "the data identifier of the data 7 + the data identifier of the data 10".

The mapping relationship corresponding to the data 9 includes: the mapping relationship between the "data identifier of the data 9" and the identifier set including the "data identifier of the data 7".

The mapping relationship corresponding to the data 10 includes: the mapping relationship between the "data identifier of the data 10" and the identifier set including the "data identifier of the data 8".

The data identifiers in the mapping relationship corresponding to data 7 and the data identifiers in the mapping relationship corresponding to data 8 to 10 all have intersections, and the data identifiers in the mapping relationship corresponding to data 7 to 10 respectively correspond to data 1 to 6 respectively. There is no intersection between the data identifiers in the mapping relationship, therefore, the mapping relationship corresponding to data 7, the mapping relationship corresponding to data 8, the mapping relationship corresponding to data 9, and the mapping relationship corresponding to data 10 can be combined into another mapping relationship set .

In step S104, in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, the set identifier of the mapping relationship set and an identification set including the data identifiers in the mapping relationship set are stored.

In this step, different data in the database have different data identifiers. For any set of mapping relationships obtained in step S103, the set identifier of the set of mapping relationships can be set, wherein the set identifiers of different sets of mapping relationships in this application are different, and then the statistics of each mapping in the set of mapping relationships can be calculated The data identifiers included in the relationship (after deduplication), and the statistical data identifiers are combined into an identifier set, and then the set identifier of the mapping relationship set and the combined identifier set form a corresponding entry, and stored in the mapping In the corresponding relationship between the collection identifier of the relational collection and the data identifier of the data.

The same is true for each other set of mapping relationships obtained in step S103.

Through this application, it is possible to record the association relationship between multiple data in the database, so that when it is necessary to find at least the fourth data associated with the third data in the database including multiple data, it can be used in the mapping In the corresponding relationship between the set identifier of the relation set and the data identifier of the data, the set identifier of the mapping relation set corresponding to the data identifier of the third data is searched. Then, obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set, and then search at least the fourth data in the database according to the data identifiers respectively included in at least two mapping relationships in the obtained mapping relationship set.

It can be seen that in this application, it is not necessary to analyze all the data in the database to obtain the fourth data associated with the third data, so that it is not necessary to load each data in the database into the memory separately, but only according to the Analyze the data identifier of the fourth data associated with the third data by analyzing the mapping relationship set corresponding to the set identifier found in the above correspondence, and then obtain the fourth data in the database according to the data identifier of the fourth data.

It can be seen that the present application can only load the corresponding relationship between the set identification of the mapping relationship set and the data identification of the data in the memory, and the mapping relationship set corresponding to the set identification of the found mapping relationship set, thereby reducing the need to store data in the memory. Loaded data saves memory resources.

In addition, this application does not need to analyze the full amount of data in the database, but through the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data and the mapping relationship set corresponding to the set identifier of the found mapping relationship set Analysis means that on-demand analysis can be realized. For example, data that is not associated with the third data can be analyzed, reducing the amount of analyzed data, thereby improving query efficiency.

In addition, in the case where the level of association between data in the database is relatively complex, if it is necessary to at least find the fourth data associated with the third data in a database including multiple data, in one way, it can be recursively multiple times Using join query takes a lot of time, resulting in low query efficiency. However, in this application, by "searching for the set identifier of the mapping relationship set corresponding to the data identifier of the third data in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data" and "obtaining the found The set identification of the mapping relationship set corresponds to the mapping relationship set" two query steps, you can get the data identification of all the data associated with the third data, the two query steps can use a join query, that is, through this application, use A join query can obtain the data identifiers of all data associated with the third data, thereby improving query efficiency.

In this application, the data in the database may sometimes be updated according to the actual situation, for example, new data is added to the database, or old data is deleted from the database.

In the case of updating the data in the database, in this application, the data identification of the updated data can be updated in the corresponding relationship between the set identification of the mapping relationship set and the data identification of the data, and the related The mapping relationship collection of the updated data is updated.

So that the data in the database can correspond to the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, and the mapping relationship set can be corresponding.

In an example, when new data is added to the database, the data identifier of the new data can be added to the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data according to the following process, and, The set of mapping relations involving new data is updated.

Referring to FIG. 4, the update process 200 includes steps S201-S205.

In step S201, when new data is added to the database, the data identifier of the associated data that has a direct association relationship with the new data is determined in the database.

In this application, when new data is added to the database, the data identifier of the new data can be obtained, and then the data identifier of the associated data that has a direct relationship with the new data can be determined in the database.

When determining the associated data that has a direct relationship with new data in the database, the associated data that has a direct relationship with the new data can be determined through the detailed content of the data (for example, including the attributes of the data, etc.). For the determination method, reference may be made to the currently existing methods, and the present application does not limit the specific determination method.

In step S202, in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, the set identifier of the mapping relationship set corresponding to the data identifier of the associated data is searched.

There is a direct relationship between the associated data and the new data. The mapping relationship set corresponding to the associated data has a mapping relationship corresponding to the associated data. The mapping relationship corresponding to the associated data includes: the data identification of the associated data is directly associated with the associated data A mapping relationship between sets of identifiers for data identifiers for relational data.

Since new data is added to the database and there is a direct relationship between the new data and the associated data, the mapping between the data identifier of the associated data and the identifier set including the data identifiers of the data that has a direct relationship with the associated data The identifier set in the relationship should include the data identifier of the new data. And the mapping relationship set including the mapping relationship corresponding to the associated data should include the mapping relationship corresponding to the new data, and the mapping relationship corresponding to the new data may include: the data identifier of the new data and the data including the determined associated data The mapping relationship between identified identity sets.

At this time, there is no new data data identifier in the identifier set in the mapping relationship between the data identifier of the associated data and the identifier set including the data identifiers that have a direct relationship with the associated data, and the associated data includes the corresponding The mapping relationship set of the mapping relationship does not include the mapping relationship corresponding to the new data. Therefore, it is necessary to define the mapping relationship between the data identifier of the associated data and the identifier set including the data identifier of the data that has a direct relationship with the associated data. In the identification set, add the data identification of the new data, and need to add the mapping relationship corresponding to the new data in the mapping relationship set including the mapping relationship corresponding to the associated data.

In order to be able to add new data data identifiers to the identifier set in the mapping relationship between the data identifier of the associated data and the identifier set including the data identifiers that have a direct relationship with the associated data, and to be able to include the association Add a new mapping relationship corresponding to the data to the mapping relationship set of the mapping relationship corresponding to the data. In this application, after obtaining the data identification of the associated data, the correspondence between the set identification of the mapping relationship set and the data identification of the data can be In the relationship, look up the set identifier of the mapping relationship set corresponding to the data identifier of the associated data, and then execute step S203.

In step S203, the mapping relationship set corresponding to the set identification of the found mapping relationship set is acquired, and the acquired mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the new data, at least two data The mapping relationship corresponding to any one of the data includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifiers of the data directly associated with the data.

In this application, a plurality of mapping relationship sets are generated through steps S101 and S102 in the foregoing embodiments, and the set identifiers of each mapping relationship set are different. In this step, it can be obtained from the generated multiple mapping relationship sets The set identifier of the found mapping relationship set identifies the corresponding mapping relationship set. Then step S204 and step S205 are executed respectively.

Wherein, step S204 and step S205 may be executed in parallel or sequentially.

In step S204, in the obtained mapping relationship set, determine the mapping relationship corresponding to the associated data, the mapping relationship corresponding to the associated data includes: the data identifier of the associated data and the identifier of the data identifier including the data that has a direct relationship with the associated data For the mapping relationship between the collections, the data identifier of the new data is added to the identification set in the mapping relationship corresponding to the associated data.

The acquired mapping relationship set includes mapping relationships corresponding to at least two data, for example, mapping relationships corresponding to associated data associated with new data (including direct association and indirect association, etc.).

Wherein, the associated data associated with the new data includes: associated data having a direct association relationship with the new data, data having an indirect association relationship with the new data, and the like.

In this way, the mapping relationships corresponding to at least two data included in the obtained mapping relationship set are respectively the mapping relationship corresponding to the associated data having a direct relationship with the new data, and the association data having an indirect relationship with the new data. The mapping relationship corresponding to the data.

The mapping relationship corresponding to the associated data that has an indirect relationship with the new data does not need to involve the data identification of the new data, while the mapping relationship corresponding to the associated data that has a direct relationship with the new data needs to involve new data data identifier.

That is to say, there is no need to add the data identifier of the new data to the identifier set in the mapping relationship corresponding to the associated data that has an indirect relationship with the new data, but it is necessary to add the data identifier corresponding to the associated data that has a direct relationship with the new data. The data identifier of the new data is added to the identifier collection in the mapping relationship.

Therefore, in this application, in the obtained mapping relationship set, it is possible to determine the mapping relationship corresponding to the associated data with a direct relationship between the new data, and the mapping relationship corresponding to the associated data with a direct relationship between the new data. The mapping relationship includes: the mapping relationship between the data identification of the associated data that has a direct relationship with the new data and the identification set that includes the data identification of the data that has a direct relationship with the associated data, and then between the new data In the identification set in the mapping relationship corresponding to the associated data that has a direct relationship between them, add the data identification of the new data, so that the identification set in the mapping relationship corresponding to the associated data that has a direct relationship with the new data has a new The data identifier for the data.

In step S205, the mapping relationship corresponding to the new data is generated, and the mapping relationship corresponding to the new data includes: the mapping relationship between the data identifier of the new data and the identifier set including the determined data identifier of the associated data. The mapping relationship corresponding to the new data is added to the mapping relationship collection.

In this application, there may be one or more than two associated data in the database that have a direct association relationship with the new data.

Combine the determined data identifiers of the associated data into an identifier set (even if an associated data is determined, the data identifier of an associated data can be regarded as an identifier set), and then generate a new data identifier and include the determined The mapping relationship between the identification sets of the data identification of the extracted associated data is used as the corresponding mapping relationship of the new data.

In an embodiment, the mapping relationship between the data identifier of the new data and the identifier set including the determined data identifier of the associated data may be embodied in the form of a key-value pair "key-value".

For example, "key" may include "data identifier of new data", "value" may include "identification set including determined data identifiers of associated data", "identification set including determined data identifiers of associated data" It may be embodied in the form of an array, and the array includes the determined data identification of each associated data and the like.

Then, the mapping relationship corresponding to the new data can be added to the obtained mapping relationship set, so that the mapping relationship set including "the mapping relationship corresponding to the associated data with the new data has an association relationship" has the corresponding mapping relationship of the new data. Mapping relations.

In another example, when the old data is deleted in the database, the data identifier of the old data can be deleted in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data according to the following process, and Update the set of mapping relations involving old data.

Referring to Fig. 5, the update process 300 includes steps S301-S305.

In step S301, if the old data is deleted from the database, the data identifier of the associated data that has a direct association relationship with the old data is determined in the database.

In this application, when old data is deleted from the database, the data identifier of the old data can be obtained, and then the data identifier of the associated data that has a direct relationship with the old data can be determined in the database.

When determining the associated data that has a direct relationship with the old data in the database, you can determine the associated data that has a direct relationship with the old data through the detailed content of the data (for example, including the attributes of the data, etc.). For the determination method, reference may be made to the currently existing methods, and the present application does not limit the specific determination method.

However, the inventors found that it takes a long time to determine the associated data that has a direct relationship with the old data through the detailed content of the data (for example, including the attributes of the data, etc.).

Therefore, in order to further reduce the time required for the process of determining the associated data that is directly associated with the old data, in another embodiment of the present application, for any first data in the database, in the database After determining the second data that has a direct association relationship with the first data, the data identifier of the first data and the data identifier of the second data can be stored in the direct association table between the data identifier of the data and the data identifier of the data . The same is true for every other first data in the database.

And, after the data identification of the associated data that has a direct association relationship with the new data is determined in the database, the data identification of the new data can be stored in the direct association table between the data identification and the data identification The data identifier for the associated data.

In this way, when determining the data ID of the associated data that has a direct association relationship with the old data in the database, you can directly look up the data ID that is directly related to the old data in the direct association table between the data ID and the data ID. The data identifier of the data corresponding to the data identifier is used as the data identifier of the associated data that has a direct relationship with the old data. The data identification of the associated data that has a direct relationship with the old data can be obtained by looking up the table, thereby reducing the time spent on the process of determining the data identification of the associated data that has a direct relationship with the old data duration.

In step S302, in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, the set identifier of the mapping relationship set corresponding to the data identifier of the associated data is searched.

There is a direct relationship between the associated data and the old data, and the mapping relationship set corresponding to the associated data has a mapping relationship corresponding to the associated data. The mapping relationship corresponding to the associated data includes: the data identification of the associated data is directly associated with the associated data A mapping relationship between sets of identifiers for data identifiers for relational data.

Since old data is added to the database and there is a direct relationship between the old data and the associated data, the mapping between the data identifier of the associated data and the identifier set including the data identifiers of the data that has a direct relationship with the associated data In the identification set in the relationship, the data identification with old data should not be included. And the mapping relationship set including the mapping relationship corresponding to the associated data should not include the mapping relationship corresponding to the old data, and the mapping relationship corresponding to the old data may include: the data identifier of the old data and the The mapping relationship between the identity sets of data identifiers.

At this time, there are old data data identifiers in the identifier set in the mapping relationship between the data identifier of the associated data and the identifier set that includes the data identifiers that have a direct relationship with the associated data, and includes the mapping corresponding to the associated data. The mapping relationship set of the relationship includes the mapping relationship corresponding to the old data. Therefore, the identification in the mapping relationship between the data identification of the associated data and the identification set including the data identification of the data that has a direct relationship with the associated data is required In the set, the data identifier of the old data is deleted, and the mapping relationship corresponding to the old data needs to be deleted in the mapping relationship set including the mapping relationship corresponding to the associated data.

In order to be able to delete the data identifier of the old data in the identification set in the mapping relationship between the data identification of the associated data and the identification set including the data identification of the data that has a direct relationship with the associated data, and to be able to include the associated data Delete the mapping relationship corresponding to the old data from the mapping relationship set of the mapping relationship corresponding to the data. In this application, after obtaining the data identification of the associated data, the correspondence between the set identification of the mapping relationship set and the data identification of the data can be In the relationship, look up the set identifier of the mapping relationship set corresponding to the data identifier of the associated data, and then execute step S303.

In step S303, the mapping relationship set corresponding to the set identifier of the found mapping relationship set is acquired, and the acquired mapping relationship set includes: the mapping relationship corresponding to the old data and the corresponding mapping relationship of at least two data associated with the old data The mapping relationship, the mapping relationship corresponding to the old data includes: the mapping relationship between the data identifier of the old data and the identification set including the determined data identifier of the associated data, and the mapping relationship corresponding to any one of the at least two data Including: a mapping relationship between the data identifier of the data and an identifier set including the data identifiers of the data directly associated with the data.

In this application, a plurality of mapping relationship sets are generated through steps S101 and S102 in the foregoing embodiments, and the set identifiers of each mapping relationship set are different. In this step, it can be obtained from the generated multiple mapping relationship sets The set identifier of the found mapping relationship set identifies the corresponding mapping relationship set. Then step S304 and step S305 are executed respectively.

Wherein, step S304 and step S305 may be executed in parallel or sequentially.

In step S304, in the acquired mapping relationship set, determine the mapping relationship corresponding to the associated data, the mapping relationship corresponding to the associated data includes: the data identifier of the associated data and the identifier of the data identifier including the data that has a direct relationship with the associated data For the mapping relationship between the collections, in the identification set in the mapping relationship corresponding to the associated data, the data identification of the old data is deleted.

The acquired mapping relationship set includes at least two mapping relationships corresponding to the data, for example, the mapping relationship corresponding to the old data, and the associated data associated with the old data (including direct association and indirect association, etc.) mapping relationship.

Wherein, the associated data associated with the old data includes: associated data directly associated with the old data, data indirectly associated with the old data, and the like.

In this way, the mapping relationships corresponding to at least two data included in the obtained mapping relationship set are respectively the mapping relationship corresponding to the associated data having a direct relationship with the old data, and the association data having an indirect relationship with the old data. The mapping relationship corresponding to the data.

The mapping relationship corresponding to the associated data that has an indirect relationship with the old data does not involve the data identification of the old data, while the mapping relationship corresponding to the associated data that has a direct relationship with the old data involves the old data data-identified.

That is to say, there is no data identifier of the old data in the identifier set in the mapping relationship corresponding to the associated data having an indirect relationship with the old data, therefore, there is no need for the The data identifier of the old data is deleted from the identifier set in the mapping relationship.

However, there is a data identifier of the old data in the identifier set in the mapping relationship corresponding to the associated data that has a direct relationship with the old data. Therefore, it is necessary to have a The data identifier for deleting old data in the identifier collection.

Therefore, in this application, in the obtained mapping relationship set, there may be a mapping relationship corresponding to the associated data that has a direct relationship between old data, and a mapping corresponding to the associated data that has a direct relationship between old data. The relationship includes: the mapping relationship between the data identifier of the associated data that has a direct relationship with the old data and the identifier set that includes the data identifier of the data that has a direct relationship with the associated data, and then between the old data In the identification set in the mapping relationship corresponding to the associated data with a direct relationship, delete the data identification of the old data, so that the identification set in the mapping relationship corresponding to the associated data that has a direct relationship with the old data no longer has The data ID of the old data.

In this application, there may be one or more than two associated data that have a direct association relationship with the old data in the database.

In step S305, in the acquired mapping relationship set, the mapping relationship corresponding to the old data is deleted.

Through this step, the mapping relationship set including "the mapping relationship corresponding to the associated data having an association relationship with the old data does not include the mapping relationship corresponding to the old data.

Sometimes, according to actual needs, it may be necessary to query multiple data stored in the database. For example, because some data in the database are related, for example, there is a direct relationship or an indirect relationship. Therefore, there are Sometimes you need to query a certain data in the database, and you need to query other data associated with the data in the database.

In this case, the data association can be queried by means of the data identifier of the data, the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, and the mapping relationship corresponding to at least two data in the mapping relationship set other data. Wherein, the mapping relationship corresponding to any piece of data includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifier of the associated data having a direct relationship with the data, and the like.

Referring to Fig. 6, the query step 400 includes steps S401-S404.

In step S401, in a case where at least fourth data associated with the third data needs to be searched in a database including multiple data, a data identifier of the third data is acquired.

The data identifier of the third data may be input by the user, or obtained by the electronic device according to actual needs.

In step S402, in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, the set identifier of the mapping relationship set corresponding to the data identifier of the third data is searched.

In this application, through the embodiment shown in FIG. 1 , in the database, the mapping relationship corresponding to the third data and the mapping relationship corresponding to the fourth data associated with the third data are respectively located in the same mapping relationship set, and the The set identification of the mapping relationship set and the identification set including the data identification of the third data and the data identification of each fourth data are located in the corresponding relationship between the set identification of the mapping relationship set and the data identification of the data in the form of corresponding entries middle.

In order to search for the fourth data associated with the third data in the database including multiple data, it is first necessary to obtain the data identification of the fourth data associated with the third data.

In order to obtain the data identifier of the fourth data associated with the third data, the mapping relationship corresponding to the third data and the mapping relationship corresponding to the fourth data associated with the third data (including direct association and indirect association, etc.) may be obtained.

In order to obtain the mapping relationship corresponding to the third data and the mapping relationship corresponding to the fourth data associated with the third data (including direct association and indirect association, etc.), it is necessary to obtain the mapping relationship corresponding to the third data and the mapping relationship with the third data. A mapping relationship set of mapping relationships corresponding to the fourth data (including direct association and indirect association, etc.).

In order to obtain the mapping relationship set including the mapping relationship corresponding to the third data and the mapping relationship corresponding to the fourth data associated with the third data (including direct association and indirect association, etc.), in this application, the set of mapping relationship sets can be In the corresponding relationship between the identifier and the data identifier of the data, the set identifier of the mapping relationship set corresponding to the data identifier of the third data is searched, and then step S403 is executed.

In step S403, the mapping relationship set corresponding to the set identification of the found mapping relationship set is acquired, and the acquired mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the third data, at least two data The mapping relationship corresponding to any one of the data includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifiers of the data directly associated with the data.

In this application, a plurality of mapping relationship sets are generated through steps S101 and S102 in the foregoing embodiments, and the set identifiers of each mapping relationship set are different. In this step, it can be obtained from the generated multiple mapping relationship sets The set identifier of the found mapping relationship set identifies the corresponding mapping relationship set. Then step S404 is executed.

In step S404, at least the fourth data is searched in the database according to the data identifiers respectively included in at least two mapping relationships in the acquired mapping relationship set.

In the database, the corresponding relationship between the data identifier and the data is stored.

If the fourth data associated with the third data needs to be searched in the database, the data identification of the fourth data needs to be obtained.

For the data identification of the fourth data, it may be acquired through at least two mapping relationships in the acquired mapping relationship set.

For example, in an example, data identifiers respectively included in at least two mapping relationships in the mapping relationship set may be acquired.

For example, in the acquired mapping relationship set, for any mapping relationship corresponding to data, the mapping relationship corresponding to the data includes: the difference between the data identifier of the data and the identifier set including the data identifiers of the data directly related to the data mapping relationship between them. Each data identifier in the mapping relationship can be obtained, and for each other mapping relationship corresponding to data, the above operation is also performed to obtain each data identifier in the mapping relationship set.

Then the fourth data may be acquired in the database according to the acquired data identifier. For example, the obtained data identification can be deduplicated, and the data identification of the third data can be removed, and the remaining data identification is the data identification of the fourth data associated with the third data, so that the data identification can be based on the data identification of the fourth data. Acquiring the fourth data in the database, for example, searching for the data corresponding to the data identifier of the fourth data in the corresponding relationship between the data identifier and the data in the database, and using it as the fourth data.

According to this application, in the case where at least the fourth data associated with the third data needs to be searched in the database including multiple data, the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data can be searched for. The set identifier of the mapping relationship set corresponding to the data identifier of the three data. Then, obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set, and then search at least the fourth data in the database according to the data identifiers respectively included in at least two mapping relationships in the obtained mapping relationship set.

In addition, sometimes according to actual needs, the user may need to view the schematic diagram of the direct relationship between the third data and at least part of the fourth data and the direct relationship between each fourth data, so as to understand the third data and the fourth data Analyze statistics, etc. In this case, the electronic device can obtain the third data and the obtained fourth data, rendering a schematic diagram for indicating the direct relationship between the third data and at least part of the fourth data and the direct relationship between each fourth data.

For example, according to the data identifiers in at least two mapping relationships in the acquired mapping relationship set, the direct association relationship between the third data and at least part of the fourth data and the direct association relationship between each fourth data can be determined. , and then according to the direct relationship between the third data and at least part of the fourth data and the direct relationship between each fourth data, a schematic diagram including the third data and the fourth data can be rendered, and the schematic diagram can indicate that The direct association relationship between the third data and at least part of the fourth data, the direct association relationship between each fourth data, and the like.

For example, in an embodiment, in the schematic diagram, two pieces of data having a direct relationship are connected by a line segment, so as to indicate that the two pieces of data have a direct relationship and the like.

It should be noted that, for the method embodiment, for the sake of simple description, it is expressed as a series of action combinations, but those skilled in the art should know that the application is not limited by the described action sequence, because according to this Certain steps may be performed in another order or simultaneously, if applicable. Secondly, those skilled in the art should also know that the actions involved in the embodiments described in the specification are not necessarily required by the present application.

Referring to FIG. 7 , it shows a structural block diagram of a data processing device of the present application, which may specifically include the following modules: a first determining module 11, configured to store multiple data in the database, for multiple For any one of the first data in the data, determine the second data that has a direct relationship with the first data in the database; the first generation module 12 is used to generate the mapping relationship corresponding to the first data, the first The mapping relationship corresponding to one data includes: the mapping relationship between the data identifier of the first data and the identifier set including the determined data identifier of the second data; the combination module 13 is used to obtain each data in the plurality of data respectively In the case of the corresponding mapping relationship, at least two data corresponding to the included data identifiers that have an intersection are combined into a mapping relationship set, and the data identifiers in any two mapping relationship sets do not have an intersection; the first storage module 14. In the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, store the set identifier of the mapping relationship set and an identification set including the data identifiers in the mapping relationship set.

In one embodiment, the device further includes: a second determination module, configured to determine in the database the data of the associated data that has a direct association relationship with the new data when new data is added to the database Identification; the first search module is used to search for the set identification of the mapping relationship set corresponding to the data identification of the associated data in the corresponding relationship between the set identification of the mapping relationship set and the data identification of the data; the first acquisition module, It is used to obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set. The obtained mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the new data, and any one of the at least two data The mapping relationship corresponding to the data includes: the mapping relationship between the data identification of the data and the identification set including the data identification of the data that has a direct relationship with the data; the third determination module is used to obtain the mapping relationship set In this method, the mapping relationship corresponding to the associated data is determined, the mapping relationship corresponding to the associated data includes: the mapping relationship between the data identifier of the associated data and the identifier set including the data identifier of the data that has a direct association relationship with the associated data, the first adding module is used to add the data identifier of new data to the identifier set in the mapping relationship corresponding to the associated data; the second generation module is used to generate the mapping relationship corresponding to the new data, and the mapping relationship corresponding to the new data includes: new The mapping relationship between the data identification of the data and the identification set including the determined data identification of the associated data, the second adding module is used to add the mapping relationship corresponding to the new data in the obtained mapping relationship set.

In one embodiment, the device further includes: a fourth determination module, configured to determine in the database the data of the associated data that has a direct association relationship with the old data in the case that the old data is deleted in the database Identification; the second search module is used to search for the set identification of the mapping relationship set corresponding to the data identification of the associated data in the corresponding relationship between the set identification of the mapping relationship set and the data identification of the data; the second acquisition module, It is used to acquire the mapping relationship set corresponding to the set identification of the found mapping relationship set, and the acquired mapping relationship set includes: the mapping relationship corresponding to the old data and the mapping relationship corresponding to at least two data associated with the old data, The mapping relationship corresponding to the old data includes: the mapping relationship between the data identifier of the old data and the identification set including the determined data identifier of the associated data, and the mapping relationship corresponding to any one of the at least two data includes: The mapping relationship between the data identification and the identification set including the data identification of the data that has a direct relationship with the data; the fifth determination module is used to determine the mapping relationship corresponding to the associated data in the obtained mapping relationship set, and the associated data The corresponding mapping relationship includes: the mapping relationship between the data identification of the associated data and the identification set including the data identification of the data that has a direct relationship with the associated data, and the second deletion module is used for the mapping relationship corresponding to the associated data. In the identification set, delete the data identification of the old data; the first deletion module is used to delete the mapping relationship corresponding to the old data in the obtained mapping relationship set.

In one embodiment, the device further includes: a second storage module, configured to, after determining the second data that has a direct relationship with the first data in the database, after the data identification of the data and the data of the data The data identifier of the first data and the data identifier of the second data are stored in the direct association table between identifiers.

In an embodiment, the fourth determining module is specifically configured to: search for the data identifier of the data corresponding to the old data identifier in the direct association table between the data identifier and the data identifier, And as the data identifier of the associated data that has a direct relationship with the old data.

Referring to FIG. 8 , it shows a structural block diagram of a data processing device of the present application, and the device may specifically include the following modules: a third acquisition module 21, configured to search at least the third data in a database including multiple data In the case of the associated fourth data, obtain the data identifier of the third data; the third search module 22 is configured to search for the data of the third data in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data Identify the set identifier of the corresponding mapping relationship set; the fourth acquisition module 23 is used to acquire the mapping relationship set corresponding to the set identifier of the found mapping relationship set, and the acquired mapping relationship set includes: at least The mapping relationship corresponding to the two data, the mapping relationship corresponding to any one of the at least two data includes: the mapping between the data identifier of the data and the identifier set including the data identifier of the data that has a direct relationship with the data Relationship; the fourth search module 24 is configured to search at least fourth data in the database according to the data identifiers respectively included in at least two mapping relationships in the acquired mapping relationship set.

In one embodiment, the fourth search module includes: a first acquisition unit, configured to acquire the at least two mapping relationships in the mapping relationship set that respectively include data identifiers; a second acquisition unit, configured to It is identified that at least fourth data is acquired in the database.

In an embodiment, the device further includes: a rendering module, configured to obtain data identifiers respectively included in the at least two mapping relationships in the acquired mapping relationship set and data identifiers of the third data. The third data and the fourth data render a schematic diagram for indicating the direct association relationship between the third data and at least part of the fourth data and the direct association relationship between each fourth data.

The embodiment of the present application also provides a non-volatile readable storage medium, and one or more modules (programs) are stored in the storage medium. When the one or more modules are applied to the device, the device can execute Instructions for each method step in the embodiments of the present application.

The embodiments of the present application provide one or more machine-readable media, on which instructions are stored, and when executed by one or more processors, the electronic device executes the method described in one or more of the above embodiments. In the embodiment of the present application, the electronic device includes a server, a gateway, a sub-device, etc., and the sub-device is an Internet of Things device or the like.

Embodiments of the present disclosure can be implemented as an apparatus using any appropriate hardware, firmware, software, or any combination thereof to perform desired configurations, and the apparatus may include servers (clusters), terminal devices such as IoT devices and other electronic devices.

FIG. 9 schematically illustrates an exemplary apparatus 1300 that may be used to implement various embodiments described in this application.

For one embodiment, FIG. 9 illustrates an exemplary apparatus 1300 having one or more processors 1302, a control module (chipset) 1304 coupled to at least one of the processor(s) 1302 , memory 1306 coupled to control module 1304, non-volatile memory (NVM)/storage device 1308 coupled to control module 1304, one or more input/output devices 1310 coupled to control module 1304, and Coupled to the network interface 1312 of the control module 1304 .

The processor 1302 may include one or more single-core or multi-core processors, and the processor 1302 may include any combination of general-purpose processors or special-purpose processors (such as graphics processors, application processors, baseband processors, etc.). In some embodiments, the apparatus 1300 can serve as a server device such as a gateway in the embodiments of this application.

In some embodiments, apparatus 1300 may include one or more computer-readable media (e.g., memory 1306 or NVM/storage 1308) having instructions 1314 and in combination with the one or more computer-readable media configured to The one or more processors 1302 execute instructions 1314 to implement modules to perform the actions described in this disclosure.

For one embodiment, the control module 1304 may include any suitable interface controller to provide any suitable Interface.

The control module 1304 may include a memory controller module to provide an interface to the memory 1306 . A memory controller module may be a hardware module, a software module and/or a firmware module.

Memory 1306 may be used, for example, to load and store data and/or instructions 1314 for apparatus 1300 . For one embodiment, memory 1306 may comprise any suitable volatile memory, such as suitable DRAM. In some embodiments, memory 1306 may include Double Data Rate Quad Synchronous Dynamic Random Access Memory (DDR4 SDRAM).

For one embodiment, control module 1304 may include one or more input/output controllers to provide interfaces to NVM/storage device(s) 1308 and input/output device(s) 1310 .

For example, NVM/storage 1308 may be used to store data and/or instructions 1314 . NVM/storage 1308 may include any suitable non-volatile memory (e.g., flash memory) and/or may include any suitable non-volatile storage device(s) (e.g., one or more hard drives ( HDD), one or more compact disc (CD) drives, and/or one or more digital versatile disc (DVD) drives).

NVM/storage 1308 may include storage resources that are physically part of the device on which apparatus 1300 is installed, or may not necessarily be part of the device that are accessible by the device. For example, NVM/storage 1308 may be accessed over a network via input/output device(s) 1310 .

The input/output device(s) 1310 may provide an interface for the apparatus 1300 to communicate with any other suitable device, and the input/output device 1310 may include a communication component, a pinyin component, a sensor component, and the like. Network interface 1312 may provide an interface for device 1300 to communicate over one or more networks, and device 1300 may communicate with one or more wireless networks according to any of one or more wireless network standards and/or protocols. Components communicate wirelessly, such as accessing wireless networks based on communication standards, such as WiFi, 2G, 3G, 4G, 5G, etc., or a combination of them for wireless communication.

For one embodiment, at least one of the processor(s) 1302 may be packaged with the logic of one or more controllers of the control module 1304 (eg, a memory controller module). For one embodiment, at least one of the processor(s) 1302 may be packaged with the logic of one or more controllers of the control module 1304 to form a system-in-package (SiP). For one embodiment, at least one of the processor(s) 1302 may be integrated on the same die as the logic of the one or more controllers of the control module 1304 . For one embodiment, at least one of the processor(s) 1302 may be integrated on the same die with the logic of the one or more controllers of the control module 1304 to form a system on chip (SoC).

In various embodiments, the apparatus 1300 may be, but not limited to, a terminal device such as a server, a desktop computing device, or a mobile computing device (eg, a laptop computing device, a handheld computing device, a tablet computer, a netbook, etc.). In various embodiments, device 1300 may have more or fewer components and/or a different architecture. For example, in some embodiments, device 1300 includes one or more cameras, a keyboard, a liquid crystal display (LCD) screen (including a touchscreen display), a non-volatile memory port, multiple antennas, a graphics chip, an application-specific integrated circuit ( ASIC) and speakers.

An embodiment of the present application provides an electronic device, including: one or more processors; and one or more machine-readable media having instructions stored thereon, when executed by the one or more processors, The electronic device is caused to perform one or more of the methods described in this application.

As for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and for related parts, please refer to the part of the description of the method embodiment.

Each embodiment in this specification is described in a progressive manner, each embodiment focuses on the difference from other embodiments, and the same and similar parts of each embodiment can be referred to each other.

Embodiments of the present application are described with reference to flowcharts and/or block diagrams of methods, terminal devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each procedure and/or block in the flowchart and/or block diagram, and a combination of procedures and/or blocks in the flowchart and/or block diagram can be realized by computer program instructions. These computer program instructions can be provided to a general-purpose computer, special purpose computer, embedded processor or processor of other programmable information processing terminal equipment to produce a machine, so that the instructions executed by the computer or other programmable information processing terminal equipment Produce means for realizing the functions specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable information processing terminal to operate in a specific manner, such that the instructions stored in the computer-readable memory produce an article of manufacture comprising instruction means, the The instruction means implements the functions specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions can also be loaded into a computer or other programmable information processing terminal equipment, so that a series of operation steps are executed on the computer or other programmable terminal equipment to produce computer-implemented processing, so that the computer or other programmable terminal equipment The instructions executed above provide steps for implementing the functions specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

While a few embodiments of the present application have been described, additional changes and modifications can be made to these embodiments by those skilled in the art once the basic inventive concept is appreciated. Therefore, the appended claims are intended to be construed to include these embodiments and all changes and modifications that fall within the scope of the embodiments of the application.

Finally, it should also be noted that in this text, relational terms such as first and second etc. are only used to distinguish one entity or operation from another, and do not necessarily require or imply that these entities or operations, any such actual relationship or order exists. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or terminal equipment comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements identified, or also include elements inherent in such a process, method, article, or terminal equipment. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or terminal device comprising said element.

The data processing method and device provided by the application have been introduced in detail above. The principles and implementation methods of the application have been explained by using specific examples in this paper. The descriptions of the above embodiments are only used to help understand the methods and methods of the application. Its core idea; at the same time, for those of ordinary skill in the art, according to the idea of this application, there will be changes in the specific implementation and application scope. limit.

Claims

A data processing method, the method comprising:

In the case of storing a plurality of data in the database, for any first data in the plurality of data, determine in the database the second data that has a direct association relationship with the first data; generate the first data The mapping relationship corresponding to the data, the mapping relationship corresponding to the first data includes: the mapping relationship between the data identifier of the first data and the identifier set including the determined data identifier of the second data;

In the case of obtaining the mapping relationships corresponding to each data in the plurality of data, the mapping relationships corresponding to at least two data whose included data identifiers have intersections are combined into a mapping relationship set, and any two mapping relationship sets in There is no intersection of data identifiers;

In the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, the set identifier of the mapping relationship set and an identification set including the data identifiers in the mapping relationship set are stored.
The method according to claim 1, wherein the method further comprises:

When new data is added to the database, determine in the database the data identification of the associated data that has a direct relationship with the new data;

Finding the set identifier of the mapping relationship set corresponding to the data identifier of the associated data in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data;

Obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set. The obtained mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the new data, and any one of the at least two data corresponds to The mapping relationship includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifier of the data having a direct relationship with the data;

In the acquired mapping relationship set, determine the mapping relationship corresponding to the associated data. The mapping relationship corresponding to the associated data includes: the mapping between the data identifier of the associated data and the identifier set including the data identifier of the data that has a direct relationship with the associated data. Relationship, in the identification set in the mapping relationship corresponding to the associated data, add the data identification of the new data;

And, generate a mapping relationship corresponding to the new data, the mapping relationship corresponding to the new data includes: the mapping relationship between the data identifier of the new data and the identifier set including the determined data identifier of the associated data, and the acquired mapping relationship In the collection, add the mapping relationship corresponding to the new data.
The method according to claim 1, wherein the method further comprises:

In the case that the old data is deleted in the database, determine the data identification of the associated data that has a direct relationship with the old data in the database;

Finding the set identifier of the mapping relationship set corresponding to the data identifier of the associated data in the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data;

Obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set, the acquired mapping relationship set includes: the mapping relationship corresponding to the old data and the mapping relationship corresponding to at least two data associated with the old data, the old The mapping relationship corresponding to the data includes: the mapping relationship between the data identifier of the old data and the identification set including the determined data identifier of the associated data, and the mapping relationship corresponding to any one of the at least two data includes: the data The mapping relationship between the data identifier of the data and the identifier set including the data identifier of the data having a direct relationship with the data;

In the acquired mapping relationship set, determine the mapping relationship corresponding to the associated data. The mapping relationship corresponding to the associated data includes: the mapping between the data identifier of the associated data and the identifier set including the data identifier of the data that has a direct relationship with the associated data. relationship, in the identification set in the mapping relationship corresponding to the associated data, delete the data identification of the old data;

And, in the acquired mapping relationship set, delete the mapping relationship corresponding to the old data.
The method according to claim 3, wherein the method further comprises:

After the second data having a direct association relationship with the first data is determined in the database, the data identifier and the data identifier of the first data are stored in a direct association table between the data identifier and the data identifier. The data identifier of the second data.
The method according to claim 4, wherein said determining in the database the data identification of the associated data that has a direct association relationship with the old data comprises:

In the direct association table between the data ID and the data ID, find the data ID corresponding to the old data ID, and use it as the associated data that has a direct association relationship with the old data Data ID.
A data processing method, the method comprising:

Acquiring the data identifier of the third data when it is necessary to search at least fourth data associated with the third data in the database including multiple data;

In the corresponding relationship between the set identifier of the mapping relationship set and the data identifier of the data, search for the set identifier of the mapping relationship set corresponding to the data identifier of the third data;

Obtain the mapping relationship set corresponding to the set identifier of the found mapping relationship set. The obtained mapping relationship set includes: the mapping relationship corresponding to at least two data associated with the third data, and any one of the at least two data corresponds to The mapping relationship includes: the mapping relationship between the data identifier of the data and the identifier set including the data identifier of the data having a direct relationship with the data;

At least the fourth data is searched in the database according to the data identifiers respectively included in at least two mapping relationships in the acquired mapping relationship set.
The method according to claim 6, wherein, according to the data identifiers respectively included in at least two mapping relationships in the acquired mapping relationship set, searching for at least the fourth data in the database includes:

Obtaining the at least two mapping relationships in the mapping relationship set respectively include data identifiers;

At least fourth data is acquired in the database according to the acquired data identification.
The method according to claim 6 or 7, wherein the method further comprises:

According to the data identifiers respectively included in the at least two mapping relationships in the obtained mapping relationship set, the third data obtained according to the data identifier of the third data, and the fourth data, rendering a display for indicating the first A schematic diagram of the direct relationship between the third data and at least part of the fourth data and the direct relationship between each fourth data.
An electronic device comprising a memory, a processor, and a computer program stored on the memory and operable on the processor, wherein the processor implements any one of claims 1 to 8 when executing the program. The steps of the method.
A computer-readable storage medium, wherein a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 8 are implemented.