WO2018201887A1

WO2018201887A1 - Data response method, apparatus, terminal device, and medium

Info

Publication number: WO2018201887A1
Application number: PCT/CN2018/083297
Authority: WO
Inventors: 曾芳
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-05-05
Filing date: 2018-04-17
Publication date: 2018-11-08
Also published as: CN107798038A; CN107798038B

Abstract

The present invention applies to the field of database technology and provides a data response method, an apparatus, a terminal device, and a medium. The method comprises: obtaining associated data distributed over a plurality of first databases; obtaining first feature information of the associated data; establishing a mapping relation between the first feature information and the associated data, and storing the first feature information and the mapping relation in a second database; obtaining a data management operation request carrying second feature information and issued by a client to the second database; determining among multiple sets of the first feature information stored by the second database, the first feature information identical to the second feature information, and determining, according to the mapping relation, the associated data matching the data management operation request; and according to the data management operation request, performing a data management operation on the determined associated data so as to respond to the data management operation request. The present invention achieves unified data processing, such that a client does not need to perform a data management operation by implementing multiple sharding actions, thus improving data management efficiency.

Description

Data response method, device, terminal device and medium

The present application claims priority to Chinese Patent Application No. 200910313344.1, entitled "Data Response Method and Data Response Device", filed on May 5, 2017, the entire contents of which is incorporated herein by reference. .

Technical field

The present application belongs to the field of database technologies, and in particular, to a data response method, device, terminal device and medium.

Background technique

A database for managing the information resources of the enterprise has been established within the existing major enterprises. In order to avoid the problem that all information resources are stored in the same database, resulting in excessive database pressure and degraded database reliability, information resources of different service categories are usually stored in different databases. This storage method also realizes the classification management of data to a certain extent. However, since the information resources are distributed in different databases, the storage method also has the problem that the data is difficult to be uniformly processed. Specifically, the effective data that the user actually needs is usually not only an information resource of a certain category, and thus needs to jointly call information resources in multiple databases to achieve the data management purpose of the user. For the user's data management process, the data management operation needs to be performed multiple times in the library, and the operation is cumbersome. Therefore, the data management efficiency is relatively low.

technical problem

In view of this, the embodiment of the present application provides a data response method and a data response device to solve the problem that the data management efficiency in the prior art is relatively low and the unified processing of data is difficult to implement.

Technical solution

A first aspect of the embodiments of the present application provides a data response method, including:

Obtaining associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed together during a data operation;

Obtaining first feature information of the associated data;

Establishing a mapping relationship between the first feature information and the associated data, and storing the first feature information and the mapping relationship to a pre-established second database;

Obtaining a data management operation request that is sent by the client to the second database and carries the second feature information;

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the second feature information, and determining an association that matches the data management operation request according to the mapping relationship data;

And performing data management operations on the determined associated data according to the data management operation request to respond to the data management operation request.

A second aspect of an embodiment of the present application provides a data response apparatus including means for performing the data response method of the first aspect described above.

A third aspect of the embodiments of the present application provides a terminal device, including a memory and a processor, where the computer stores computer readable instructions executable on the processor, the processor executing the computer The steps of the data response method as described in the first aspect are implemented when the instructions are read.

A fourth aspect of the embodiments of the present application provides a computer readable storage medium storing computer readable instructions, the computer readable instructions being executed by a processor to implement the first aspect as described in the first aspect The steps of the data response method.

Beneficial effect

In the embodiment of the present application, when the data management operation request for the feature information is received, the second database is used as a bridge to directly process the associated data corresponding to the feature information in the plurality of first databases in the background. The unified processing of data is realized, and the user does not need to perform data management operations of multiple sub-databases, thereby improving data management efficiency.

DRAWINGS

1 is a system architecture diagram applicable to a data response method provided by an embodiment of the present application;

2 is a flowchart of an implementation of a data response method provided by an embodiment of the present application;

3 is a specific implementation flowchart of a data response method S202 provided by an embodiment of the present application;

4 is a specific implementation flowchart of a data response method S205 provided by an embodiment of the present application;

FIG. 5 is a specific implementation flowchart of a data response method S206 provided by an embodiment of the present application;

FIG. 6 is a flowchart of a specific implementation of a data response method S206 according to another embodiment of the present application;

