Disclosure of Invention
The invention provides a client system, an information processing method, a reading and writing method and a reading and writing device.
In order to achieve the above purpose, the embodiment of the invention adopts the following technical scheme:
in a first aspect, an information processing method based on a client system is provided, the client system includes an active node for maintaining an active table, a base node for maintaining a base table, and a tool node for maintaining a tool table, the method includes:
the active node acquires a target operation request for operating the client information from a service system;
the active node inquires whether the operation flow identifier is unique in each operation record of the active table according to the operation flow identifier carried by the target operation request; wherein, the operation record is used for indicating the historical operation executed by the business system on the client information;
when the active node determines that the operation flow identifier is unique, the tool node updates the corresponding index field in the tool table according to the target operation request and returns a message of successful update to the active node; the tool table is used for indexing the customer information recorded by the basic table;
and after receiving the message of successful update, the active node records the target operation request in the active table.
In a second aspect, an information processing method based on a client system is provided, the client system comprises an active node for maintaining an active table, a base node for maintaining a base table, and a tool node for maintaining a tool table, the method comprises:
the active node acquires a target query request for querying client information from a service system;
the active node inquires the operation record of the active table whether the client in the target inquiry request is involved;
when the operation record of the client is inquired in the activity table, sending the inquired operation record of the client to the base node;
the basic node indexes according to the query field related to the target query request through a tool table in the tool node so as to query the corresponding customer information record in the basic table;
the basic node performs data combination according to the operation records of the inquired clients and the inquired client information records;
and the basic node sends a client information record obtained by data combination to the service system.
In a third aspect, a method for writing customer information is provided, the method comprising:
receiving a target operation request which is sent by a service system and used for operating client information;
inquiring whether the operation flow identification is unique in each operation record of an activity table according to the operation flow identification carried by the target operation request; wherein, the operation record is used for indicating the historical operation executed by the business system on the client information;
when the operation flow identifier is unique, updating a corresponding index field in the tool table according to the target operation request; the tool table is used for indexing the customer information recorded by the basic table;
and recording the target operation request in the activity table.
In a fourth aspect, a client information reading method is provided, the method including:
acquiring a target query request for querying client information from a service system;
querying whether the operation record of the activity table relates to the client in the target query request;
when the operation records of the clients are inquired in the active table, the inquiry fields related to the target inquiry requests are indexed through a tool table, so that the corresponding client information records are inquired in the basic table;
performing data combination according to the operation records of the inquired clients and the inquired client information records;
and sending the client information record obtained by data combination to the service system.
In a fifth aspect, a client system is provided, the client system comprising an active node, a base node, and a tool node;
the active node is used for inquiring whether the operation flow identification is unique in each operation record of the active table according to the operation flow identification carried by the target operation request after the target operation request for operating the client information is obtained from the service system; wherein, the operation record is used for indicating the historical operation executed by the business system on the client information;
the tool node is used for updating the corresponding index field in the tool table according to the target operation request when the active node determines that the operation flow identifier is unique, and returning a message of successful update to the active node; the tool table is used for indexing the customer information recorded by the basic table;
the activity table is further configured to record the target operation request in the activity table after receiving the message that the update is successful;
and the basic node is used for recording the client information in the basic table according to the activity table.
In a sixth aspect, a client system is provided, the client system comprising an active node, a base node, and a tool node;
the active node is used for acquiring a target query request for querying the client information from the service system; inquiring whether the operation records of the activity table relate to the client in the target inquiry request; when the operation record of the client is inquired in the activity table, sending the inquired operation record of the client to the base node;
the tool node is used for indexing a basic table by using a tool table according to the query field related to the target query request;
the basic node is used for indexing the corresponding customer information record in the basic table according to the tool table; performing data combination according to the inquired operation record of the client and the inquired client information record; and sending the client information record obtained by data combination to the service system.
In a seventh aspect, there is provided a customer information writing apparatus, the apparatus comprising:
the receiving module is used for receiving a target operation request which is sent by a service system and used for operating the client information;
the query module is used for querying whether the operation flow identifier is unique in each operation record of the activity table according to the operation flow identifier carried by the target operation request; wherein, the operation record is used for indicating the historical operation executed by the business system on the client information;
the updating module is used for updating the corresponding index field in the tool table according to the target operation request when the operation pipeline identifier is unique; the tool table is used for indexing the customer information recorded by the basic table;
and the recording module is used for recording the target operation request in the activity table.
In an eighth aspect, there is provided a customer information reading apparatus, the apparatus comprising:
the acquisition module is used for acquiring a target query request for querying the client information from the service system;
the query module is used for querying whether the operation records of the activity table relate to the client in the target query request;
the index module is used for indexing the query field related to the target query request through a tool table when the operation record of the client is queried in the activity table, so as to query the corresponding client information record in the basic table;
the updating module is used for carrying out data combination according to the operation record of the inquired client and the information record of the inquired client;
and the sending module is used for sending the client information record obtained by data combination to the service system.
After receiving a target operation request sent by a service system and used for operating client information, according to an operation flow identifier carried by the target operation request, querying whether the operation flow identifier is unique in each operation record of an activity table, and when the operation flow identifier is unique, updating a corresponding index field for indexing a basic table according to the target operation request in a tool table and recording the target operation request in the activity table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, the performance and the capacity of the system are improved.
Detailed Description
The embodiments of the present invention will be described in detail with reference to the accompanying drawings.
Example one
To clearly illustrate the method provided by the present embodiment, first, a data table related to the present embodiment is briefly introduced, and fig. 2 is a schematic diagram of the data table, as shown in fig. 2, the data table related to the present embodiment includes:
and the activity table is used for recording the target operation request.
And the basic table is used for recording the client information.
And the tool table is used for indexing the client information table.
The following will describe the client information writing method in detail, and fig. 3 is a schematic flow chart of a client information writing method according to an embodiment of the present invention, and as shown in fig. 3, the method includes:
step 101, receiving a target operation request for operating client information sent by a service system.
Specifically, when the business system needs to perform an operation of adding, modifying or deleting the client information, the business system sends an operation request, specifically, the operation request includes an operation flow identifier, and the operation flow identifier is a unique identifier of the operation, that is, each operation has a different operation flow identifier. In addition, the operation request also includes the type of the specific operation, and the operation object, i.e. the field for which the operation is directed. When the specific operation type is addition or modification, the operation request may further include operation content, that is, a field value to be added or modified for the field.
Generally, the amount of client information is huge, in order to perform quick indexing, a client Identifier (ID) of the client information needing to be operated can be carried in an operation request, and the client identifier has uniqueness, so that the query of a client information record can be facilitated.
And 102, inquiring whether the operation flow identifier is unique in each operation record of the activity table according to the operation flow identifier carried by the target operation request.
Wherein the operation record is used for indicating the historical operation executed by the business system on the client information. Specifically, an idempotent function is used to compare the operation flow identifier carried by the target operation request with the operation flow identifier field of each operation record in the activity table, so as to query whether the operation flow identifier is repeated with the operation flow identifier of each operation record in the activity table, thereby avoiding repeated processing of the same target operation request.
Each operation record is recorded in the activity table, and the operation record is used for recording information carried in the operation request, a service system for sending the operation request, sending time and the like.
And 103, when the operation flow identifier is unique, updating the corresponding index field in the tool table according to the target operation request.
The tool table is used for indexing the client information recorded by the basic table. Specifically, the tool table may be a general index table, or may be a unique index table containing some constraints, and is mainly used to accelerate the query speed of the client information table and ensure that the data meets the constraints. For example: handset number or registered mailbox uniqueness. The tool table indexes the index field, and the index field contained in the specific tool table is determined according to the business rule.
Specifically, when the operation flow identifier is unique, it may be determined that no repeated operation occurs, and then the corresponding index field in the tool table is updated according to the target operation request.
If the tool table is a common index table, before updating the corresponding index field in the tool table, checking whether the operation meets the constraint condition, if so, updating the corresponding index field in the tool table, otherwise, returning a message of operation failure to the service system.
If the tool table is the unique index table, whether the operation meets the uniqueness constraint condition or not can be checked in the process of updating the corresponding index field in the tool table, if so, the tool table is updated successfully, otherwise, the tool table is updated unsuccessfully, and a message of operation failure is returned to the service system.
Further, if the operation flow identifier is not unique, it indicates that the activity table already has an operation record corresponding to the target operation request, and processes the request, so that the process may have repeated operations, and ends the process.
And 104, recording the target operation request in the activity table.
Specifically, the relevant information of the target operation request received this time is recorded in the activity table, and a corresponding operation record is generated for subsequent query.
For example: the activity table may include the operation pipeline identifier, the operation type, the operation object, and the operation content carried in the operation request, and the service system and the sending time for sending the operation request.
Therefore, the information recorded by the activity table comprises the operation flow identifier, so that each operation can be conveniently controlled not to be repeatedly processed, namely idempotent, and the traceability of the operation is ensured.
In this embodiment, after receiving a target operation request for operating client information sent by a service system, according to an operation flow identifier carried by the target operation request, whether the operation flow identifier is unique is queried in each operation record of an active table, and when the operation flow identifier is unique, in a tool table, according to the target operation request, a corresponding index field for indexing a base table is updated, and the target operation request is recorded in the active table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, the performance and the capacity of the system are improved.
Example two
To clearly illustrate the previous embodiment, this embodiment further provides another client information writing method, and on the basis of the previous embodiment, further after step 104, the active table and the client information table may be merged, specifically, fig. 4 is a flowchart of another client information writing method provided in the second embodiment of the present invention, and as shown in fig. 4, the method includes:
step 201, when a preset trigger condition is met, acquiring an operation record to be merged in an activity table.
Specifically, the preset trigger conditions include: satisfying a preset time interval; and/or the condition that the number of the operation records to be merged in the activity table is greater than a preset threshold value is met.
In the method provided in fig. 3, it can be seen that when the service system requests to perform an operation on the client information, the corresponding operation is not performed on the basic table for recording the client information, but the operation is recorded in the activity table. The operation records in the activity table need to be merged when the number of the operation records accumulated in the activity table is enough to be larger than a preset threshold value or at preset time intervals. The operation record to be merged here may be all the operation records in the activity table, or may be a part of the operation records, which is not limited in this embodiment.
Step 202, performing data merging according to the operation record to be merged and the client information record of the current version in the basic table to obtain the client information record of the next version.
Specifically, after the operation records to be merged of each client are respectively obtained from the activity table by taking the client as a unit, for each client, the value of each field in the operation records to be merged of the client is utilized to update the value of the corresponding field of the client in the client information record of the current version in the base table, so as to complete merging of the operation records, and the obtained client information record of the next version is stored in the base table.
Step 203, move the operation record to be merged from the activity table to the history database.
Specifically, after the merging is completed for the operation record to be merged, the operation record to be merged is moved from the activity table to the history database. So that when the client data is in disorder, subsequent source tracing query can be carried out.
In this embodiment, after receiving a target operation request for operating client information sent by a service system, according to an operation flow identifier carried by the target operation request, whether the operation flow identifier is unique is queried in each operation record of an active table, and when the operation flow identifier is unique, in a tool table, according to the target operation request, a corresponding index field for indexing a base table is updated, and the target operation request is recorded in the active table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, compared with a locking mechanism, the performance and the capacity of the system are improved.
EXAMPLE III
Fig. 5 is a schematic flow chart of a client information reading method according to a third embodiment of the present invention, where the client information reading method according to this embodiment corresponds to the client information writing method according to the foregoing embodiment, and as shown in fig. 5, the method includes:
step 301, a target query request for querying client information is obtained from a business system.
Step 302, querying whether the operation record of the activity table relates to the client in the target query request.
Specifically, as a possible implementation form, when the index field of the target query request is the client identifier, the query may be directly performed in the operation record of the active table according to the client identifier, and if the operation record of the client identifier exists, it is determined that the client information of the client recorded in the base table is not the current latest client information, and the update is required according to the queried operation record.
Further, as another possible implementation form, when the index field of the target query request is not the client identifier, the client identifier corresponding to the index field of the target query request may be queried in the tool table. And further querying the operation record of the active table according to the client identifier, and if the operation record of the client identifier exists, determining that the client information of the client recorded in the basic table is not the current latest client information and updating according to the queried operation record.
Step 303, when the operation record of the client is queried in the active table, the query field related to the target query request is indexed through the tool table, so as to query the corresponding client information record in the basic table.
Specifically, the query field related to the target query request is indexed through a tool table, so that the value of the query field in the client information record of the current version is queried in a basic table.
And step 304, merging data according to the operation records of the inquired clients and the inquired client information records.
Specifically, when the operation record with the client identifier is queried in the active table according to the client identifier in the target query request, the field value corresponding to the client identifier in the client information record of the current version is updated in the basic table by using the field value in the queried operation record.
Step 305, sending the client information record obtained by data combination to the service system.
Further, when the operation record of the client is not inquired in the active table, inquiring the client information record of the current version in the basic table, and further sending the inquired client information record to the service system.
It should be noted that, since the present embodiment is a client information reading method corresponding to the first embodiment, please refer to the related description in the first embodiment for the content that is not described in detail in the present embodiment.
In the process of writing the client information, after receiving a target operation request which is sent by a service system and used for operating the client information, according to an operation flow identifier carried by the target operation request, whether the operation flow identifier is unique in each operation record of an activity table is inquired, and when the operation flow identifier is unique, in a tool table, according to the target operation request, a corresponding index field used for indexing a basic table is updated, and the target operation request is recorded in the activity table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, compared with a locking mechanism, the performance and the capacity of the system are improved.
Correspondingly, in the reading process, a target query request for querying client information is acquired from a service system, whether a client in the target query request is involved in an operation record of an active table is further queried, when the operation record of the client is queried in the active table, a query field involved in the target query request is indexed through a tool table, so that the corresponding client information record is queried in the basic table, data merging is performed according to the queried operation record of the client and the queried client information record, and the client information record obtained by data merging is sent to the service system.
Example four
In order to clearly illustrate the client information writing method provided by the foregoing embodiment, the present embodiment provides an information processing procedure for implementing the client information writing method in an application scenario of a client system. Fig. 6 is one of schematic interaction diagrams of nodes in a client system according to a fourth embodiment of the present invention, where as shown in fig. 6, the client system includes an active node, a base node, and a tool node.
The active node interacts with the service system, the active node is used for maintaining an active table, the basic node is used for maintaining a basic table, and the tool node is used for maintaining a tool table.
As shown in fig. 6, the information processing method includes:
in step 401, the active node obtains a target operation request for operating the client information from the service system.
Step 402, the active node queries whether the operation flow identifier is unique in each operation record of the active table according to the operation flow identifier carried by the target operation request.
Wherein the operation record is used for indicating the historical operation executed by the business system on the client information.
Specifically, the active node obtains an operation flow identifier carried by the target operation request, and compares the operation flow identifier with an operation flow identifier field of each operation record in the active table by using an idempotent function, so as to query whether the operation flow identifier is repeated with the operation flow identifier of each operation record in the active table.
Step 403, when the active node determines that the operation flow identifier is unique, the tool node updates the corresponding index field in the tool table according to the target operation request, and returns a message of successful update to the active node.
And the tool table is used for indexing the client information recorded by the basic table.
Step 404, after receiving the message of successful update, the active node records the target operation request in the active table and returns the operation result to the service system.
It can be seen that when the service system requests to operate on the client information, the corresponding operation is not performed on the basic table for recording the client information, but the operation is recorded in the activity table. The operation records in the activity table need to be merged when the number of the operation records accumulated in the activity table is enough to be larger than a preset threshold value or at preset time intervals. The operation record to be merged here may be all the operation records in the activity table, or may be a part of the operation records, which is not limited in this embodiment.
Specifically, fig. 7 is a second schematic view of interaction between nodes in the client system according to the fourth embodiment of the present invention, as shown in fig. 7:
step 501, when a preset trigger condition is met, the basic node obtains an operation record to be merged in the activity table from the activity node.
Specifically, the base node obtains the operation record to be merged of each client from the activity table in units of clients.
And 502, the base node performs data merging according to the operation record to be merged and the client information record of the current version in the base table to obtain the client information record of the next version, and then returns a message of successful merging to the active node.
Specifically, for each client, the base node updates the corresponding field value in the client information record of the client of the current version in the base table by using each field value in the operation record to be merged of the client.
As a possible implementation manner, there are a plurality of fields in the base table, fig. 8 is a schematic diagram of the base table, and as shown in fig. 8, the data content of the base table is numerous, and therefore, the base table needs to be indexed depending on the tool table.
In step 503, the active node moves the operation record to be merged from the active table to the history database according to the message that the merging is successful.
Further, the client system may also include a metadata node.
Based on the method, the tool node acquires the index fields involved in the configured business rules from the metadata node and adds the index fields involved in the business rules to the tool table.
The service rules record the query dimensions followed by the service system when querying the client information, specifically, the query dimensions include each index field and the query fields to be queried, so that the tool node can add the index fields related in the service rules to the tool table, so as to query the basic table quickly and improve the query efficiency.
EXAMPLE five
In order to clearly illustrate the client information reading method provided by the foregoing embodiment, the present embodiment provides an information processing procedure for implementing the client information reading method in an application scenario of a client system. Fig. 9 is an interaction diagram of nodes in a client system according to a fifth embodiment of the present invention, and as shown in fig. 9, the client system includes an active node, a base node, and a tool node.
The active node interacts with the service system, the active node is used for maintaining an active table, the basic node is used for maintaining a basic table, and the tool node is used for maintaining a tool table.
As shown in fig. 9, the information processing method includes:
step 601, the active node obtains a target query request for querying the client information from the service system.
Step 602, the active node queries whether the operation record of the active table relates to the client in the target query request, and when the operation record of the client is queried in the active table, the active node sends the queried operation record of the client to the base node.
Further, when the index field of the target query request is not the client identifier, the active node queries the client identifier corresponding to the index field of the target query request in the tool table through the tool node before querying the active table.
Step 603, the basic node indexes according to the query field related to the target query request through the tool table in the tool node, so as to query the corresponding customer information record in the basic table.
Specifically, the base node indexes the query field related to the target query request through a tool table in the tool node, so as to query the value of the query field in the client information record of the current version in the base table.
And step 604, the basic node performs data combination according to the operation record of the inquired client and the inquired client information record, and sends the client information record obtained by data combination to the service system.
Specifically, the active node sends the queried operation record to the base node when querying the operation record with the client identifier in the active table according to the client identifier corresponding to the target query request, so that in the base table, the base node updates the field value corresponding to the client identifier in the client information record of the current version by using the field value in the queried operation record.
Further, when the operation record of the client is not inquired in the active table, the base node inquires the client information record of the current version in the base table; and the basic node sends the inquired customer information record to the service system.
EXAMPLE six
The present embodiment provides a client system, and fig. 10 is a schematic diagram of a client system, as shown in fig. 10, the client system includes an active node, a base node, and a tool node.
The number of the active nodes can be one or more, and each active node interacts with the corresponding service system. The corresponding relationship here may be that the active node corresponds to the service system one to one, or that multiple active nodes correspond to one service system, or that one active node corresponds to multiple service systems.
In order to clearly illustrate the client system, the embodiment provides two possible implementation manners of the corresponding client system in two possible application scenarios.
As a possible implementation manner, in an application scenario in which a service system operates client information, after an active node is configured to obtain a target operation request for operating the client information from the service system, according to an operation flow identifier carried by the target operation request, it is queried whether the operation flow identifier is unique in each operation record of an active table.
Wherein the operation record is used for indicating the historical operation executed by the business system on the client information.
And the tool node is used for updating the corresponding index field in the tool table according to the target operation request and returning a message of successful update to the active node when the active node determines that the operation flow identifier is unique.
And the tool table is used for indexing the client information recorded by the basic table.
And the activity table is further used for recording the target operation request in the activity table after receiving the message of successful update.
And the base node is used for recording the client information in the base table according to the activity table.
Further, the base node is specifically configured to obtain, from the active node, an operation record to be merged in the active table when a preset trigger condition is met; performing data merging according to the operation record to be merged and the client information record of the current version in the basic table to obtain the client information record of the next version; and returning a message of successful combination to the active node.
And the active node is further configured to move the operation record to be merged from the active table to a history database according to the message that the merging is successful.
Further, fig. 11 is a second schematic diagram of the client system, and as shown in fig. 11, the client system further includes: and a metadata node.
And the metadata node is used for configuring the business rule.
Based on the above, the tool node is further configured to obtain, from the metadata node, an index field involved in the configured business rule; and adding the index field involved in the business rule into the tool table.
As another possible implementation manner, in an application scenario where the business system queries the client information, the active node is configured to obtain a target query request for querying the client information from the business system; inquiring whether the operation records of the activity table relate to the client in the target inquiry request; and when the operation record of the client is inquired in the activity table, sending the inquired operation record of the client to the base node.
And the tool node is used for indexing a basic table by using a tool table according to the query field related to the target query request.
The basic node is used for indexing the corresponding customer information record in the basic table according to the tool table; performing data combination according to the inquired operation record of the client and the inquired client information record; and sending the client information record obtained by data combination to the service system.
It can be seen that, after receiving a target operation request sent by a service system for operating client information, according to an operation flow identifier carried by the target operation request, querying whether the operation flow identifier is unique in each operation record of an activity table, and when the operation flow identifier is unique, updating a corresponding index field for indexing a base table according to the target operation request in a tool table, and recording the target operation request in the activity table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, the performance and the capacity of the system are improved.
EXAMPLE seven
Fig. 12 is a schematic structural diagram of a client information writing apparatus according to a seventh embodiment of the present invention, as shown in fig. 12, including: a receiving module 71, a query module 72, an update module 73 and a recording module 74.
The receiving module 71 is configured to receive a target operation request sent by the service system for operating the client information.
And the query module 72 is configured to query whether the operation flow identifier is unique in each operation record of the activity table according to the operation flow identifier carried by the target operation request.
Wherein the operation record is used for indicating the historical operation performed by the business system on the client information.
An updating module 73, configured to update the corresponding index field in the tool table according to the target operation request when the operation pipeline identifier is unique.
The tool table is used for indexing the customer information recorded by the basic table.
A recording module 74, configured to record the target operation request in the activity table.
In this embodiment, after receiving a target operation request for operating client information sent by a service system, according to an operation flow identifier carried by the target operation request, whether the operation flow identifier is unique is queried in each operation record of an active table, and when the operation flow identifier is unique, in a tool table, according to the target operation request, a corresponding index field for indexing a base table is updated, and the target operation request is recorded in the active table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, the performance and the capacity of the system are improved.
Example eight
Fig. 13 is a schematic structural diagram of a client information reading apparatus according to an eighth embodiment of the present invention, and as shown in fig. 13, the apparatus includes: an acquisition module 81, a query module 82, an indexing module 83, an update module 84, and a sending module 85.
The obtaining module 81 is configured to obtain a target query request for querying client information from a service system.
And the query module 82 is used for querying whether the operation record of the activity table relates to the client in the target query request.
And the indexing module 83 is configured to index, when the operation record of the client is queried in the active table, the query field related to the target query request through a tool table, so as to query the corresponding client information record in the base table.
And the updating module 84 is used for carrying out data combination according to the operation record of the inquired client and the information record of the inquired client.
And a sending module 85, configured to send the client information record obtained by data merging to the service system.
In the process of writing the client information, after receiving a target operation request which is sent by a service system and used for operating the client information, according to an operation flow identifier carried by the target operation request, whether the operation flow identifier is unique in each operation record of an activity table is inquired, and when the operation flow identifier is unique, in a tool table, according to the target operation request, a corresponding index field used for indexing a basic table is updated, and the target operation request is recorded in the activity table. Because the activity table is adopted to record all operations of the service system aiming at the client information, and each operation has a unique operation flow identifier, repeated operation and client data confusion are avoided, the problem of data consistency under the condition of multiple concurrencies is solved, and meanwhile, the performance and the capacity of the system are improved.
Correspondingly, in the reading process, a target query request for querying client information is acquired from a service system, whether a client in the target query request is involved in an operation record of an active table is further queried, when the operation record of the client is queried in the active table, a query field involved in the target query request is indexed through a tool table, so that the corresponding client information record is queried in the basic table, data merging is performed according to the queried operation record of the client and the queried client information record, and the client information record obtained by data merging is sent to the service system.
Those of ordinary skill in the art will understand that: all or a portion of the steps of implementing the above-described method embodiments may be performed by hardware associated with program instructions. The program may be stored in a computer-readable storage medium. When executed, the program performs steps comprising the method embodiments described above; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.