Data processing method and device, terminal and computer storage medium

By introducing data change cache collection and batch processing mechanisms in the database, and integrating data change requests into batch statements, the problem of low efficiency in database data processing in the existing technology is solved and more efficient data processing is achieved.

CN120086230AInactive Publication Date: 2025-06-03WUHAN BAISIJIE TECH CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202510559197.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-04-30
Publication Date
2025-06-03
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

In the prior art, databases are less efficient when processing data change requests, resulting in the inability to meet modern data processing needs.

Method used

When a data change request is received, it is added to the preset data change cache set, and when a data query request for the target data is received, the data change request is integrated into a data batch statement, and the corresponding data change operation is performed.

Benefits of technology

By batch processing of data change requests, the database's data processing efficiency is greatly improved and modern data processing needs are met.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120086230A_ABST
    Figure CN120086230A_ABST
Patent Text Reader

Abstract

The invention relates to a data processing method and device, a terminal and a computer storage medium, and belongs to the technical field of data processing.The data processing method comprises the steps that when a data change request is received, the data change request is added into a preset data change cache set according to the data change type of the data change request; when a data query request of target data corresponding to the data change requests stored in the data change cache set is received, the data change requests in the data change cache set are integrated according to the data change type, and corresponding data batch processing statements are generated; and executing a corresponding data change operation in a database according to the data batch processing statement. By performing batch processing on the data change requests, the data processing efficiency of the database can be greatly improved, and modern requirements are met.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular, to a data processing method, apparatus, terminal, and computer storage medium. Background Art

[0002] With the continuous development of computer technology, the use of databases plays an important role in data management.

[0003] In the existing database management technology, for databases with a large amount of data and a high data access frequency, data is usually processed in order through a data queue or processed in parallel. However, data access in databases usually includes data operations with a very high similarity. In this case, a large number of repeated operations are performed on the database, resulting in a low data processing rate and being unable to meet the existing data processing requirements.

[0004] It can be seen that the existing technology has a low data processing efficiency for the data in the database. Summary of the Invention

[0005] In view of this, it is necessary to provide a data processing method, apparatus, terminal, and computer storage medium to solve the problem that the existing technology has a low data processing efficiency for the data in the database.

[0006] To solve the above problems, the present invention provides a data processing method, including: When receiving a data change request, adding the data change request to a preset data change cache set according to the data change type of the data change request; When receiving a data query request for the target data corresponding to the data change request stored in the data change cache set, integrating the data change requests in the data change cache set according to the data change type to generate corresponding data batch processing statements; Performing corresponding data change operations in the database according to the data batch processing statements.

[0007] In a possible implementation manner, adding the data change request to a preset data change cache set according to the data change type of the data change request includes: Establishing a data change cache set in a preset cache layer according to a preset data change type; Storing the data characteristics of the target modified data corresponding to the data change request into the data change cache set according to the data change type of the data change request.

[0008] In a possible implementation manner, storing the data characteristics of the target modified data corresponding to the data change request into the data change cache set according to the data change type of the data change request includes: When the data change request is a new data request, store the table name, primary key column name of the data to be newly created, and the key-value pairs of the column data into the new data cache set; When the data change request is a delete data request, store the table name and primary key value of the data to be deleted into the delete data cache set; When the data change request is a modify data request, store the table name, primary key value, column name, and key-value pairs of the column data of the data to be modified into the modify data cache set.

[0009] In a possible implementation, integrate the data change requests in the data change cache set according to the data change type to generate corresponding data batch processing statements, including: When the data change request is a new data request, generate a data batch new statement for batch creating new data according to the table name, primary key column name of the data to be newly created, and the key-value pairs of the column data; When the data change request is a delete data request, generate a data batch delete statement for batch deleting data according to the table name and primary key value of the data to be deleted.

[0010] In a possible implementation, integrate the data change requests in the data change cache set according to the data change type to generate corresponding data batch processing statements, including: When the data change request is a modify data request, if the data to be modified is the data to be deleted in the delete data cache set, do not execute the modify data request; When the data to be modified is not the data to be deleted in the delete data cache set, generate corresponding data modification statements according to the table name, primary key value, column name, and key-value pairs of each data to be modified.

[0011] In a possible implementation, after performing the corresponding data change operation in the database according to the data batch processing statement, including: Empty the data change cache set.