7 is a structural block diagram of a data response apparatus according to an embodiment of the present application;

FIG. 8 is a schematic diagram of a terminal device according to an embodiment of the present application.

Embodiments of the invention

In order to explain the technical solutions described in the present application, the following description will be made by way of specific embodiments.

FIG. 1 is a system architecture diagram of a data response method provided by an embodiment of the present application. For convenience of description, only parts related to the embodiment are shown.

Referring to Figure 1, the system consists of a second database 11, a client 12 and a plurality of independent first databases 13. Each of the first databases 13 is used to store basic data of different service categories. The second database 11 is configured to read the correlation data in the first database 13 according to the mutual relationship between the basic data of different service categories, and determine the feature information of the associated data, so as to match the feature information and the feature information. The mapping relationship between the associated data is stored. At the same time, the second database 11 is further configured to provide the client 12 with the feature information-based data management operation response service to determine the data management operation request in the first database 13 according to the mapping relationship between the stored feature information and the associated data. After the corresponding associated data, the data management operation on the associated data is implemented and the response result is returned, so that the client 12 can browse or manage the data actually stored in the first database 13 according to the response result.

In this system, the client 12 can be an application client or a web client, and runs on a terminal device that provides network access functions, including a personal computer, a tablet, or a mobile phone. Each client 12 can serve as a request client of a data management operation, submit a data management operation request to the second database 11, and display a plurality of data records or display users required by the user according to the response result returned by the data management operation. Whether the management operation of the data is completed.

For ease of understanding, in the various embodiments below, the back-end database is the first database, and the intermediate database is the second database.

FIG. 2 is a flowchart showing an implementation process of a data response method provided by an embodiment of the present application, which is described in detail as follows:

S201: Acquire associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed jointly during a data operation.

In the embodiment of the present application, the intermediate database establishes a dblink connection with multiple databases independently in the background. With dblink, the intermediate database can access the data stored in the backend database just like a local database.

Each database in the background stores multiple data tables, each of which contains multiple fields and contains attribute values corresponding to each record in each field. In practice, the same two fields may exist in different databases or different data tables. If a field abc in one data table A is the primary key field abc in another data table B, and another field efg included in the data table A also exists in the data table B, the two data tables are related to each other. Data sheet. In the above-mentioned interrelated data table B, there are N attribute values under the primary key field, and each attribute value corresponds to one record, and for each record corresponding to each attribute value, it corresponds to the attribute value in the data table A. One record is associated data. In the process of a data management operation, since the associated data is distributed in multiple data tables or multiple databases, and the associated data is consistent, it is necessary to perform the same data management operation in each data table to achieve The purpose of joint processing.

For example, when the user needs to modify the attribute value of the field efg corresponding to a certain attribute value in the primary key field abc in the data table B, the user also needs to use the data in the data table A under the field abc. The attribute value of the field efg corresponding to the attribute value is subjected to the same modification operation to ensure data consistency and integrity.

When the intermediate database receives the read instruction based on the multiple associated data tables input by the data administrator, the intermediate database reads the multiple associated data tables, and uses the union The all method connects multiple associated data tables to identify multiple sets of associated data between the associated data tables.

S202: Acquire first feature information of the associated data.

In the embodiment of the present application, the feature information is information capable of describing a constraint condition between each group of associated data.

As an embodiment of the present application, as shown in FIG. 3, the foregoing S202 specifically includes: S301: respectively acquiring attribute values of each data in the associated data. S302: Create an attribute group. S303: If the attribute values of the at least two data are the same, the attribute value is stored in the attribute group.

For each set of associated data, it can be known from the above S201 that there are substantially multiple records in the data table having mutually constrained relationships, and the records have two or more identical attribute values, and one of the attribute values is a primary key. value. Thus, these same attribute values in the associated data can be read and the fields corresponding to each attribute value can be determined. Also, create an attribute group for each set of associated data. If each of the attribute values in each set of associated data has the same attribute value of at least two data, the attribute value is stored in the attribute group.

S304: Add a first operation field to the attribute group, and output the attribute group including the first operation field as the first feature information.

