Implicit full-page data snapshot method, device and equipment and storage medium

Abstract

The invention provides an implicit full-page data snapshot method, device and equipment and a storage medium, and relates to the technical field of data snapshots.According to the method, change log records in a main database are triggered when label page data of a target page changes, and the data change condition is sent to a snapshot database in real time, so that the data change condition of the target page is changed; and the real-time synchronism and consistency of the data are ensured, so that the snapshot database can instantly reflect the latest state of the main database. Secondly, the snapshot database stores the data according to the data change time, great convenience is provided for data backtracking and analysis, and enterprises can better track the historical state and the change trend of the data. In addition, the mechanism also enhances the reliability and security of the data, even if the main database fails, the data can be quickly recovered through the snapshot database, and the service continuity is ensured. In a word, the method not only improves the data processing efficiency, but also provides powerful support for data management and application of enterprises.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data snapshot, in particular to an implicit full-page data snapshot method, device, equipment and storage medium. BACKGROUND

[0002] The implicit full-page refers to a plurality of tabs on a page, a tab currently clicked and opened by a user for viewing is referred to as a "display" state, and a tab not clicked is referred to as being in an "implicit" state, i.e., the content of the tab is currently invisible, and the full-page refers to the entire page range.

[0003] For such a display interface with an implicit full-page, data changes of a page in a display state are easy to be recorded by a user, but when data changes of a page in a display state and a page in an implicit state occur at the same time, data changes of the page in the implicit state are difficult to record. In addition, when data of multiple pages at a certain time needs to be queried, it is difficult to obtain the data required by the user based on the changed pages. SUMMARY

[0004] In view of the above problems, the present application provides an implicit full-page data snapshot method, which includes the following contents:

[0005] In a first aspect, the present application provides an implicit full-page data snapshot method, which includes the following steps:

[0006] When a tab in a target page changes data, triggering a change log in a master database to record data changes;

[0007] Sending the data changes to a snapshot database, and storing the data in the snapshot database according to data change time.

[0008] Optionally, the target page has a plurality of tabs, and the data changes of the tabs in the target page include:

[0009] Data addition, data change or data deletion of one or more tabs in the target page.

[0010] Optionally, each tab of the plurality of tabs has a corresponding data storage unit in the master database, and the snapshot database has a data storage unit corresponding to the master database.

[0011] Optionally, when any tab in the target page adds data, the sending of the data changes to the snapshot database and the storing of the data in the snapshot database according to data change time include:

[0012] send all the newly added data in the target page to the snapshot database through the change log;

[0013] store the newly added data in the snapshot database in a storage unit corresponding to the master database and record the data addition time.

[0014] Optionally, when any tab page in the target page is changed or data is deleted, the method further comprises:

[0015] send the changed data in the target page to the snapshot database through the change log;

[0016] store the changed data in the snapshot database in a storage unit corresponding to the master database and record the data change time or the data deletion time.

[0017] Optionally, the method further comprises:

[0018] query all data change records corresponding to the target data from the data storage unit of the data snapshot database according to the ID of the target data;

[0019] find the data record corresponding to the query change time and the data change record before the query change time from the all change records;

[0020] obtain the target data based on the data record corresponding to the query change time and the data change record before the query change time.

[0021] Optionally, the obtaining the target data based on the data record corresponding to the query change time and the data change record before the query change time comprises:

[0022] sort the data record corresponding to the query change time and the data change record before the query change time in the order from early to late to obtain a plurality of data records;

[0023] obtain the first data in the plurality of data records as temporary data;

[0024] replace the corresponding value in the first data with the value recorded in the second data in the plurality of data records to obtain first temporary data;

[0025] when the third data does not exist in the plurality of data records, take the first temporary data as the target data;

[0026] when a third data record exists in the plurality of data records, replacing a value recorded in the third data with a value corresponding to the first temporary data to obtain second temporary data;

[0027] when a fourth data record does not exist in the plurality of data records, taking the second temporary data as the target data.