[0012] In a possible implementation, after performing the corresponding data change operation in the database according to the data batch processing statement, including: Generate a completed change data table according to the table name of the data to be newly created, the table name of the data to be deleted, and the table name of the data to be modified.

[0013] The present invention also provides a data processing device, including: A request cache module, configured to add the data change request to a preset data change cache set according to the data change type of the data change request when receiving the data change request; A request integration module, which is configured to integrate the data change requests in the data change cache set according to the data change types when receiving a data query request for the target data corresponding to the data change request stored in the data change cache set, and generate corresponding data batch processing statements; A request processing module, which is configured to execute corresponding data change operations in the database according to the data batch processing statements.

[0014] The present invention also provides a database information management terminal, including a memory and a processor, wherein, The memory is configured to store programs; The processor is coupled to the memory and is configured to execute the programs stored in the memory to implement the steps in the data processing method of any of the above embodiments.

[0015] The present invention also provides a computer-readable storage medium, which is configured to store computer-readable programs or instructions. When the programs or instructions are executed by a processor, the steps in the data processing method of any of the above embodiments can be implemented.

[0016] The beneficial effects of the present invention are as follows: In the data processing method provided by the present invention, when receiving a data change request, according to the data change type of the data change request, the data change request is added to a preset data change cache set; when receiving a data query request for the target data corresponding to the data change request stored in the data change cache set, the data change requests in the data change cache set are integrated according to the data change types to generate corresponding data batch processing statements; corresponding data change operations are executed in the database according to the data batch processing statements. By batch processing the data change requests, the data processing efficiency of the database can be greatly improved to meet modern requirements. Description of the Drawings

[0017] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the drawings required for the description of the embodiments. Obviously, the following drawings are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative efforts.

[0018] Figure 1 It is a schematic flowchart of a data processing method provided by an embodiment of the present invention; Figure 2 It is a schematic flowchart of an implementation method of S101 provided by an embodiment of the present invention; Figure 3 It is a schematic flowchart of a data change request caching method provided by an embodiment of the present invention; Figure 4A flowchart showing a method for integrating data change requests provided by an embodiment of the present invention; Figure 5 A flowchart showing a method for processing data modification requests provided by an embodiment of the present invention; Figure 6 A structural diagram of a data processing device provided by an embodiment of the present invention; Figure 7 A structural diagram of a database information management terminal provided by an embodiment of the present invention. Detailed implementation manners

[0019] The following will specifically describe the preferred embodiments of the present invention with reference to the accompanying drawings. The accompanying drawings form a part of the present invention and are used together with the embodiments of the present invention to explain the principles of the present invention, rather than to limit the scope of the present invention.

[0020] Referring to "embodiments" herein means that the specific features, structures, or characteristics described in connection with the embodiments can be included in at least one embodiment of the present invention. The phrase appears in various places in the specification and does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment mutually exclusive with other embodiments. Those skilled in the art will explicitly and implicitly understand that the embodiments described herein can be combined with other embodiments.

[0021] A specific embodiment of the present invention discloses a data processing method, including: S101, when receiving a data change request, add the data change request to a preset data change cache set according to the data change type of the data change request; S102, when receiving a data query request for the target data corresponding to the data change request stored in the data change cache set, integrate the data change requests in the data change cache set according to the data change type to generate corresponding data batch processing statements; S103, perform corresponding data change operations in the database according to the data batch processing statements.

[0022] In the embodiments of the present invention, the provided data processing method can be applied as a computer program to a computer device for processing operations such as data query, access, and change of a database. Specifically, the database can be an existing database or a newly created database, and the present invention does not limit the type and volume of the database.

[0023] In an embodiment of the present invention, a data change request refers to a request for changing data in a database. Generally, access to the database includes operations such as data change and data query. The data processing method provided by the present invention is mainly used for processing data change requests. Since data change requests require changing the data in the database, compared with data query requests, the data processing process is more cumbersome and less efficient. However, the data processing method provided by the present invention can batch process data change requests to improve data processing efficiency.

[0024] In an embodiment of the present invention, when a data change request is received, according to the specific data change type in the data change request, the data change request is cached in the corresponding data change cache set. The data change cache set is pre-established according to possible data change types and can store different data change requests respectively.

[0025] In an embodiment of the present invention, when a data query request for the target data corresponding to the data change request stored in the data change cache set is received, the data change requests of the same type in each data change cache set are integrated to generate a corresponding data batch processing statement. The data batch processing statement can batch process data in the database to improve the efficiency of data processing.