Add an operation field for the attribute group corresponding to each group of associated data. The action field is used to mark the type of data management operations that the attribute group is allowed to perform, including deleting, querying, modifying, and disabling all types. The action field can be set by the database administrator in accordance with the data management authority. Add each attribute group after the operation field to its corresponding set of characteristic information of the associated data. In the embodiment of the present application, the feature information of each group of associated data acquired by the intermediate database is referred to as first feature information, and the operation field included in the first feature information is referred to as a first operation field.

S203: Establish a mapping relationship between the first feature information and the associated data, and store the first feature information and the mapping relationship to a pre-established second database.

It can be seen from the above steps that the specific generated first feature information can be used to represent the constraint condition between each group of associated data, and therefore, the first feature information has a mapping relationship with a group of associated data. The intermediate database stores a mapping relationship between each of the first feature information and its corresponding set of associated data.

Specifically, in the preset mapping relationship data table, the feature information field is the primary key, and each of the first feature information is used as each primary key value in the mapping relationship data table, and each of the first feature information corresponds to one. The data table name and database name of each record in the group association data are the attribute values of the remaining fields in the mapping relationship data table.

S204: Obtain a data management operation request that is sent by the client to the second database and carries the second feature information.

In the client running on the terminal device, the user selects a field name in any number of field option drop-down boxes displayed by the client, and generates a real-time attribute value matching the selected multiple field names. In the Options drop-down box, select the multiple attribute values that you want to perform data management operations on. And, in the data management operation drop-down box displayed by the client, select the type of data management operation that you need to perform on the above multiple attribute values.

If the data management operation type selected by the user is a query, after the client receives the confirmation instruction issued by the user, the client generates second feature information, and encapsulates the second feature information in the data management operation request to Data management operation requests are sent to the intermediate database. The second feature information includes the option values respectively corresponding to the respective drop-down boxes.

If the data management operation type selected by the user is modified, the client generates an input box corresponding to each attribute value selected by the user, so that the user types the parameter value modified by the attribute value in the input box. After the client receives the confirmation command issued by the user, the client generates second feature information, and encapsulates the second feature information in the data modification operation request to send the data modification operation request to the intermediate database. The second feature information includes an option value corresponding to each of the above-mentioned drop-down boxes and a parameter value in the input box.

S205: Determine, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the second feature information, and determine, according to the mapping relationship, that the data management operation request is matched. Linked data.

In the feature information field of the mapping relationship data table, the intermediate database searches for the first feature information that is the same as the second feature information, and reads the corresponding data table stored in the record according to the record in which the first feature information is located. Name and database name. The intermediate database determines that the associated data corresponding to the first feature information is each record stored in each data table of the background database, wherein each database in which the record is located is a back-end database corresponding to the read database name, and each The data table in which a record is located is the data table corresponding to the read data table name in the background database. In the embodiment of the present application, each determined record is associated data that matches the data management operation request.

As an embodiment of the present application, the second feature information includes an attribute group and a second operation field. As shown in FIG. 4, the above S205 specifically includes:

S401: Determine, in the plurality of sets of the first feature information stored in the second database, the first feature information that is the same as the attribute group in the second feature information.

In the embodiment of the present application, the attribute group includes the option values respectively selected by the user in each of the drop-down boxes of the client except the data management operation drop-down box. Each option value selected by the user in each drop-down box except the data management operation drop-down box is an element in the attribute group of the second feature information.

In the feature information field of the mapping relationship data table, the intermediate database searches for the first feature information that is the same as the attribute group in the second feature information, that is, in the mapping relationship data table, finds the first element that includes each element of the attribute group. Feature information.

S402: Determine whether the second operation field is the same as the first operation field in the determined first feature information.

The first operation field in the first feature information that is found is read to determine a data management operation type corresponding to the first feature information. The first operation field is compared with the second operation field of the second feature information to determine whether the data management operation types corresponding to the two operation fields are the same.

If the second operation field is different from the first operation field in the determined first feature information, step S403 is performed. The S403 is specifically: returning the rejection response prompt information.

If the data management operation types corresponding to the two operation fields are different, it indicates that the data management operation matching the data management operation type of the associated data corresponding to the attribute group in the background database is not allowed. At this point, the intermediate database directly returns a rejection response prompt message to inform the user that it is an illegal operation, or informs the user that its operation is not within the scope of authorization.