[0028] In a second aspect, the present application provides an implicit full-page data snapshot device, which comprises:

[0029] a first data processing unit configured to trigger a change of change log record data in a master database when a tab in a target page has data change;

[0030] a second data processing unit configured to send the change of data to a snapshot database, and store data in the snapshot database according to a data change time.

[0031] Optionally, the target page has a plurality of tabs, and the first data processing unit is specifically configured to trigger the change of change log record data in the master database when one or more tabs in the target page have data addition, data change or data deletion.

[0032] Optionally, each of the plurality of tabs has a corresponding data storage unit in the master database, and the snapshot database has a data storage unit corresponding to the master database.

[0033] Optionally, when any tab in the target page has data addition, the second data processing unit sends the change of data to the snapshot database, and stores data in the snapshot database according to a data change time, which comprises:

[0034] sending all the added data in the target page to the snapshot database through the change log;

[0035] storing the added data in the snapshot database in a storage unit corresponding to the master database, and recording a data addition time.

[0036] Optionally, when any tab in the target page has data change or data deletion, the second data processing unit sends the change of data to the snapshot database, and stores data in the snapshot database according to a data change time, which comprises:

[0037] sending the changed data in the target page to the snapshot database through the change log;

[0038] The changed data is stored in a storage unit corresponding to the master database in the snapshot database, and data change or data deletion time is recorded.

[0039] Optionally, the apparatus further comprises a data query unit configured to query all data change records corresponding to the target data in the data storage unit of the data snapshot library according to an ID of the target data.

[0040] The data record corresponding to the query change time and the data change record before the query change time are searched in the all change records.

[0041] The target data is obtained based on the data record corresponding to the query change time and the data change record before the query change time.

[0042] Optionally, the data query unit obtains the target data based on the data record corresponding to the query change time and the data change record before the query change time comprises:

[0043] The data record corresponding to the query change time and the data change record before the query change time are sorted in time order to obtain a plurality of data records.

[0044] A first data in the plurality of data records is obtained as temporary data.

[0045] A value recorded in a second data in the plurality of data records is replaced with a corresponding value in the first data to obtain first temporary data.

[0046] When a third data does not exist in the plurality of data records, the first temporary data is taken as the target data.

[0047] When the third data exists in the plurality of data records, a value recorded in the third data is replaced with a corresponding value in the first temporary data to obtain second temporary data.

[0048] When a fourth data does not exist in the plurality of data records, the second temporary data is taken as the target data.

[0049] In a third aspect, the present application provides an apparatus, the apparatus comprising a memory and a processor, the memory being configured to store instructions or codes, and the processor being configured to execute the instructions or codes to enable the apparatus to perform the implicit full-page data snapshot method introduced in any implementation manner of the first aspect.

[0050] In a fourth aspect, the present application provides a computer readable storage medium, wherein the computer readable storage medium stores code, when the code is executed, an apparatus executing the code implements the implicit full-page data snapshot method introduced in any implementation manner of the first aspect.

[0051] The present application provides an implicit full-page data snapshot method. When executing the method, when the tab in the target page changes, the change of the change log record data in the main database is triggered, the change of the data is sent to the snapshot database, and the data is stored according to the data change time in the snapshot database. This method ensures the real-time synchronization and consistency of the data, so that the snapshot database can immediately reflect the latest state of the main database. Secondly, the snapshot database stores data according to the data change time, which provides great convenience for data backtracking and analysis, and helps enterprises better track the historical state and change trend of data. In addition, this mechanism also enhances the reliability and security of data, even if the main database fails, the snapshot database can quickly recover data and ensure business continuity. In summary, this method not only improves the data processing efficiency, but also provides strong support for the data management and application of enterprises. BRIEF DESCRIPTION OF DRAWINGS

[0052] To make the technical solutions in the embodiments or the prior art clearer, the following will briefly introduce the drawings needed to be used in the embodiments or the prior art description. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor on the basis of these drawings.

[0053] Figure 1 A flowchart of an implicit full-page data snapshot method provided by the embodiments of the present application;