[0026] For the data processing method provided by the present invention, when a data change request is received, according to the data change type of the data change request, the data change request is added to a preset data change cache set; when a data query request for the target data corresponding to the data change request stored in the data change cache set is received, the data change requests in the data change cache set are integrated according to the data change type to generate a corresponding data batch processing statement; and corresponding data change operations are executed in the database according to the data batch processing statement. By batch processing data change requests, the data processing efficiency of the database can be greatly improved to meet modern requirements.

[0027] As a possible implementation manner of the present invention, in this implementation manner, as Figure 2 shown, adding the data change request to the preset data change cache set according to the data change type of the data change request includes: S201, establish a data change cache set in a preset cache layer according to the preset data change type; S202, store the data characteristics of the target modified data corresponding to the data change request in the data change cache set according to the data change type of the data change request.

[0028] In an embodiment of the present invention, a data cache layer is provided for storing a data change cache set. Specifically, according to possible data change types, corresponding data change cache sets are set. For example, if the data change types include new data, deleted data, and modified data, a new data cache set, a deleted data cache set, and a modified data cache set can be correspondingly set. When a data change request is received, according to the data change type of the data change request, the data characteristics of the target modified data corresponding to the data change request are stored in the corresponding data change cache set. Which data characteristics of the target modified data need to be stored will be described in detail later in the present invention.

[0029] By setting a data change cache set in the cache layer, the present invention can cache the data change request in the corresponding data change cache set according to different data change types of the data change request, and store the data characteristics of the target modified data corresponding to the data change request, which is convenient for subsequent batch data processing.

[0030] As a possible implementation manner of the present invention, in this implementation manner, as Figure 3 shown, storing the data characteristics of the target modified data corresponding to the data change request in the data change cache set according to the data change type of the data change request includes: S301, when the data change request is a new data request, storing the table name, the primary key column name, and the key-value pairs of the column data of the data to be newly created in the new data cache set; S302, when the data change request is a deleted data request, storing the table name and the primary key value of the data to be deleted in the deleted data cache set; S303, when the data change request is a modified data request, storing the table name, the primary key value, the column name, and the key-value pairs of the column data of the data to be modified in the modified data cache set.

[0031] In an embodiment of the present invention, when the data change request is a new data request, the table name, primary key column name, and key-value pairs of column data of the data to be newly created are stored in the new data cache set. For example, when creating student information for students and teacher information for teachers, the stored data features are [{“STUDENTINFO”, “101”, row1}, {“STUDENTINFO”, “102”, row2}, {“TEACHERINFO”, “001”, row3}, {“TEACHERINFO”, “002”, row4}], where “STUDENTINFO” and “TEACHERINFO” are list names, “101”, “102”, “001”, and “002” are the corresponding column names, and row1, row2, row13, and row4 are the corresponding column data. When the data change request is a data deletion request, the table name and primary key value of the data to be deleted are stored in the data deletion cache set. For example, when deleting student information, the stored data features are [{“STUDENTINFO”, “97”}, {“TEACHERINFO”, “98”}, {“TEACHERINFO”, “001”}, {“TEACHERINFO”, “002”}], where “STUDENTINFO” and “TEACHERINFO” are list names, and 97, 98, 001, and 002 are the primary key values of the corresponding data to be deleted. When the data change request is a data modification request, the table name, primary key value, column name, and key-value pairs of column data of the data to be modified are stored in the data modification cache set. For example, when modifying student information and teacher information, the corresponding feature data to be stored are: [{“STUDENTINFO”, “102”, row5}, {“STUDENTINFO”, “103”, row6}, {“TEACHERINFO”, “003”, row7}, {“TEACHERINFO”, “004”, row8}], where “STUDENTINFO” and “TEACHERINFO” are list names, 102103003004 are the corresponding column names, and row5, row6, row7, and row8 are the key-value pairs of the corresponding column data.

[0032] The present invention stores the data features of the data to be changed in the data change cache set, which facilitates subsequent processing of the data according to the data features.

[0033] As a possible implementation manner of the present invention, in this implementation manner, as Figure 4 shown, the data change requests in the data change cache set are integrated according to the data change type to generate corresponding data batch processing statements, including: S401, when the data modification request is a request for adding new data, a batch creation statement for creating new data in batches is generated according to the table name, primary key column name and key-value pairs of the column data to be created; S402: When the data modification request is a data deletion request, a batch deletion statement for batch deleting data is generated according to the table name and primary key value of the data to be deleted.