If the second operation field is the same as the first operation field in the determined first feature information, step S404 is performed. The S404 is specifically configured to: determine association data that matches the data management operation request according to the mapping relationship between the first feature information and the associated data.

If the data management operations of the two operation fields are the same, the data management operation matching the data management operation type corresponding to the attribute group in the background database is allowed to be performed, and the second feature information and attributes are determined. The first feature information of the same group is the same. And reading, according to the record in which the first feature information is located, each data table name and a database name corresponding to the stored in the record. The intermediate database determines that the associated data corresponding to the first feature information is each record stored in each data table of the background database, wherein each database in which the record is located is a back-end database corresponding to the read database name, and each The data table in which a record is located is the data table corresponding to the read data table name in the background database.

In the embodiment of the present application, the user only needs to directly select the attribute group element data of the associated operation and the data management operation type in the drop-down box displayed by the client, that is, the data management operation carrying the second feature information may be sent to the intermediate database. The request does not need to input the SQL statement that can be recognized by the database, which improves the user's data acquisition efficiency. By comparing the operation field of the second feature information with the operation field of the first feature information, the intermediate database can directly determine whether to allow the operation of the associated data related to the second feature information, without separately going to each database in the background. Request confirmation is performed, thereby further improving the efficiency of data processing.

S206: Perform a data management operation on the determined associated data according to the data management operation request to respond to the data management operation request.

According to the data management operation type in the data management operation request uploaded by the client, the intermediate database serves as a request client of the background database, and respectively issues a request to each background database to request the determined data to be associated with the data management operation type. Matching data management operations. After the background database returns the response result to the intermediate database, the intermediate database generates the client response data to extract the valid message data in the response result returned by the background database, encapsulates it into the client response data, and returns the client to the intermediate database. The interaction between the client and the back-end database can be implemented in a form similar to an intermediate bridge.

In the embodiment of the present application, when receiving the data management operation request for the feature information, the intermediate database is used as a bridge to directly process the associated data corresponding to the feature information in the plurality of databases in the background, thereby implementing the data. Unified processing, the user does not need to perform multiple data management operations of the sub-library, thereby improving data management efficiency.

As an embodiment of the present application, as shown in FIG. 5, the above S206 includes:

S501: When the data management operation request is a data query request, download the determined related data.

When the operation field in the second feature information carried by the data management operation request is a query, determining that the data management operation request is a data query request.

After the intermediate database obtains the associated data that matches the data query operation request, the background database and the data table stored by the associated data are obtained. The intermediate database calls a preset query statement template, and fills a plurality of attribute values included in the second feature information and a database name and a data table name stored in each associated data into the query statement template, respectively, to generate a plurality of query statements. . At this time, the intermediate database transmits the respective query statements to the corresponding database in the background based on the database name in the query statement.

When each database in the background receives the query sent by the intermediate database, it processes and responds to the query. According to the plurality of attribute values and the data table name carried by the query statement, the database in the background reads a record corresponding to the plurality of attribute values from the data table corresponding to the data table name, and stores the record as The associated data in the background database is returned to the intermediate database.

S502: Return the associated data as a response result of the data query request.

After the intermediate database receives the associated data returned by each back-end database, the intermediate database summarizes the associated data to return all the associated data together as a response result of the data management operation request sent by the client.

In the embodiment of the present application, after receiving the associated data returned by the background database one by one, the client can uniformly display all the associated data corresponding to the attribute group required by the user according to the response result returned by the intermediate database. For the user, it is not necessary to perform the data query operation of the multiple sub-databases, and it is not necessary to separately query the associated data corresponding to the attribute group in each background database, thereby realizing the unified processing of the data and improving the query efficiency of the data.

As another embodiment of the present application, as shown in FIG. 6, the above S206 includes:

S601: When the data management operation request is a data modification request, obtain a modification parameter based on the attribute value in the data modification request.

When the operation field in the second feature information carried by the data management operation request is a modification, it is determined that the data management operation request is a data modification request.

It can be known from the above S204 that when the user needs to modify the attribute value selected by the user, the modified parameter value is input in the input box, and the modified parameter based on the attribute value in the second feature information is the parameter input by the user. value. The intermediate database reads the modified parameters based on the attribute value from the data modification request.