[0054] Figure 2 A display page schematic diagram with implicit full-page provided by the embodiments of the present application;

[0055] Figure 3 A database storage structure schematic diagram provided by the embodiments of the present application;

[0056] Figure 4 A structure schematic diagram of an implicit full-page data snapshot device provided by the embodiments of the present application. DETAILED DESCRIPTION

[0057] In order to make the purpose, technical solutions and advantages of the embodiments of this application more clear, the technical solutions in the embodiments of this application will be clearly and completely described below in conjunction with the drawings in the embodiments of this application. Obviously, the embodiments described are only part of the embodiments of this application, not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.

[0058] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with the relevant laws, regulations and standards of relevant countries and regions.

[0059] Figure 1 A flowchart of an implicit full-page data snapshot method provided in an embodiment of the present application.

[0060] Combine Figure 1 As shown, the implicit full-page data snapshot method provided in the embodiment of the present application may include:

[0061] S101. When data changes occur in a tab page of a target page, a change log in a master database is triggered to record the data changes.

[0062] The target page is the page where the data is to be changed. This page can contain multiple tabs, but only one page can be displayed at a time; the other pages are not displayed. The pages where data is to be changed include both the currently displayed page and the currently undisplayed pages. In other words, data changes may occur on both the currently displayed page and the currently undisplayed pages.

[0063] Specifically, the data changes include data addition, data modification or data deletion. Since multiple tabs are included, different original data in different tabs may have the same data changes or different data changes at the same time. For example, a target page includes three tabs, such as Figure 2 As shown, Figure 2A schematic diagram of a display page with an implicit full page is provided for an embodiment of the present application, which includes three tabs, namely education information, personal information and family information. The currently displayed interface is the personal information page, and the education information and family information pages are not displayed. In the currently displayed personal page, there are three items of data that can be modified or filled in, namely user name, age and hobbies. Similarly, the undisplayed interface also includes one or more items of data that can be modified or filled in. At a certain moment, for example, on January 19, 2024, at 09:55:55, the data in the three tabs have all changed. At this time, data has been added to all three pages, or data has been added to one of the pages, and data has been changed on the other two pages.

[0064] Since the data in different pages may change, storing the data together will lead to data confusion. Therefore, in one implementation of the embodiment of the present application, each of the multiple tab pages has a corresponding data storage unit in the main database, and the snapshot database has a data storage unit that corresponds to the main database one by one. Figure 3 As shown, Figure 3 A schematic diagram of a database storage structure provided for an embodiment of the present application shows a master data and a snapshot database. The master database refers to the place where the data in the target page is stored, and the snapshot refers to a backup of all the data involved in the current target page. Regardless of the currently displayed tab or the currently undisplayed tab, the relevant data must be backed up. Therefore, the snapshot database refers to the database used to store backup data. In order to ensure more reasonable data storage, multiple data storage units are divided in the master database and the snapshot database, such as Figure 3 As shown in the data table 1, data table 2 and data table 3 in the data table, the data table 1, data table 2 and data table 3 represent different storage units in the database. Further, different tabs correspond to different data storage units, for example, Figure 2 The Education Information tab in the Figure 3 The data storage unit in Table 1 in the same way for other tabs is that each of the multiple tabs has a corresponding data storage unit in the main database. In addition, since the snapshot database is used to store backup data, the data storage unit in the snapshot database corresponds to the data storage unit in the main database, such as Figure 3 In the main database, data tables 1, 2, and 3 correspond to data tables 1, 2, and 3 in the snapshot database. That is, when the data in a storage unit in the main database changes, the corresponding data storage unit in the snapshot database will also change.

[0065] When the data in the target page changes, including any changes to any data in any page within the target page, the corresponding data storage unit in the master database will also change. At this time, a binlog, or database change log, will be triggered. If a piece of data in the database changes, a binlog log will be generated. This change can be the addition of a piece of data, the deletion of a piece of data, or the modification of a piece of data. At this time, the change log can record the data changes.