[0034] In an embodiment of the present invention, when the data change request is a request for adding new data, a batch creation statement for creating new data in batches may be generated according to the data characteristics of the data to be created. As shown in the above embodiment, for the set [{"STUDENTINFO","101",row1}, {"STUDENTINFO","102",row2}, {"TEACHERINFO","001",row3}, {"TEACHERINFO","002",row4}], two batch creation statements may be generated in batches: INSERT INTO STUDENTINFO(ID, NAME, GENDER) VALUE ("101", "Zhang San", "Male"), ("102", "Li Si", "Male") INSERT INTO TEACHERINFO(ID, NAME, GENDER) VALUE ("001", "Wang Wu", "Male"), ("002", "Zhao Liu", "Male") Of course, the embodiment of the present invention is only a simple implementation method that is easy to describe. In actual applications, new student information and new teacher information are generally large-scale data processing. Then, dozens or hundreds of data processing batches can be generated into two data batch creation statements, which greatly saves data processing events and improves data processing efficiency.

[0035] On the other hand, when the data modification request is a data deletion request, a batch deletion statement for batch deletion of data is generated according to the table name and primary key value of the data to be deleted. As shown in the above embodiment, two batch deletion statements are generated for the set [{"STUDENTINFO", "97"}, {"STUDENTINFO", "98"}, {"TEACHERINFO", "001"}, {"TEACHERINFO", "002"}]: DELETE FROM STUDENTINFO WHERE ID IN ("97","98") DELETE FROM TEACHERINFO WHERE ID IN ("001","002") Similarly, the above batch processing method for data deletion requests can also improve the efficiency of data deletion in the database.

[0036] As a possible implementation mode of the present invention, in this implementation mode, Figure 5 As shown, the data change requests in the data change cache collection are integrated according to the data change type to generate corresponding data batch processing statements, including: S501, when the data change request is a data modification request, if the data to be modified is data to be deleted in the deleted data cache set, the data modification request is not executed; S502, when the modified data is not the data to be deleted in the deleted data cache set, corresponding data modification statements are generated according to the table name, primary key value, column name, and key-value pair of the column data of each data to be modified.

[0037] In an embodiment of the present invention, when a data change request is a request to modify data, it is necessary to first determine whether the data to be modified corresponding to the data modification request is data to be deleted. If the data to be modified is data to be deleted, the data modification request may not be processed and the data to be modified may be directly deleted. When the data to be modified is not data to be deleted, corresponding data modification statements are generated according to the table name, primary key value, column name, and key-value pairs of the column data of each data to be modified. Different from the request to add data and the request to delete data in the aforementioned embodiment, for the data to be modified, a corresponding data modification statement needs to be generated for each data modification request. For example, four data modification statements will be generated for the set [{"STUDENTINFO", "102", row5}, {"STUDENTINFO", "103", row6}, {"TEACHERINFO", "003", row7}, {"TEACHERINFO", "004", row8}]: UPDATE STUDENTINFO SET NAME = "王五" WHERE ID='102' UPDATE STUDENTINFO SET GENDER= "女" WHERE ID='103' UPDATE TEACHERINFO SET NAME = "XXX" WHERE ID='003' UPDATE STUDENTINFO SET GENDER = "女" WHERE ID='004' The present invention judges whether the data to be modified corresponding to the data modification request is data to be deleted, directly deletes the data to be modified to be deleted, omits the data modification operation, and improves the data processing efficiency.

[0038] As a possible implementation manner of the present invention, in this implementation manner, after performing corresponding data change operations in the database according to the data batch processing statement, it includes: Empty the data change cache set.

[0039] In the embodiment of the present invention, after performing corresponding data change operations in the database based on the data batch processing statement in the foregoing embodiment, in order to process subsequent data change requests, it is necessary to empty the data change cache set. Specifically, it is necessary to empty the new data cache set, the deleted data cache set, and the modified data cache set.

[0040] Furthermore, after performing corresponding data change operations in the database according to the data batch processing statement, it includes: Generate a completed change data table according to the table names of the data to be newly created, the table names of the data to be deleted, and the table names of the data to be modified.

[0041] In the embodiment of the present invention, in order to make the data batch processing statement return the correct result and record the data change requests, a completed change data table can be generated according to the table names of the data to be newly added, the table names of the data to be deleted, and the table names of the data to be modified, so as to facilitate querying the data change situation based on the completed change data table.