S602: The modified parameter is processed by using a preset conversion algorithm to respectively generate a parameter modification instruction corresponding to the associated data in the plurality of the first databases.

After the intermediate database obtains the associated data that matches the data modification operation request, the background database and the data table stored by the associated data are obtained. The intermediate database calls the preset modification statement template, and fills the plurality of attribute values included in the second feature information, the modification parameters corresponding to each attribute value, and the database name and the data table name stored in each associated data to the query respectively. After the statement template, multiple parameter modification instructions are generated.

S603: Send the parameter modification instruction to each of the plurality of first databases, so that the plurality of the first databases respectively modify the stored associated data.

The intermediate database transmits the parameter modification instructions to the corresponding database in the background based on the database name in the parameter modification instruction.

When each database in the background receives the parameter modification instruction sent by the intermediate database, the parameter modification instruction is processed and responded. According to the plurality of attribute values and the data table name carried by the parameter modification instruction, the database in the background reads a record corresponding to the plurality of attribute values from the data table corresponding to the data table name, and the record is in the record The attribute value is changed to the modified parameter in the parameter modification instruction, and at the same time, the modification completion prompt information is returned and returned to the intermediate database.

After the intermediate database receives the modification completion prompt information returned by each back-end database, the intermediate database returns a response result based on the modification completion prompt information to the client.

In the embodiment of the present application, the intermediate database can automatically generate parameter modification instructions related to the associated data distributed in multiple back-end databases, thereby automatically requesting to uniformly modify all the records including the attribute group in each database in the background. Ensure data consistency and integrity. For the user, there is no need to perform multiple data modification operations of the sub-database, and it is not necessary to sequentially modify multiple records of the same attribute value in each background database, thereby realizing unified processing of data and improving data modification efficiency. .

Corresponding to the data response method provided by the embodiment of the present application, FIG. 7 is a structural block diagram of the data response apparatus provided by the embodiment of the present application. For the convenience of explanation, only the parts related to the present embodiment are shown.

Referring to Figure 7, the data response device 71 includes:

The associated data obtaining unit 711 is configured to acquire associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed in common during a data operation.

The feature information obtaining unit 712 is configured to acquire first feature information of the associated data.

The mapping relationship establishing unit 713 is configured to establish a mapping relationship between the first feature information and the associated data, and store the first feature information and the mapping relationship to a pre-established second database.

The request obtaining unit 714 is configured to acquire a data management operation request that is sent by the client to the second database and that carries the second feature information.

The association data matching unit 715 is configured to determine, in the plurality of sets of the first feature information stored in the second database, the first feature information that is the same as the second feature information, and determine the location and the location according to the mapping relationship. The associated data of the data management operation request matching.

The request response unit 716 is configured to perform a data management operation on the determined associated data according to the data management operation request to respond to the data management operation request.

Optionally, the feature information acquiring unit 712 includes: an obtaining subunit, configured to respectively acquire attribute values of each data in the associated data.

Create subunits for creating attribute groups.

And a storage subunit, configured to store the attribute value in the attribute group if the attribute values of the at least two data are the same.

Adding a subunit, configured to add a first operation field to the attribute group, and output the attribute group including the first operation field as the first feature information.

The first operation field is used to indicate the type of the data management operation corresponding to the attribute group.

Optionally, the second feature information includes the attribute group and a second operation field, and the associated data matching unit 715 includes:

Determining a subunit, configured to determine, in the plurality of sets of the first feature information stored in the second database, the same first feature information as the attribute group in the second feature information.

a determining subunit, configured to determine whether the second operation field is the same as the first operation field in the determined first feature information.

And rejecting the subunit, if the second operation field is different from the first operation field in the determined first feature information, returning the rejection response prompt information.

a matching subunit, configured to determine the data according to the mapping relationship between the first feature information and the associated data, if the second operation field is the same as the first operation field in the determined first feature information Manage the associated data that the operation request matches.

Optionally, the request response unit 716 includes:

The downloading subunit is configured to download the determined related data when the data management operation request is a data query request.

Returning to the subunit, the method is used to return the associated data as a response result of the data query request.

Optionally, the request response unit 716 includes:

The obtaining subunit is configured to acquire, when the data management operation request is a data modification request, a modification parameter based on the attribute group in the data modification request.

And generating a subunit, configured to process the modified parameter by using a preset conversion algorithm to respectively generate a parameter modification instruction corresponding to the associated data in the plurality of the first databases.

The modifying subunit is configured to separately send the parameter modification instruction to the plurality of the first databases, so that the plurality of the first databases respectively modify the stored associated data.

FIG. 8 is a schematic diagram of a terminal device according to an embodiment of the present application. As shown in FIG. 8, the terminal device 8 of this embodiment includes a processor 80 and a memory 81 in which computer readable instructions 82, such as data response programs, executable on the processor 80 are stored. The processor 80 executes the computer readable instructions 82 to implement the steps in the various data response method embodiments described above, such as steps 201 through 206 shown in FIG. Alternatively, the processor 80, when executing the computer readable instructions 82, implements the functions of the various modules/units in the various apparatus embodiments described above, such as the functions of the units 711 through 716 shown in FIG.

Illustratively, the computer readable instructions 82 may be partitioned into one or more modules/units that are stored in the memory 81 and executed by the processor 80, To complete this application. The one or more modules/units may be a series of computer readable instruction segments capable of performing a particular function, the instruction segments being used to describe the execution of the computer readable instructions 82 in the terminal device 8.

The terminal device 8 may be a computing device such as a desktop computer, a notebook, a palmtop computer, or a cloud server. The terminal device may include, but is not limited to, the processor 80 and the memory 81. It will be understood by those skilled in the art that FIG. 8 is merely an example of the terminal device 8, and does not constitute a limitation on the terminal device 8, and may include more or less components than those illustrated, or combine some components, or different components. For example, the terminal device may further include an input/output device, a network access device, a bus, and the like.