[0066] S102: Send the data change information to a snapshot database, and store the data in the snapshot database according to the data change time.

[0067] The above steps describe how data changes can be recorded through a change log. At the same time, the change log synchronizes the specific changes of the data to the data snapshot library, so that the data changes are backed up in the data snapshot library.

[0068] The following describes an example of how to obtain data from a change log and store the data in a snapshot database. Table 1 is a data storage table in a snapshot database storage unit provided in an embodiment of the present application, hereinafter referred to as a data storage table.

[0069] Table 1: Data storage table

[0070]

[0071]

[0072] In one implementation of the embodiment of the present application, when data is added to any tab page in the target page, the data change is sent to the snapshot database, and the data is stored in the snapshot database according to the data change time, including: sending all the newly added data in the target page to the snapshot database through the change log; storing the newly added data in the snapshot database in the storage unit corresponding to the main database, and recording the time of data addition. The content in the change log is data:{"id":"1","name":"张三","age":"25","hobby":"篮球","updateTime":"2024-01-19 09:55:55"}, which means that this is a piece of personnel data to be inserted into the main database. Assume that this content corresponds to data table 1 in the main database. When stored in the snapshot database, it also needs to be stored in data table 1 in the snapshot database. The storage method is as shown in the first item in Table 1 above, and the corresponding user id, name, age, hobby and upload time in the change log are synchronized in the corresponding storage unit in the snapshot database.

[0073] In the foregoing description, the detailed process of how data is sent to the snapshot database and stored by data change time when any tab page in the target page undergoes data addition has been understood. The case of data change or data deletion will be introduced below. When any tab page in the target page undergoes data change or data deletion, the change of the data is sent to the snapshot database, and the data is stored in the snapshot database according to the data change time, which includes: sending the changed data in the target page to the snapshot database through the change log; storing the changed data in the storage unit corresponding to the master database in the snapshot database, and recording the data change or data deletion time.

[0074] When the data on any tab page in the target page changes, for example, the user's age, hobbies, and other fields are modified, the change log will capture these changes. The content of the change log will reflect the data change content. The following is a hypothetical change log example to illustrate the case of data change: data: {"id":"1","age":"26","updateTime":"2024-01-19 10:55:55"}. This change log will be sent to the snapshot database. In the snapshot database, the corresponding record in data table 1 corresponding to the master database will be updated to reflect these changes, and the change result is shown in the second row of the above table 1. At the same time, the snapshot database will record the time of data change. In this way, the snapshot database can keep a historical record of data change.

[0075] When the data on any tab page in the target page is deleted, the change log will record this deletion event. The change log may contain the identification (such as ID) of the deleted data and the time of deletion. The following is a hypothetical change log example to illustrate the case of data deletion: data: {"id":"1","updateTime":"2024-01-21 11:05:45","changeType":"delete"}. This deletion log will also be sent to the snapshot database. In the snapshot database, in the data table 1 corresponding to the master database, because the purpose of the snapshot database is to keep historical records, therefore the record will not be directly deleted, but one of the following strategies may be taken:

[0076] Marked deletion: add a marked field (such as is_deleted) in the data table, set it to true, and record the deletion time.

[0077] Soft deletion: move the data to another table specially used to store deleted data, but still keep the integrity of the data and the deletion timestamp.

[0078] Version control: All versions of data are kept in the data table, but a special record is added for the delete operation to indicate which version of data has been deleted.

[0079] Regardless of the strategy taken, the snapshot database records the time of data deletion for subsequent data recovery, audit, or analysis use.

[0080] In summary, whether it is data addition, change, or deletion, the snapshot database synchronizes data changes in the master database by receiving change logs and stores them according to the data change time, thereby providing users with a historical view of data and recovery capabilities.

[0081] The above embodiments introduce the process of data backup in the snapshot database when data changes, to enable quick retrieval of the corresponding content in the snapshot database when a user needs to obtain data at a certain time. The following embodiment describes the process of data recovery based on the storage content in the snapshot database.