[0042] The embodiment of the present invention empties the data change cache set and constructs a completed change data table after data batch processing, which is convenient for querying the data change situation.

[0043] In order to better implement the data processing method in the embodiment of the present invention, correspondingly, on the basis of the data processing method, as Figure 6 shown, the embodiment of the present invention further provides a data processing device. The data processing device 600 includes: A request cache module 601, configured to add a data change request to a preset data change cache set according to the data change type of the data change request when receiving the data change request; A request integration module 602, configured to integrate the data change requests in the data change cache set according to the data change type to generate a corresponding data batch processing statement when receiving a data query request for the target data corresponding to the data change requests stored in the data change cache set; A request processing module 603, configured to perform corresponding data change operations in the database according to the data batch processing statement.

[0044] The data processing device 600 provided in the above embodiments can implement the technical solutions described in the above embodiments of the data processing method. For the specific implementation principles of the above modules or units, reference can be made to the corresponding content in the above embodiments of the data processing method, which will not be elaborated here.

[0045] The data processing device provided by the present invention, when receiving a data change request, adds the data change request to a preset data change cache set according to the data change type of the data change request; when receiving a data query request for the target data corresponding to the data change request stored in the data change cache set, integrates the data change requests in the data change cache set according to the data change type, generates corresponding data batch processing statements; and performs corresponding data change operations in the database according to the data batch processing statements. By batch processing data change requests, the data processing efficiency of the database can be greatly improved to meet modern requirements.

[0046] As Figure 7 shown, the present invention also correspondingly provides a database information management terminal 700. The database information management terminal 700 includes a processor 701, a memory 702, and a display 703. Figure 7 Only some components of the database information management terminal 700 are shown, but it should be understood that it is not required to implement all the shown components, and more or fewer components can be alternatively implemented.

[0047] The processor 701 may be a central processing unit (CPU), a microprocessor, or other data processing chips in some embodiments, and is used to run the program code stored in the memory 702 or process data, such as the data processing method in the present invention.

[0048] In some embodiments, the processor 701 may be a single server or a server group. The server group may be centralized or distributed. In some embodiments, the processor 701 may be local or remote. In some embodiments, the processor 701 may be implemented on a cloud platform. In some embodiments, the cloud platform may include a private cloud, a public cloud, a hybrid cloud, a community cloud, a distributed cloud, an internal cloud, a multi-cloud, etc., or any combination of the above.

[0049] The memory 702 may be an internal storage unit of the database information management terminal 700 in some embodiments, such as the hard disk or memory of the database information management terminal 700. The memory 702 may also be an external storage device of the database information management terminal 700 in some other embodiments, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) card, a Flash Card, etc. equipped on the database information management terminal 700.

[0050] Furthermore, the memory 702 may also include both the internal storage unit of the database information management terminal 700 and the external storage device. The memory 702 is used to store the application software for installing the database information management terminal 700 and various types of data.

[0051] The display 703 may be an LED display, a liquid crystal display, a touch liquid crystal display, and an OLED (Organic Light-Emitting Diode) toucher, etc. in some embodiments. The display 703 is used to display the information of the database information management terminal 700 and to display a visual user interface. The components 701-703 of the database information management terminal 700 communicate with each other through a system bus.

[0052] In some embodiments, when the processor 701 executes the data processing program in the memory 702, the following steps may be implemented: When a data change request is received, add the data change request to a preset data change cache set according to the data change type of the data change request; When a data query request for the target data corresponding to the data change request stored in the data change cache set is received, integrate the data change requests in the data change cache set according to the data change type to generate a corresponding data batch processing statement; Execute the corresponding data change operation in the database according to the data batch processing statement.

[0053] It should be understood that when the processor 701 executes the data processing program in the memory 702, in addition to the above functions, other functions may also be implemented. For specific details, please refer to the description of the corresponding method embodiments above.

[0054] Furthermore, the type of the database information management terminal 700 mentioned in the embodiments of the present invention is not specifically limited. The database information management terminal 700 may be a mobile phone, a tablet computer, a personal digital assistant (PDA), a wearable device, a laptop computer, or other portable database information management terminals. Exemplary embodiments of the portable database information management terminal include, but are not limited to, portable database information management terminals running IOS, android, microsoft, or other operating systems. The above-mentioned portable database information management terminal may also be other portable database information management terminals, such as a laptop computer with a touch-sensitive surface (such as a touch panel). It should also be understood that in some other embodiments of the present invention, the database information management terminal 700 may not be a portable database information management terminal, but a desktop computer with a touch-sensitive surface (such as a touch panel).