The so-called processor 80 can be a central processing unit (Central Processing Unit, CPU), can also be other general-purpose processors, digital signal processors (DSP), application specific integrated circuits (Application Specific Integrated Circuit (ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor or any conventional processor or the like.

The memory 81 may be an internal storage unit of the terminal device 8, such as a hard disk or a memory of the terminal device 8. The memory 81 may also be an external storage device of the terminal device 8, such as a plug-in hard disk provided on the terminal device 8, a smart memory card (SMC), and a secure digital (SD). Card, flash card, etc. Further, the memory 81 may also include both an internal storage unit of the terminal device 8 and an external storage device. The memory 81 is configured to store the computer readable instructions and other programs and data required by the terminal device. The memory 81 can also be used to temporarily store data that has been output or is about to be output.

In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a standalone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application, in essence or the contribution to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium. A number of instructions are included to cause a computer device (which may be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present application. The foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and the like, which can store program codes. .

The above embodiments are only used to explain the technical solutions of the present application, and are not limited thereto; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that they can still The technical solutions described in the embodiments are modified, or the equivalents of the technical features are replaced by the equivalents. The modifications and substitutions of the embodiments do not depart from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

A data response method, comprising:

Obtaining associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed together during a data operation;

Obtaining first feature information of the associated data;

Establishing a mapping relationship between the first feature information and the associated data, and storing the first feature information and the mapping relationship to a pre-established second database;

Obtaining a data management operation request that is sent by the client to the second database and carries the second feature information;

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the second feature information, and determining an association that matches the data management operation request according to the mapping relationship data;

And performing data management operations on the determined associated data according to the data management operation request to respond to the data management operation request.
The data response method according to claim 1, wherein the acquiring the first feature information of the associated data comprises:

Obtaining attribute values of each data in the associated data respectively;

Create an attribute group;

If the attribute values of the at least two data are the same, the attribute value is stored in the attribute group;

Adding a first operation field to the attribute group, and outputting the attribute group including the first operation field as the first feature information;

The first operation field is used to indicate the type of the data management operation corresponding to the attribute group.
The data response method according to claim 2, wherein said second feature information comprises said attribute group and said second operation field, said plurality of said first feature information stored in said second database Determining the first feature information that is the same as the second feature information, and determining the associated data that matches the data management operation request according to the mapping relationship, including:

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the attribute group in the second feature information;

Determining whether the second operation field is the same as the first operation field in the determined first feature information;

If the second operation field is different from the first operation field in the determined first feature information, returning the rejection response prompt information;

And if the second operation field is the same as the first operation field in the determined first feature information, determining, according to the mapping relationship between the first feature information and the associated data, the association that matches the data management operation request data.
The data response method according to claim 1, wherein the data management operation is performed on the determined associated data according to the data management operation request, to respond to the data management operation request, including:

When the data management operation request is a data query request, downloading the determined associated data;

The associated data is returned as a response result of the data query request.
The data response method according to claim 1, wherein the data management operation is performed on the determined associated data according to the data management operation request, to respond to the data management operation request, including:

And acquiring, when the data management operation request is a data modification request, a modification parameter based on the attribute group in the data modification request;

Processing the modified parameter by using a preset conversion algorithm to respectively generate a parameter modification instruction corresponding to the associated data in the plurality of the first databases;

And sending the parameter modification instruction to the plurality of the first databases, respectively, so that the plurality of the first databases respectively modify the stored associated data.
A data response device, comprising:

An associated data obtaining unit, configured to acquire associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed jointly during a data operation;

a feature information acquiring unit, configured to acquire first feature information of the associated data;

a mapping relationship establishing unit, configured to establish a mapping relationship between the first feature information and the associated data, and store the first feature information and the mapping relationship to a pre-established second database;

a request obtaining unit, configured to acquire a data management operation request that is sent by the client to the second database and carries the second feature information;

An association data matching unit, configured to determine, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the second feature information, and determine, according to the mapping relationship, Data management operation request matching associated data;

And a request response unit, configured to perform a data management operation on the determined associated data according to the data management operation request, to respond to the data management operation request.
The data response device according to claim 6, wherein the feature information acquiring unit comprises:

Obtaining a subunit, configured to respectively acquire attribute values of each data in the associated data;

Create subunits for creating attribute groups;

a storage subunit, configured to store the attribute value in the attribute group if the attribute values of the at least two data are the same;

Adding a subunit, configured to add a first operation field to the attribute group, and output the attribute group including the first operation field as the first feature information;

The first operation field is used to indicate the type of the data management operation corresponding to the attribute group.
The data response apparatus according to claim 7, wherein the second feature information comprises the attribute group and a second operation field, and the associated data matching unit comprises:

a determining subunit, configured to determine, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the attribute group in the second feature information;

a determining subunit, configured to determine whether the second operation field is the same as the first operation field in the determined first feature information;

And rejecting the subunit, if the second operation field is different from the first operation field in the determined first feature information, returning the rejection response prompt information;

a matching subunit, configured to determine the data according to the mapping relationship between the first feature information and the associated data, if the second operation field is the same as the first operation field in the determined first feature information Manage the associated data that the operation request matches.
The data response apparatus according to claim 6, wherein the request response unit comprises:

a downloading subunit, configured to download the determined related data when the data management operation request is a data query request;

Returning to the subunit, the method is used to return the associated data as a response result of the data query request.
The data response apparatus according to claim 6, wherein the request response unit comprises:

Obtaining a subunit, configured to acquire a modification parameter based on the attribute group in the data modification request when the data management operation request is a data modification request;

Generating a subunit, configured to process the modified parameter by using a preset conversion algorithm to respectively generate a parameter modification instruction corresponding to the associated data in the plurality of the first databases;

The modifying subunit is configured to separately send the parameter modification instruction to the plurality of the first databases, so that the plurality of the first databases respectively modify the stored associated data.
A terminal device, comprising: a memory and a processor, wherein the memory stores computer readable instructions executable on the processor, and the processor implements the following steps when the computer readable instructions are executed :

Obtaining associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed together during a data operation;

Obtaining first feature information of the associated data;

Establishing a mapping relationship between the first feature information and the associated data, and storing the first feature information and the mapping relationship to a pre-established second database;

Obtaining a data management operation request that is sent by the client to the second database and carries the second feature information;

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the second feature information, and determining an association that matches the data management operation request according to the mapping relationship data;

And performing data management operations on the determined associated data according to the data management operation request to respond to the data management operation request.
The terminal device according to claim 11, wherein the acquiring the first feature information of the associated data comprises:

Obtaining attribute values of each data in the associated data respectively;

Create an attribute group;

If the attribute values of the at least two data are the same, the attribute value is stored in the attribute group;

Adding a first operation field to the attribute group, and outputting the attribute group including the first operation field as the first feature information;

The first operation field is used to indicate the type of the data management operation corresponding to the attribute group.
The terminal device according to claim 12, wherein the second feature information comprises the attribute group and a second operation field, wherein the plurality of sets of the first feature information stored in the second database are Determining the first feature information that is the same as the second feature information, and determining the associated data that matches the data management operation request according to the mapping relationship, including:

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the attribute group in the second feature information;

Determining whether the second operation field is the same as the first operation field in the determined first feature information;

If the second operation field is different from the first operation field in the determined first feature information, returning the rejection response prompt information;

And if the second operation field is the same as the first operation field in the determined first feature information, determining, according to the mapping relationship between the first feature information and the associated data, the association that matches the data management operation request data.
The terminal device according to claim 11, wherein the data management operation is performed on the determined associated data according to the data management operation request, to respond to the data management operation request, including:

When the data management operation request is a data query request, downloading the determined associated data;

The associated data is returned as a response result of the data query request.
The terminal device according to claim 11, wherein the data management operation is performed on the determined associated data according to the data management operation request, to respond to the data management operation request, including:

And acquiring, when the data management operation request is a data modification request, a modification parameter based on the attribute group in the data modification request;

Processing the modified parameter by using a preset conversion algorithm to respectively generate a parameter modification instruction corresponding to the associated data in the plurality of the first databases;

And sending the parameter modification instruction to the plurality of the first databases, respectively, so that the plurality of the first databases respectively modify the stored associated data.
A computer readable storage medium storing computer readable instructions, wherein the computer readable instructions, when executed by at least one processor, implement the following steps:

Obtaining associated data distributed in a plurality of first databases, where the associated data is data that needs to be processed together during a data operation;

Obtaining first feature information of the associated data;

Establishing a mapping relationship between the first feature information and the associated data, and storing the first feature information and the mapping relationship to a pre-established second database;

Obtaining a data management operation request that is sent by the client to the second database and carries the second feature information;

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the second feature information, and determining an association that matches the data management operation request according to the mapping relationship data;

And performing data management operations on the determined associated data according to the data management operation request to respond to the data management operation request.
The computer readable storage medium according to claim 16, wherein the acquiring the first feature information of the associated data comprises:

Obtaining attribute values of each data in the associated data respectively;

Create an attribute group;

If the attribute values of the at least two data are the same, the attribute value is stored in the attribute group;

Adding a first operation field to the attribute group, and outputting the attribute group including the first operation field as the first feature information;

The first operation field is used to indicate the type of the data management operation corresponding to the attribute group.
The computer readable storage medium of claim 17, wherein the second feature information comprises the attribute group and a second operation field, the plurality of sets of the first stored in the second database And determining, in the feature information, the first feature information that is the same as the second feature information, and determining the associated data that matches the data management operation request according to the mapping relationship, including:

Determining, in the plurality of sets of the first feature information stored in the second database, first feature information that is the same as the attribute group in the second feature information;

Determining whether the second operation field is the same as the first operation field in the determined first feature information;

If the second operation field is different from the first operation field in the determined first feature information, returning the rejection response prompt information;

And if the second operation field is the same as the first operation field in the determined first feature information, determining, according to the mapping relationship between the first feature information and the associated data, the association that matches the data management operation request data.
The computer readable storage medium according to claim 16, wherein said performing a data management operation on the determined associated data according to the data management operation request to respond to the data management operation request, including :

When the data management operation request is a data query request, downloading the determined associated data;

The associated data is returned as a response result of the data query request.
The computer readable storage medium according to claim 16, wherein said performing a data management operation on the determined associated data according to the data management operation request to respond to the data management operation request, including :

And acquiring, when the data management operation request is a data modification request, a modification parameter based on the attribute group in the data modification request;

Processing the modified parameter by using a preset conversion algorithm to respectively generate a parameter modification instruction corresponding to the associated data in the plurality of the first databases;

And sending the parameter modification instruction to the plurality of the first databases, respectively, so that the plurality of the first databases respectively modify the stored associated data.