[0082] First, the ID of the target data is queried in the data storage unit of the data snapshot library to obtain all data change records corresponding to the target data. Then, the data record corresponding to the query change time and the data change record before the query change time are found in the all change records. Finally, the target data is obtained based on the data record corresponding to the query change time and the data change record before the query change time.

[0083] As shown in Table 1 above, the ID of the data is stored in the data table in the snapshot database. When data recovery is performed, all data change records need to be found based on the ID of the target data. For example, when the ID of the target data is 1, the search result based on the ID is shown in Table 1 above, and three records are obtained. Further, it is necessary to know what time of snapshot data the user needs. For example, the user wants data at 2024-01-19 10:55:55. The original appearance of the data is the first two data in Table 1 above, i.e., the data record corresponding to the query change time and the data change record before the query change time. Then, the two data are combined to obtain the data needed by the user, i.e., the target data.

[0084] The process of combining the data record corresponding to the query change time and the data change record before the query change time based on the user ID and the query time to obtain the target data is described below:

[0085] Firstly, the data records corresponding to the change query change time and the data change records before the change query time are sorted in time from front to back to obtain a plurality of data records; a first data in the plurality of data records is obtained as temporary data; the value recorded in a second data in the plurality of data records is replaced with the corresponding value in the first data to obtain first temporary data; when there is no third data in the plurality of data records, the first temporary data is taken as target data; when there is third data in the plurality of data records, the value recorded in the third data is replaced with the corresponding value in the first temporary data to obtain second temporary data; when there is no fourth data in the plurality of data records, the second temporary data is taken as target data.

[0086] That is, the data obtained according to the ID and the user's desired query time may include two or more, and after obtaining the data according to the user ID and the user's desired query time, the data needs to be sorted in ascending order of update Time.

[0087] For the case where the query result only contains two data, such as Table 1 above, the data in Table 1 is data that has been sorted in ascending order of update Time. When the user wants data at 2024-01-19 10:55:55, the data obtained according to the ID and the time query is the first two data in Table 1 above, so at this time, the first data in Table 1 is taken as temporary data, and then the value in the second data is replaced with the corresponding value in the temporary data, that is, the age value 26 in the second data is replaced with the corresponding age value 25 in the temporary data, so the user can obtain the data at 2024-01-19 10:55:55, which is "name Zhang San, age 26, hobby basketball", and take this data as the first temporary data. Since there are only two data in the query result, the first temporary data is directly taken as target data.

[0088] For the case that the query result contains more than two pieces of data, for example, three pieces of data, as in Table 1, the user wants the data at 2024-01-19 11:55:55, and the original appearance of the data is the first three pieces of data in Table 1. At this time, the first piece of data in Table 1 is taken as temporary data, and the values in the second piece of data are replaced with the corresponding values in the temporary data to obtain first temporary data. Since there is a third piece of data, the above process needs to be repeated, and the values in the third piece of data are replaced with the values in the first temporary data to obtain second temporary data. That is, the hobby of basketball in the third piece of data is replaced with the hobby in the first temporary data "Name Zhang San, Age 26, Hobby Basketball", and the replacement result is "Name Zhang San, Age 26, Hobby Table Tennis", which is taken as the second temporary data. Since there are only three pieces of data in the query result, the second temporary data is directly taken as the target data. That is, the data at 2024-01-19 11:55:55 is "Name Zhang San, Age 26, Hobby Table Tennis". That is, for the data in the query result, the fields or values with values need to be gradually overwritten on the temporary data of the previous piece to obtain new temporary data, and the final temporary data is taken as the target data.

[0089] The above embodiment is only an introduction to the data change and data recovery process in a tab page in a target page. For a target page including multiple implicit pages in the present application, all data changes and data recovery processes in the entire page are applicable to the method introduced in the above embodiment.

[0090] The above is some specific implementation modes of the implicit full-page data snapshot method provided by the embodiment of the present application. Based on this, the present application further provides a corresponding device. The device provided by the embodiment of the present application will be introduced from the perspective of functional modularization.