[0055] Correspondingly, the embodiments of the present invention further provide a computer-readable storage medium, which is used to store computer-readable programs or instructions. When the programs or instructions are executed by a processor, the steps or functions in the data processing methods provided by the above-mentioned method embodiments can be implemented.

[0056] Those skilled in the art can understand that all or part of the processes of implementing the methods in the above embodiments can be completed by instructing relevant hardware through a computer program, and the program can be stored in a computer-readable storage medium. Among them, the computer-readable storage medium is a magnetic disk, an optical disk, a read-only memory, or a random access memory, etc.

[0057] The above is only the preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by those skilled in the art within the technical scope disclosed by the present invention should be covered by the protection scope of the present invention.

Claims

1. A data processing method, characterized in that: include: When receiving a data change request, adding the data change request to a preset data change cache set according to the data change type of the data change request; When receiving a data query request for target data corresponding to the data change request stored in the data change cache set, integrating the data change requests in the data change cache set according to the data change type to generate a corresponding data batch statement; Execute corresponding data modification operations in the database according to the data batch processing statements.

2. The data processing method according to claim 1, characterized in that: The step of adding the data change request to a preset data change cache set according to the data change type of the data change request includes: According to the preset data change type, a data change cache collection is established in the preset cache layer; According to the data change type of the data change request, data features of the target modified data corresponding to the data change request are stored in the data change cache set.

3. The data processing method according to claim 2, characterized in that: According to the data change type of the data change request, storing the data characteristics of the target modified data corresponding to the data change request in the data change cache set includes: When the data change request is a request for creating new data, the table name, primary key column name and key-value pairs of the column data to be created are stored in a newly added data cache set; When the data change request is a data deletion request, storing the table name and primary key value of the data to be deleted in the deleted data cache set; When the data change request is a data modification request, the table name, primary key value, column name, and key-value pairs of the column data of the data to be modified are stored in a modified data cache set.

4. The data processing method according to claim 3, characterized in that: The step of integrating the data change requests in the data change cache set according to the data change type to generate corresponding data batch processing statements includes: When the data modification request is a request for adding new data, a batch creation statement for creating new data in batches is generated according to the table name, primary key column name and key-value pairs of the column data of the data to be created; When the data modification request is a data deletion request, a batch deletion statement for deleting the data in batches is generated according to the table name and primary key value of the data to be deleted.

5. The data processing method according to claim 3, characterized in that: The step of integrating the data change requests in the data change cache set according to the data change type to generate corresponding data batch processing statements includes: When the data change request is a data modification request, if the data to be modified is the data to be deleted in the deleted data cache set, the data modification request is not executed; When the data to be modified is not the data to be deleted in the deleted data cache set, corresponding data modification statements are generated according to the table name, primary key value, column name, and key-value pair of column data of each data to be modified.

6. The data processing method according to claim 5, characterized in that: After executing the corresponding data modification operation in the database according to the data batch processing statement, the method includes: Clears the data change cache collection.

7. The data processing method according to claim 5, characterized in that: After executing the corresponding data modification operation in the database according to the data batch processing statement, the method includes: A changed data table is generated according to the table name of the data to be newly created, the table name of the data to be deleted, and the table name of the data to be modified.

8. A data processing device, characterized in that: include: A request cache module, configured to, upon receiving a data change request, add the data change request to a preset data change cache set according to a data change type of the data change request; a request integration module, configured to, upon receiving a data query request for target data corresponding to a data change request stored in the data change cache set, integrate the data change requests in the data change cache set according to the data change type and generate a corresponding data batch processing statement; The request processing module is used to execute corresponding data modification operations in the database according to the data batch processing statement.

9. A database information management terminal, characterized in that: comprising a memory and a processor, wherein: The memory is used to store programs; The processor is coupled to the memory and is used to execute the program stored in the memory to implement the steps in the data processing method described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: Used to store computer-readable programs or instructions, which, when executed by a processor, can implement the steps of the data processing method described in any one of claims 1 to 7.

Citation Information

Patent Citations

  • Data merging method and device

    CN110069491A

  • Data processing method and device, equipment, medium and program product

    CN117827906A

  • Efficient batch processing in a multi-tier application

    EP2495657A1

  • Enhanced transactional cache with bulk operation

    US20140317047A1