CN113419937A - Data and log integrated value log implementation method, device, equipment and storage medium - Google Patents
Data and log integrated value log implementation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN113419937A CN113419937A CN202110728025.3A CN202110728025A CN113419937A CN 113419937 A CN113419937 A CN 113419937A CN 202110728025 A CN202110728025 A CN 202110728025A CN 113419937 A CN113419937 A CN 113419937A
- Authority
- CN
- China
- Prior art keywords
- data
- value log
- log
- record
- writing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 64
- 238000003780 insertion Methods 0.000 claims description 32
- 230000037431 insertion Effects 0.000 claims description 32
- 238000012217 deletion Methods 0.000 claims description 31
- 230000037430 deletion Effects 0.000 claims description 31
- 238000012986 modification Methods 0.000 claims description 18
- 230000004048 modification Effects 0.000 claims description 18
- 238000012545 processing Methods 0.000 claims description 12
- 238000006243 chemical reaction Methods 0.000 claims description 9
- 238000011010 flushing procedure Methods 0.000 claims description 5
- 230000001680 brushing effect Effects 0.000 claims description 3
- 238000004590 computer program Methods 0.000 claims description 2
- 230000001174 ascending effect Effects 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
- G06F11/3476—Data logging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a method, a device, equipment and a storage medium for realizing a data and log integrated value log, wherein the whole device only has sequential writing, and the performance is improved by 10 times or even more than the traditional random writing condition; only 1 part of data is written, so that the condition that 3-4 parts of data need to be written in the traditional database is avoided.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method, a device, equipment and a storage medium for realizing data and log integrated value logs.
Background
The log is an important component of data processing systems such as a database and various Key-Value (KV for short), and the like, and the data processing systems such as the database/KV and the like can modify the copy of the data in the memory only by persisting the modified content in the data page into the log, and do not need to write the data into a disk every time of modification. The method has the advantages that log writing is sequential I/O of a small block area, while data writing of data processing systems such as a database/KV system and the like is random I/O, and through log persistence, the reliability of data storage is guaranteed, and the efficiency of data writing is improved.
In practical applications, in order to ensure that the system can be recovered to any time point, the existing database and various KV-based data processing systems also start an archive log. In addition, to meet the requirement of multi-version concurrency control, most databases such as Oracle and the like also write historical versions of data into the rollback section when updating the data so that other transactions can access the data before modification. Therefore, the conventional database is equivalent to four copies of data to be written in practical application: the first part is the actual data of the user, the second part is the online redo log which is rewritten circularly, the third part is the rollback data which is written when the data is updated, and the last part is the archive log. Three to four data copies need to be written in the actual production environment of the traditional database, so that the whole process is complex to process and low in performance.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a method, an apparatus, a device and a storage medium for implementing a data and log integrated value log, which only have sequential writing, the performance is 10 times or more higher than that of the conventional random writing, only 1 part of data is written, and the condition that 3-4 parts of data need to be written in the conventional database is avoided.
In order to solve the above technical problem, the present invention provides a data and log integrated value log implementation method, which comprises the following steps:
(1) a working thread or a process in the data processing system analyzes the received operation request and determines the operation type;
(2) when the operation type is data updating operation, the work thread or the process converts the deleting operation and the modifying operation into inserting operation;
(3) the working thread or process executes insertion operation in the memory and generates physical records with the same format as that of the physical records which are finally written into the disk storage device in the memory, and then the physical records in the memory are directly written into the value log file or are firstly written into the value log buffer area, the disk writing thread or process is waited for disk refreshing, and after the disk refreshing is completed, the operation result is sent to the client;
(4) when the value log buffer is started, the disk writing thread or process continuously writes the physical recording sequence of the value log buffer into the end of the value log file, and informs the working thread or process of completing the disk flushing task. Because the whole data updating history is in the value log file, the file can simultaneously play the functions of data, online logs, rollback segments and filing logs, and the file is called as a value log system.
Preferably, in step (2), the data update operation includes insertion, deletion and modification.
Preferably, in the step (2), the operation of converting both the deletion operation and the modification operation into the insertion operation by the work thread or the process is specifically: the deletion operation is converted into the insertion of a record containing a key and a deletion mark, and the modification operation is converted into the insertion of a record containing a key and a deletion mark and the insertion of a new modified record, so that all data updating operations in the whole system are changed into the insertion operation.
Correspondingly, a data and log integrated value log implementation device comprises:
the operation analysis module is responsible for analyzing the received operation request and determining the operation type;
the operation conversion module is used for converting the data updating operation;
the execution module completes data insertion operation and generates a physical record with a format consistent with that in the final value log file in the memory; then, directly writing the physical record into the tail part of the value log file, or firstly writing the physical record into a value log buffer area, then, a special value log writing module is responsible for writing the physical record in the value log buffer area into the value log file, and after the disk is flushed, sending an operation result to a client;
the value log buffer area module is used for caching the physical record generated by the data updating operation; after the execution module generates the physical record in the memory, the execution module can selectively write the physical record into the value log buffer.
And the value log writing module is used for continuously writing the physical recording sequence of the value log buffer area into the end of the value log file by the disk writing thread and informing the working thread/process of completing the disk brushing task.
Preferably, the operation conversion module is configured to convert the data update operation specifically as follows: when the operation type is data updating operation, the operation conversion module converts the deletion operation and the modification operation into insertion operation, converts the deletion operation into the insertion of a record containing a key and a deletion mark, and converts the modification operation into the insertion of a record containing a key and a deletion mark and the insertion of a new modified record.
Preferably, the data update operations include insertion, deletion and modification.
Correspondingly, a data and log integrated value log implementation device comprises: one or more processors;
storage means for storing one or more programs, user data;
when executed by one or more processors, cause the one or more processors to implement a data and log integrated value logging implementation method as in any one of the embodiments of the invention.
Accordingly, a data and log integrated value log implementing storage medium on which a computer program is stored, the program, when executed by a processor, implementing a data and log integrated value log implementing method as described in any one of the embodiments of the present invention.
The invention has the beneficial effects that: the whole system only has sequential writing, and the performance is improved by 10 times or more than that of the traditional random writing; only 1 part of data is written, so that the condition that 3-4 parts of data need to be written in the traditional database is avoided.
Drawings
Fig. 1 is a schematic flow chart of an implementation method provided in embodiment 1 of the present invention.
Fig. 2 is a schematic flow chart of an implementation method provided in embodiment 2 of the present invention.
Fig. 3 is a schematic flow chart of an implementation method provided in embodiment 3 of the present invention.
Detailed Description
The embodiment of the invention realizes the integration of user data, online logs, rollback files and filing log files by converting data updating operation into sequential writing operation at the tail part of the file in a database or a data processing system such as KV and the like.
And receiving the operation request by a working thread/process of a data processing system such as a database or KV and the like, and judging the operation type. When the operation type is a data updating (including inserting, deleting and modifying) operation, the working thread/process converts the deleting operation and the modifying operation into an inserting operation, such as converting the deleting operation into an inserting record containing a key and a deleting mark (indicating that the record containing the corresponding key is deleted), and converting the modifying operation into an inserting record containing the key and the deleting mark and a new modified record. And then the working thread/process performs insertion operation in the memory and generates a physical record, and then the physical record can be directly written into the tail part of the value log file, or firstly written into the value log buffer area and then waits for the disk writing thread/process to flush the disk. And the disk writing thread/process continuously writes the physical recording sequence of the value log buffer area into the end of the value log file and informs the working thread/process of completing the disk brushing task. This makes all data update operations in the entire system become sequential write operations. And finally, the working thread/process informs the client of the completion of the operation.
The first embodiment is as follows:
fig. 1 is a flowchart of a value log implementation method according to an embodiment of the present invention. The present embodiment may be used to implement a value logging system, and the method may be implemented by a value logging device in the embodiment of the present invention, and the device may be implemented in a software and/or hardware manner, as shown in fig. 1, and the method specifically includes the following steps:
s101, receiving a processing request by a data processing system such as a database/KV and the like, and determining an operation type.
S102, when the operation type is data updating (including inserting, deleting and modifying) operation, the working thread/process converts the deleting operation and the modifying operation into inserting operation, for example, converts the deleting operation into inserting a record containing a key and a deleting mark (indicating that the record containing the corresponding key is deleted, and the deleting mark can have various different indicating methods when being specifically realized), and converts the modifying operation into inserting a record containing the key and the deleting mark and inserting a new modified record. This makes all data update operations in the entire system become insert operations.
Taking the delete statement in the database as an example, assuming that there exists a table T1, PK is the primary key column, the following statements are executed:
DELETE FROM T1 WHERE PK＝1；
when processed, it translates into pseudo-sentences like
INSERT INTO T1(PK, LSN, FLAG) VALUES (1, current LSN, DELETE _ FLAG);
the LSN has the same meaning with a common log sequence number in a database system and is a self-increasing integer, when the statement is executed, the primary key index comprises the LSN as the last column of the index, and the LSNs are arranged in a descending order, so that the latest record can be ensured to be inquired firstly in the follow-up inquiry.
And thereafter for if the following query is executed
SELECT*FROM T1 WHERE PK＝1；
Because the LSNs are arranged in a descending order, the records with the deletion marks are searched firstly, but not the records before the deletion operation, the records with the deletion marks indicate that the records are deleted, and the empty result set is directly returned to the user.
Alternatively, different flag techniques may be employed to indicate that a record has been deleted.
Alternatively, the LSNs may be implemented by other similar schemes, or even the LSNs may be arranged in ascending order, so that the records of the same KEY are scanned until the last visible result, for the above use case, if the LSNs are arranged in ascending order, the same KEY is scanned until the last record, and the deletion flag may be found, so as to return to the empty result set.
Optionally, for the modification operation, if there is a KEY in the similar database or KEY in the KV system to ensure uniqueness, the modification operation may be directly converted into inserting a new modified record without first generating a record with a deletion flag to further improve performance.
S103, the working thread/process executes insertion operation in the memory and generates physical records in the same format as the physical records which are finally written into storage devices such as a disk and the like in the memory, then the physical records in the memory can be written into a value log buffer area, disk refreshing is waited for by the disk writing thread/process, and after the disk refreshing is completed, the operation result is sent to the client.
Specifically, the log buffer is similar to the log buffer of a conventional database and can be recycled, and the corresponding buffer space can be reused as long as the corresponding buffer content has been written to the disk.
S104, the disk-flushing thread/process continuously writes the physical recording sequence of the value log buffer area into the end of the value log file, and informs the working thread/process to complete the disk-flushing task.
Example two:
fig. 2 is a flowchart of a value log implementation method according to a second embodiment of the present invention. The present embodiment may be used to implement a value logging system, and the method may be implemented by a value logging device in the embodiment of the present invention, and the device may be implemented in a software and/or hardware manner, as shown in fig. 2, and the method specifically includes the following steps:
s201, receiving a processing request by a data processing system such as a database/KV and the like, and determining an operation type.
S202, when the operation type is a data updating (including inserting, deleting, modifying) operation, the worker thread/process converts both the deleting and modifying operations into inserting operations, such as converting the deleting operation into inserting a record containing a key and a deleting mark (indicating that the record containing the corresponding key has been deleted, and the deleting mark may have various different indicating methods when being implemented specifically), and converting the modifying operation into inserting a record containing a key and a deleting mark and inserting a new modified record. This makes all data update operations in the entire system become insert operations.
Taking the delete statement in the database as an example, assuming that there exists a table T1, PK is the primary key column, the following statements are executed:
DELETE FROM T1 WHERE PK＝1；
when processed, it translates into pseudo-sentences like
INSERT INTO T1(PK, LSN, FLAG) VALUES (1, current LSN, DELETE _ FLAG);
the LSN has the same meaning with a common log sequence number in a database system and is a self-increasing integer, when the statement is executed, the primary key index comprises the LSN as the last column of the index, and the LSNs are arranged in a descending order, so that the latest record can be ensured to be inquired firstly in the follow-up inquiry.
And thereafter for if the following query is executed
SELECT*FROM T1 WHERE PK＝1；
Because the LSNs are arranged in a descending order, the records with the deletion marks are searched firstly, but not the records before the deletion operation, the records with the deletion marks indicate that the records are deleted, and the empty result set is directly returned to the user.
Alternatively, different flag techniques may be employed to indicate that a record has been deleted.
Alternatively, the LSNs may be implemented by other similar schemes, or even the LSNs may be arranged in ascending order, so that the records of the same KEY are scanned until the last visible result, for the above use case, if the LSNs are arranged in ascending order, the same KEY is scanned until the last record, and the deletion flag may be found, so as to return to the empty result set.
Optionally, for the modification operation, if there is a KEY in the similar database or KEY in the KV system to ensure uniqueness, the modification operation may be directly converted into inserting a new modified record without first generating a record with a deletion flag to further improve performance.
S203, the working thread/process executes insertion operation in the memory and generates physical records in the same format as the physical records which are finally written into storage equipment such as a disk and the like in the memory, and then directly writes the physical records into the tail of the log file, and after the disk is flushed, the operation result is sent to the client.
Example three:
fig. 3 is a flowchart of a value log implementation method according to a second embodiment of the present invention. The present embodiment can be used to implement a value logging system, and the method can be executed by a value logging device in the embodiment of the present invention, and the device can be implemented in a software and/or hardware manner, as shown in fig. 3, and the device includes: an operation analysis module 301, an operation conversion module 302 and an execution module 303.
An operation analysis module: the module is responsible for analyzing the received operation request and determining the operation type.
Operating the conversion module: the module is used for converting data update operations. When the operation type is a data updating (including inserting, deleting and modifying) operation, the operation conversion module converts the deleting and modifying operations into inserting operations.
An execution module: the module completes data insertion (insertion, update and deletion have all been converted into insertion operations) operations and generates physical records in the memory in a format consistent with that in the final value log file. And then directly writing the physical record in the memory into the tail part of the value log file, and then sending the operation result to the client, or writing the physical record into a value log buffer area, waiting for disk writing thread/process disk refreshing, and after the disk refreshing is finished, sending the operation result to the client.
Optionally, the value log buffer module is configured to buffer a physical record generated by the data update operation. After the execution module generates a physical record in the memory, the physical record is written into a value log buffer area, and then a disk writing thread/process is waited for disk refreshing;
optionally, the value log writing module continuously writes the physical records of the value log buffer into the end of the value log file, and notifies the working thread/process to complete the disk flushing task after writing.
Claims (8)
1. A data and log integrated value log implementation method is characterized by comprising the following steps:
(1) a working thread or a process in the data processing system analyzes the received operation request and determines the operation type;
(2) when the operation type is data updating operation, the work thread or the process converts the deleting operation and the modifying operation into inserting operation;
(3) the working thread or process executes insertion operation in the memory and generates physical records with the same format as that of the physical records which are finally written into the disk storage device in the memory, and then the physical records in the memory are directly written into the value log file or are firstly written into the value log buffer area, the disk writing thread or process is waited for disk refreshing, and after the disk refreshing is completed, the operation result is sent to the client;
(4) when the value log buffer is started, the disk writing thread or process continuously writes the physical recording sequence of the value log buffer into the end of the value log file, and informs the working thread or process of completing the disk flushing task.
2. The data and log integrated value log implementation method of claim 1, wherein in step (2), the data update operation includes insertion, deletion and modification.
3. The data and log integrated value log realization method of claim 1, wherein in the step (2), the operation of converting both deletion and modification operations into insertion operations by a worker thread or process is specifically: the deletion operation is converted into the insertion of a record containing a key and a deletion mark, and the modification operation is converted into the insertion of a record containing a key and a deletion mark and the insertion of a new modified record, so that all data updating operations in the whole system are changed into the insertion operation.
4. A data and log integrated value log implementation device is characterized by comprising:
the operation analysis module is responsible for analyzing the received operation request and determining the operation type;
the operation conversion module is used for converting the data updating operation;
the execution module completes data insertion operation and generates a physical record with a format consistent with that in the final value log file in the memory; then, directly writing the physical record into the tail part of the value log file, or firstly writing the physical record into a value log buffer area, then, a special value log writing module is responsible for writing the physical record in the value log buffer area into the value log file, and after the disk is flushed, sending an operation result to a client;
the value log buffer area module is used for caching the physical record generated by the data updating operation; after the execution module generates the physical record in the memory, the execution module can selectively write the physical record into the value log buffer.
And the value log writing module is used for continuously writing the physical recording sequence of the value log buffer area into the end of the value log file by the disk writing thread and informing the working thread/process of completing the disk brushing task.
5. The data and log integrated value log realization device of claim 4, wherein the operation conversion module is configured to convert the data update operation specifically as follows: when the operation type is data updating operation, the operation conversion module converts the deletion operation and the modification operation into insertion operation, converts the deletion operation into the insertion of a record containing a key and a deletion mark, and converts the modification operation into the insertion of a record containing a key and a deletion mark and the insertion of a new modified record.
6. The data and log integrated value log enabling device of claim 4, wherein data update operations include insertion, deletion, and modification.
7. A data and log integrated value log implementation device, comprising: one or more processors;
storage means for storing one or more programs, user data;
when executed by one or more processors, cause the one or more processors to implement a data and log integrated value log implementation method as recited in any one of claims 1 to 3.
8. A data and log integrated value log implementing storage medium, having stored thereon a computer program which, when executed by a processor, implements a data and log integrated value log implementing method as claimed in any one of claims 1 to 3.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110728025.3A CN113419937A (en) | 2021-06-29 | 2021-06-29 | Data and log integrated value log implementation method, device, equipment and storage medium |
| PCT/CN2021/112761 WO2023272895A1 (en) | 2021-06-29 | 2021-08-16 | Data and log integrated value log implementation method, apparatus and device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110728025.3A CN113419937A (en) | 2021-06-29 | 2021-06-29 | Data and log integrated value log implementation method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113419937A true CN113419937A (en) | 2021-09-21 |
Family
ID=77717112
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110728025.3A Pending CN113419937A (en) | 2021-06-29 | 2021-06-29 | Data and log integrated value log implementation method, device, equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN113419937A (en) |
| WO (1) | WO2023272895A1 (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117348586B (en) * | 2023-10-11 | 2024-02-27 | 江苏云涌电子科技股份有限公司 | Event sequence record SOE implementation method based on energy storage EMS system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080104443A1 (en) * | 2006-10-30 | 2008-05-01 | Hiroaki Akutsu | Information system, data transfer method and data protection method |
| CN110109927A (en) * | 2019-04-25 | 2019-08-09 | 上海新炬网络技术有限公司 | Oracle database data processing method based on LSM tree |
| CN110209642A (en) * | 2018-02-05 | 2019-09-06 | 北京智明星通科技股份有限公司 | Method, apparatus, server and the computer-readable medium of information processing |
| US20210165651A1 (en) * | 2018-08-10 | 2021-06-03 | Denso Corporation | Electronic control unit, vehicle electronic control system, difference data consistency determination method and computer program product |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8868512B2 (en) * | 2011-01-14 | 2014-10-21 | Sap Se | Logging scheme for column-oriented in-memory databases |
| US10509780B2 (en) * | 2016-06-03 | 2019-12-17 | Dell Products L.P. | Maintaining I/O transaction metadata in log-with-index structure |
| CN110609813B (en) * | 2019-08-14 | 2023-01-31 | 北京华电天仁电力控制技术有限公司 | Data storage system and method |
-
2021
- 2021-06-29 CN CN202110728025.3A patent/CN113419937A/en active Pending
- 2021-08-16 WO PCT/CN2021/112761 patent/WO2023272895A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080104443A1 (en) * | 2006-10-30 | 2008-05-01 | Hiroaki Akutsu | Information system, data transfer method and data protection method |
| CN110209642A (en) * | 2018-02-05 | 2019-09-06 | 北京智明星通科技股份有限公司 | Method, apparatus, server and the computer-readable medium of information processing |
| US20210165651A1 (en) * | 2018-08-10 | 2021-06-03 | Denso Corporation | Electronic control unit, vehicle electronic control system, difference data consistency determination method and computer program product |
| CN110109927A (en) * | 2019-04-25 | 2019-08-09 | 上海新炬网络技术有限公司 | Oracle database data processing method based on LSM tree |
Non-Patent Citations (1)
| Title |
|---|
| 吕雁飞: "闪存数据库管理***关键技术研究", 《中国博士学位论文全文数据库》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2023272895A1 (en) | 2023-01-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8856469B2 (en) | Apparatus and method for logging optimization using non-volatile memory | |
| US9881049B2 (en) | Reducing the cost of update, delete, and append-only insert operations in a database | |
| KR100862661B1 (en) | Method for deferred logging and apparatus thereof | |
| US7840539B2 (en) | Method and system for building a database from backup data images | |
| US9471622B2 (en) | SCM-conscious transactional key-value store | |
| US7698319B2 (en) | Database system management method, database system, database device, and backup program | |
| US8015155B2 (en) | Non-disruptive backup copy in a database online reorganization environment | |
| JP4916892B2 (en) | Log information management system and method for transaction processing | |
| CN104657382A (en) | Method and device for detecting consistency of data of MySQL master and slave servers | |
| EP2336901B1 (en) | Online access to database snapshots | |
| US8595190B2 (en) | Methods and apparatus related to completion of large objects within a DB2 database environment | |
| US7225206B2 (en) | System and method for reorganizing stored data | |
| US10083192B2 (en) | Deleted database record reuse | |
| CN113419937A (en) | Data and log integrated value log implementation method, device, equipment and storage medium | |
| US11693866B2 (en) | Efficient in-memory multi-version concurrency control for a trie data structure based database | |
| CN112783927B (en) | Database query method and system | |
| CN113986591A (en) | Database flashback query method, system, storage medium and equipment based on value log | |
| JP7512519B2 (en) | Management device, database system, management method and program | |
| US10360145B2 (en) | Handling large writes to distributed logs | |
| US20200364124A1 (en) | Efficient handling of raid-f component repair failures | |
| CN113986861A (en) | Data modification history query method and system based on value log system | |
| CN115454941A (en) | Method and system for realizing saving of storage space of log system | |
| CN117591523A (en) | Data processing method and device based on shared storage architecture and computing equipment | |
| CN112182028A (en) | Data line number query method and device based on table of distributed database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210921 |