[0091] Figure 4 The structure diagram of the implicit full-page data snapshot device provided by the embodiment of the present application is shown. In combination with Figure 4 The implicit full-page data snapshot device 400 provided by the embodiment of the present application includes:

[0092] The first data processing unit 410 is configured to trigger the change of the change log record data in the main database when the tab page in the target page changes.

[0093] The second data processing unit 420 is configured to send the change of the data to the snapshot database, and store the data according to the data change time in the snapshot database.

[0094] In an implementation form of the embodiment of the application, the target page has a plurality of tabs, and the first data processing unit is specifically configured to trigger a change in the change log record data in the master database when one or more tabs in the target page have data addition, data change or data deletion.

[0095] In an implementation form of the embodiment of the application, each of the plurality of tabs has a corresponding data storage unit in the master database, and the snapshot database has a data storage unit corresponding to the master database.

[0096] In an implementation form of the embodiment of the application, when any tab in the target page has data addition, the second data processing unit sends the data change to the snapshot database, and the snapshot database stores data according to data change time, including:

[0097] The added data in the target page is sent to the snapshot database through the change log;

[0098] The added data is stored in the storage unit corresponding to the master database in the snapshot database, and the data addition time is recorded.

[0099] In an implementation form of the embodiment of the application, when any tab in the target page has data change or data deletion, the second data processing unit sends the data change to the snapshot database, and the snapshot database stores data according to data change time, including:

[0100] The changed data in the target page is sent to the snapshot database through the change log;

[0101] The changed data is stored in the storage unit corresponding to the master database in the snapshot database, and the data change or data deletion time is recorded.

[0102] In an implementation form of the embodiment of the application, the device further comprises a data query unit configured to query all data change records corresponding to the target data in the data storage unit of the data snapshot database according to the ID of the target data;

[0103] Find the data record corresponding to the to-be-queried change time and the data change record before the to-be-queried change time in the all change records;

[0104] Obtain the target data based on the data record corresponding to the to-be-queried change time and the data change record before the to-be-queried change time.

[0105] In an implementation form of the embodiment of the application, the data query unit obtains the target data based on the data record corresponding to the change time to be queried and the data change record before the change time to be queried.

[0106] The data record corresponding to the change time to be queried and the data change record before the change time to be queried are sorted in time from front to back to obtain a plurality of data records.

[0107] The first data in the plurality of data records is obtained as temporary data.

[0108] The value recorded in the second data in the plurality of data records is replaced with the corresponding value in the first data to obtain first temporary data.

[0109] When the third data does not exist in the plurality of data records, the first temporary data is taken as the target data.

[0110] When the third data exists in the plurality of data records, the value recorded in the third data is replaced with the corresponding value in the first temporary data to obtain second temporary data.

[0111] When the fourth data does not exist in the plurality of data records, the second temporary data is taken as the target data.

[0112] The embodiment of the application also provides a corresponding device and a computer storage medium for implementing the scheme provided by the embodiment of the application.

[0113] The device includes a memory and a processor, the memory is used to store instructions or codes, and the processor is used to execute the instructions or codes to enable the device to execute the method described in any embodiment of the application.

[0114] The computer storage medium stores codes, and when the codes are executed, the device executing the codes implements the method described in any embodiment of the application.

[0115] As known by those skilled in the art from the description of the above embodiments, all or part of the steps of the above-mentioned embodiment methods can be implemented by means of software and a general hardware platform. Based on this understanding, the technical solutions of the application can be embodied in the form of a software product. The computer software product can be stored in a storage medium such as a read-only memory (English: read-only memory, ROM) / RAM, a magnetic disk, an optical disk, etc., and includes a plurality of instructions for enabling a computer device (which can be a personal computer, a server, or a network communication device such as a router) to execute the method described in each embodiment or some parts of the embodiments of the application.

[0116] It can be understood that in the specific embodiments of the present application, the user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved need to obtain user permission or consent, and the collection, use and processing of related data need to comply with relevant laws, regulations and standards of relevant countries and regions.

[0117] It should be noted that the relational terms herein such as first and second and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any such actual relationship or order between such entities or actions. Moreover, the terms "comprises", "comprising", or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but can include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element preceded by "comprises... a" does not, without more constraints, foreclose the existence of additional identical elements in the process, method, article, or apparatus that comprises the recited element.

[0118] It should also be noted that each of the embodiments in the present specification is described in a progressive manner, and the same parts between each embodiment can be referred to each other, and each embodiment mainly describes the difference from other embodiments. Especially, the device and apparatus embodiments are described more simply because they are basically similar to the method embodiments, and the relevant parts can be referred to the part of the description of the method embodiments. The above-described device and apparatus embodiments are only illustrative, and the units described as separate components can or can not be physically separated, and the components indicated as units can or can not be physical units, i.e. they can be located in one place or distributed on multiple network units. Part or all of the modules can be selected to achieve the purpose of the present embodiment scheme according to actual needs. Those skilled in the art can understand and implement it without creative labor.

[0119] The above is only one specific embodiment of the present application, but the protection scope of the present application is not limited thereto, and any changes or replacements within the technical scope disclosed in the present application can be easily thought of by those skilled in the art, which should be covered in the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.

Claims

1. An implicit full-page data snapshot method, characterized in that: The method comprises: When the data in the tab page of the target page changes, the change log in the main database is triggered to record the data change; The change of the data is sent to a snapshot database, and the data is stored in the snapshot database according to the data change time.

2. The method according to claim 1, characterized in that The target page has multiple tab pages, and data changes in the tab pages of the target page include: One or more tabs in the target page have new data, data changes, or data deletions.

3. The method according to claim 2, characterized in that Each of the plurality of tab pages has a corresponding data storage unit in the main database, and the snapshot database has a data storage unit corresponding to the main database on a one-to-one basis.

4. The method according to claim 3, characterized in that When data is newly added to any tab page of the target page, sending the data change to the snapshot database, and storing the data in the snapshot database according to the data change time includes: Sending all newly added data in the target page to the snapshot database through the change log; The newly added data is stored in the storage unit corresponding to the main database in the snapshot database, and the time when the data is added is recorded.

5. The method according to claim 3, characterized in that When data is changed or deleted in any tab page of the target page, sending the data change to the snapshot database, and storing the data in the snapshot database according to the data change time includes: Sending the changed data in the target page to the snapshot database through the change log; The changed data is stored in the storage unit corresponding to the main database in the snapshot database, and the data change or data deletion time is recorded.

6. The method according to claim 1, characterized in that The method further comprises: According to the ID of the target data, query all data change records corresponding to the target data in the data storage unit of the data snapshot library; Searching for data records corresponding to the change time to be queried and data change records before the change time to be queried in all the change records; The target data is obtained based on the data record corresponding to the change time to be queried and the data change record before the change time to be queried.

7. The method according to claim 6, characterized in that The obtaining of the target data based on the data record corresponding to the change time to be queried and the data change record before the change time to be queried includes: Sort the data records corresponding to the change time to be queried and the data change records before the change time to be queried in chronological order to obtain multiple data records; Obtaining the first data of the plurality of data records as temporary data; Replacing the corresponding value in the first data record with the value recorded in the second data record in the plurality of data records to obtain first temporary data; When the third piece of data does not exist in the plurality of data records, using the first temporary data as the target data; When there is a third piece of data in the plurality of data records, replacing the value recorded in the third piece of data with the value corresponding to the first temporary data to obtain second temporary data; When the fourth piece of data does not exist in the plurality of data records, the second temporary data is used as the target data.

8. An implicit full-page data snapshot device, characterized in that: The device comprises: The first data processing unit is configured to trigger a change log in the master database to record the data change when data changes occur in the tab page of the target page; The second data processing unit is configured to send the data change information to a snapshot database, and store the data in the snapshot database according to the data change time.

9. A computing device, characterized in that The computing device includes: a memory and a processor; The memory is used to store computer programs; The processor is configured to implement the method according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Images