CN109815213A - It is deleted on a kind of Append-Only database and the method and system of modification data - Google Patents
It is deleted on a kind of Append-Only database and the method and system of modification data Download PDFInfo
- Publication number
- CN109815213A CN109815213A CN201811564243.2A CN201811564243A CN109815213A CN 109815213 A CN109815213 A CN 109815213A CN 201811564243 A CN201811564243 A CN 201811564243A CN 109815213 A CN109815213 A CN 109815213A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- append
- deleted
- field
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present invention provides deletes and the method and system of modification data on a kind of Append-Only database, this method comprises: increasing time field and identification field for each data that are inserted into；Deletion record table is obtained, includes the time field and identification field of all data to be deleted in the deletion record table；According to the time field and identification field in the deletion record table, all data to be deleted in Append-Only database are deleted.The embodiment of the present invention realizes the specific demand that data are deleted in modification in the case where existing Append-Only database, meets the particular demands of user.As user needs a large amount of daily record datas of high speed storing, but need that certain data therein can be deleted or modified at any time again in using the data procedures, using after the method can in the case where being changed without database meet demand.
Description
Technical field
The present embodiments relate in database technical field more particularly to a kind of Append-Only database delete and
Modify the method and system of data.
Background technique
Append-Only is a kind of storage representation, it only allows for newline to be attached in table, but do not allow update or
Delete existing row.This allows the more compact storage on disk, because every row does not need storage MVCC, it means that in inquiry number
When according to library, each affairs can see a data snapshot, it can protect that affairs will not check may be by same data line
Other concurrent updates caused by inconsistent data.This provides transaction isolation for each database session.
MVCC minimizes lock contention, by avoiding the explicit lock methods of conventional database systems so as in multi-user's ring
Reasonable performance is realized in border.
It the use of MVCC concurrency model without the major advantage that is locked out is to inquire data in the MVCC lock of acquisition, read
Access does not conflict according to the lock obtained for write-in data, therefore write operation is never blocked in read operation, and write operation is never
It can prevent read operation.The data that this characteristic makes Append-Only be very suitable to batch are written, high compression ratio, backup logic
It supports incremental backup, therefore records the offset backuped to every time.In addition the BITMAP of backup full dose deletes label every time.
The key property of Append-Only database is the performance in order to improve mass data write-in and inquiry, applied field
Scape is primarily directed to the scene for needing high speed to read mass data.
However certain special circumstances are frequently encountered in actual production environment, need directly in this database modify or
Data are deleted, therefore, a kind of method for needing to modify on Append-Only database or delete data.
Summary of the invention
In view of the above-mentioned problems, the embodiment of the present invention is provided and is deleted on a kind of Append-Only database and modification data
Method and system.
In a first aspect, the embodiment of the present invention provides a kind of method for deleting data on Append-Only database, comprising:
Increase time field and identification field for each data that are inserted into, is inserted into data, the either strap for any
It is inserted into any time for being inserted into data and being written on Append-Only database described in the time field identification of data, it is described
Any identification field for being inserted into data identifies any unique designation for being inserted into data on Append-Only database
Code；
Deletion record table is obtained, includes the time field and identifier word of all data to be deleted in the deletion record table
Section；
According to the time field and identification field in the deletion record table, to all in Append-Only database
Data to be deleted are deleted.
Second aspect, the embodiment of the present invention provide a kind of method that data are modified on Append-Only database, comprising:
Increase time field and identification field for each data that are inserted into, is inserted into data, the either strap for any
It is inserted into any time for being inserted into data and being written on Append-Only database described in the time field identification of data, it is described
Any identification field for being inserted into data identifies any unique designation for being inserted into data on Append-Only database
Code；
Read data to be modified in Append-Only database；
It modifies to the data to be modified, and updates the time field of the data to be modified.
The third aspect, the embodiment of the present invention provide the system that data are deleted on a kind of Append-Only database, comprising:
Field module is inserted into number for any for increasing time field and identification field for each data that are inserted into
According to any data that are inserted into described in the time field identification of the either strap insertion data are written to Append-Only database
On time, any identification field for being inserted into data identifies any data that are inserted into Append-Only data
Unique designation code on library；
Logging modle includes the time of all data to be deleted for obtaining deletion record table, in the deletion record table
Field and identification field；
Removing module, for according to the time field and identification field in the deletion record table, to Append-Only number
It is deleted according to all data to be deleted in library.
Fourth aspect, the embodiment of the present invention provide the system that data are modified on a kind of Append-Only database, comprising:
Field module is inserted into number for any for increasing time field and identification field for each data that are inserted into
According to any data that are inserted into described in the time field identification of the either strap insertion data are written to Append-Only database
On time, any identification field for being inserted into data identifies any data that are inserted into Append-Only data
Unique designation code on library；
Read module, for reading data to be modified in Append-Only database；
Modified module for modifying to the data to be modified, and updates the time field of the data to be modified.
5th aspect, the embodiment of the present invention provide a kind of electronic equipment, comprising:
At least one processor, at least one processor, communication interface and bus；Wherein,
The processor, memory, communication interface complete mutual communication by the bus；
The communication interface is for the information transmission between the test equipment and the communication equipment of display device；
The memory is stored with the program instruction that can be executed by the processor, and the processor calls described program to refer to
It enables being able to carry out on a kind of Append-Only database that first aspect and second aspect provide and deletes and modify data method.
6th aspect, the embodiment of the present invention provide a kind of non-transient computer readable storage medium, which is characterized in that described
Non-transient computer readable storage medium stores computer instruction, and the computer instruction makes the computer execute first aspect
Data method is deleted and modified on a kind of Append-Only database provided with second aspect.
The method and system of data are deleted and modified on a kind of Append-Only database provided in an embodiment of the present invention,
The specific demand that data are deleted in modification is realized in the case where existing Append-Only database, meets the specific of user
Demand.As user needs a large amount of daily record datas of high speed storing, but need to be deleted or modified at any time again in using the data procedures
Certain data therein, using after the method can in the case where being changed without database meet demand.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is this hair
Bright some embodiments for those of ordinary skill in the art without creative efforts, can be with root
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is the flow chart that the method for data is deleted on a kind of Append-Only database of the embodiment of the present invention；
Fig. 2 is the flow chart that the method for data is modified on a kind of Append-Only database of the embodiment of the present invention；
Fig. 3 is the structural schematic diagram that the system of data is deleted on a kind of Append-Only database of the embodiment of the present invention；
Fig. 4 is the structural schematic diagram that the system of data is modified on a kind of Append-Only database of the embodiment of the present invention；
Fig. 5 illustrates the entity structure schematic diagram of a kind of electronic equipment.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without creative efforts, shall fall within the protection scope of the present invention.
Fig. 1 is the flow chart that the method for data is deleted on a kind of Append-Only database of the embodiment of the present invention, such as Fig. 1
It is shown, this method comprises:
S1 increases time field and identification field for each data that are inserted into, and is inserted into data for any, described any
Any time for being inserted into data and being written on Append-Only database described in time field identification with insertion data, institute
It states any identification field for being inserted into data and identifies any unique mark for being inserted into data on Append-Only database
Will code；
S2, obtains deletion record table, includes the time field and mark of all data to be deleted in the deletion record table
Field；
S3, according to the time field and identification field in the deletion record table, to the institute in Append-Only database
There are data to be deleted to be deleted.
Data are inserted into firstly for each, time field and identification field will be increased to each be inserted into data,
Data instance is inserted into one of them to be illustrated, time field indicate this be inserted into data be written in database when
Between, it can be accurate to a millisecond rank, identification field identifies this and is inserted into the unique designation code of data in the database, and identification field can
To uniquely determine the data in database.
Then deletion record table is obtained, the time field and mark of institute's deletion data in need are had recorded in the deletion record table
It becomes literate section, then further according to the time field and identification field in deletion record table, to being needed in Append-Only database
Data are deleted to be deleted.
The method and system of data are deleted and modified on a kind of Append-Only database provided in an embodiment of the present invention,
The specific demand that data are deleted in modification is realized in the case where existing Append-Only database, meets the specific of user
Demand.As user needs a large amount of daily record datas of high speed storing, but need to be deleted or modified at any time again in using the data procedures
Certain data therein, using after the method can in the case where being changed without database meet demand.
On the basis of the above embodiments, it is preferable that the time field and mark according in the deletion record table
Field is deleted all data to be deleted in Append-Only database, is specifically included:
According to the identification field in the deletion record table, all data to be deleted are determined；
According to the time field of the data to be deleted, the corresponding latest value of all data to be deleted is determined；
Delete the corresponding latest value of all data to be deleted in Append-Only database.
Specifically, according to the identification field in deletion record table, searched in the database, using the data found as
Data to be deleted, then further according to the time field of data to be deleted, it is known that the insertion time of the data, compares the time
It is known which item is the newest value of the data be, it is corresponding finally deletes all data to be deleted in Append-Only database
Latest value.
Fig. 2 is the flow chart that the method for data is modified on a kind of Append-Only database of the embodiment of the present invention, such as Fig. 2
It is shown, this method comprises:
S1 increases time field and identification field for each data that are inserted into, and is inserted into data for any, described any
Any time for being inserted into data and being written on Append-Only database described in time field identification with insertion data, institute
It states any identification field for being inserted into data and identifies any unique mark for being inserted into data on Append-Only database
Will code；
S2 reads data to be modified in Append-Only database；
S3 modifies to the data to be modified, and updates the time field of the data to be modified.
Similarly, when needing to modify to the data in database, increase in each be inserted into behind data
Two fields, respectively time field and identification field, are inserted into data instance with one of them and are illustrated, time field list
Show that this is inserted into the time that data are written in database, a millisecond rank can be accurate to, identification field identifies this and is inserted into data
Unique designation code in the database, identification field can uniquely determine the data in database.
Then data to be modified in Append-Only database are read, are modified to data to be modified, while will be to be repaired
The modification time for changing data carrys out the value of renewal time field, and the value of time field after update is re-write in database.
On the basis of the above embodiments, it is preferable that further include:
The data to be modified are added in view table, it is newest including the data to be modified in the view table
Value, the identification field of the data to be modified and the updated time field of the data to be modified.
In particular it is required that customization customer end, is actually the number for modifying needs when user modifies data by client
According to modifying after reading out, and take new time field and original identification field is inserted into view table.
The identification field for the data deleted will be needed to be inserted into deletion record table when user deletes data.In view table
Search two tables intersection determine which data be it is deleted, user will not show in inquiry and change data.
User's actual access is view table when inquiry, which determines according to identification field and time field
The latest value of certain data, someone finds newest data when user query.
Fig. 3 is the structural schematic diagram that the system of data is deleted on a kind of Append-Only database of the embodiment of the present invention, such as
Shown in Fig. 3, which includes: field module 301, logging modle 302 and removing module 303, in which:
Field module 301 is used to increase time field and identification field for each data that are inserted into, and is inserted into for any
Data, the either strap are inserted into any data that are inserted into described in the time field identification of data and are written to Append-Only data
Time on library, any identification field for being inserted into data identify any data that are inserted into Append-Only number
According to the unique designation code on library；
Logging modle 302 for obtaining deletion record table, in the deletion record table include all data to be deleted when
Between field and identification field；
Removing module 303 is used for according to the time field and identification field in the deletion record table, to Append-Only
All data to be deleted in database are deleted.
The specific implementation procedure of this system and the specific implementation procedure of above method embodiment are identical, and details please refer to above-mentioned
Embodiment of the method, details are not described herein for this system embodiment.
Fig. 4 is the structural schematic diagram that the system of data is modified on a kind of Append-Only database of the embodiment of the present invention, such as
Shown in Fig. 4, which includes mark module 401, read module 402 and modified module 402, in which:
Mark module 401 is used to increase time field and identification field for each data that are inserted into, and is inserted into for any
Data, the either strap are inserted into any data that are inserted into described in the time field identification of data and are written to Append-Only data
Time on library, any identification field for being inserted into data identify any data that are inserted into Append-Only number
According to the unique designation code on library；
Read module 402 is for reading data to be modified in Append-Only database；
Modified module 403 updates the time word of the data to be modified for modifying to the data to be modified
Section.
The specific implementation procedure of this system embodiment and the specific implementation procedure of above method embodiment are identical, and details please join
Above method embodiment is examined, details are not described herein for this system embodiment.
Fig. 5 illustrates the entity structure schematic diagram of a kind of electronic equipment, as shown in figure 5, the server may include: processing
Device (processor) 510, communication interface (Communications Interface) 520, memory (memory) 530 and total
Line 540, wherein processor 510, communication interface 520, memory 530 complete mutual communication by bus 540.Communication connects
Mouth 540 can be used for the transmission of the information between server and smart television.Processor 510 can call patrolling in memory 530
Instruction is collected, to execute following method:
Increase time field and identification field for each data that are inserted into, is inserted into data, the either strap for any
It is inserted into any time for being inserted into data and being written on Append-Only database described in the time field identification of data, it is described
Any identification field for being inserted into data identifies any unique designation for being inserted into data on Append-Only database
Code；
Deletion record table is obtained, includes the time field and identifier word of all data to be deleted in the deletion record table
Section；
According to the time field and identification field in the deletion record table, to all in Append-Only database
Data to be deleted are deleted.
In addition, the logical order in above-mentioned memory 530 can be realized by way of SFU software functional unit and conduct
Independent product when selling or using, can store in a computer readable storage medium.Based on this understanding, originally
Substantially the part of the part that contributes to existing technology or the technical solution can be in other words for the technical solution of invention
The form of software product embodies, which is stored in a storage medium, including some instructions to
So that a computer equipment (can be personal computer, server or the network equipment etc.) executes each implementation of the present invention
The all or part of the steps of example the method.And storage medium above-mentioned include: USB flash disk, mobile hard disk, read-only memory (ROM,
Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic or disk etc. it is various
It can store the medium of program code.
The present embodiment provides a kind of non-transient computer readable storage medium, the non-transient computer readable storage medium
Computer instruction is stored, the computer instruction makes the computer execute method provided by above-mentioned each method embodiment, example
Such as include:
Increase time field and identification field for each data that are inserted into, is inserted into data, the either strap for any
It is inserted into any time for being inserted into data and being written on Append-Only database described in the time field identification of data, it is described
Any identification field for being inserted into data identifies any unique designation for being inserted into data on Append-Only database
Code；
Deletion record table is obtained, includes the time field and identifier word of all data to be deleted in the deletion record table
Section；
According to the time field and identification field in the deletion record table, to all in Append-Only database
Data to be deleted are deleted.
Those of ordinary skill in the art will appreciate that: realize that all or part of the steps of above method embodiment can pass through
The relevant hardware of program instruction is completed, and program above-mentioned can be stored in a computer readable storage medium, the program
When being executed, step including the steps of the foregoing method embodiments is executed；And storage medium above-mentioned includes: ROM, RAM, magnetic disk or light
The various media that can store program code such as disk.
The apparatus embodiments described above are merely exemplary, wherein described, unit can as illustrated by the separation member
It is physically separated with being or may not be, component shown as a unit may or may not be physics list
Member, it can it is in one place, or may be distributed over multiple network units.It can be selected according to the actual needs
In some or all of the modules achieve the purpose of the solution of this embodiment.Those of ordinary skill in the art are not paying creativeness
Labour in the case where, it can understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
It realizes by means of software and necessary general hardware platform, naturally it is also possible to pass through hardware.Based on this understanding, on
Stating technical solution, substantially the part that contributes to existing technology can be embodied in the form of software products in other words, should
Computer software product may be stored in a computer readable storage medium, such as ROM/RAM, magnetic disk, CD, including several fingers
It enables and using so that a computer equipment (can be personal computer, server or the network equipment etc.) executes each implementation
Method described in certain parts of example or embodiment.
Finally, it should be noted that the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although
Present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: it still may be used
To modify the technical solutions described in the foregoing embodiments or equivalent replacement of some of the technical features；
And these are modified or replaceed, technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution spirit and
Range.
Claims (9)
1. deleting the method for data on a kind of Append-Only database characterized by comprising
Increase time field and identification field for each data that are inserted into, is inserted into data, the either strap insertion for any
Any time for being inserted into data and being written on Append-Only database, described any described in the time field identification of data
The identification field for being inserted into data identifies any unique designation code for being inserted into data on Append-Only database；
Deletion record table is obtained, includes the time field and identification field of all data to be deleted in the deletion record table；
According to the time field and identification field in the deletion record table, need to be deleted in Append-Only database
Except data are deleted.
2. method according to claim 1, which is characterized in that the time field and mark according in the deletion record table
Character learning section, deletes all data to be deleted in Append-Only database, specifically includes:
According to the identification field in the deletion record table, all data to be deleted are determined；
According to the time field of the data to be deleted, the corresponding latest value of all data to be deleted is determined；
Delete the corresponding latest value of all data to be deleted in Append-Only database.
3. method according to claim 2, which is characterized in that the identification field according in the deletion record table, really
Fixed all data to be deleted, specifically include:
Identification field in the deletion record table is searched in Append-Only database, the data found are made
For data to be deleted.
4. modifying the method for data on a kind of Append-Only database, which is characterized in that further include:
Increase time field and identification field for each data that are inserted into, is inserted into data, the either strap insertion for any
Any time for being inserted into data and being written on Append-Only database, described any described in the time field identification of data
The identification field for being inserted into data identifies any unique designation code for being inserted into data on Append-Only database；
Read data to be modified in Append-Only database；
It modifies to the data to be modified, and updates the time field of the data to be modified.
5. method according to claim 4, which is characterized in that further include:
The data to be modified are added in view table, latest value, institute in the view table including the data to be modified
State the identification field and the updated time field of the data to be modified of data to be modified.
6. deleting the system of data on a kind of Append-Only database characterized by comprising
Field module is inserted into data, institute for any for increasing time field and identification field for each data that are inserted into
State either strap insertion data time field identification described in it is any be inserted into data be written on Append-Only database when
Between, any identification field for being inserted into data identifies any data that are inserted on Append-Only database
Unique designation code；
Logging modle includes the time field of all data to be deleted for obtaining deletion record table, in the deletion record table
And identification field；
Removing module, for according to the time field and identification field in the deletion record table, to Append-Only database
In all data to be deleted deleted.
7. modifying the system of data on a kind of Append-Only database, which is characterized in that further include:
Mark module is inserted into data, institute for any for increasing time field and identification field for each data that are inserted into
State either strap insertion data time field identification described in it is any be inserted into data be written on Append-Only database when
Between, any identification field for being inserted into data identifies any data that are inserted on Append-Only database
Unique designation code；
Read module, for reading data to be modified in Append-Only database；
Modified module for modifying to the data to be modified, and updates the time field of the data to be modified.
8. a kind of electronic equipment characterized by comprising
At least one processor, at least one processor, communication interface and bus；Wherein,
The processor, memory, communication interface complete mutual communication by the bus；
The communication interface is for the information transmission between the test equipment and the communication equipment of display device；
The memory is stored with the program instruction that can be executed by the processor, and the processor calls described program to instruct energy
Enough execute method according to any one of claims 1 to 5.
9. a kind of non-transient computer readable storage medium, which is characterized in that the non-transient computer readable storage medium is deposited
Computer instruction is stored up, the computer instruction makes the computer execute method as claimed in claim 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811564243.2A CN109815213A (en) | 2018-12-20 | 2018-12-20 | It is deleted on a kind of Append-Only database and the method and system of modification data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811564243.2A CN109815213A (en) | 2018-12-20 | 2018-12-20 | It is deleted on a kind of Append-Only database and the method and system of modification data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109815213A true CN109815213A (en) | 2019-05-28 |
Family
ID=66601695
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811564243.2A Pending CN109815213A (en) | 2018-12-20 | 2018-12-20 | It is deleted on a kind of Append-Only database and the method and system of modification data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109815213A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111597149A (en) * | 2020-04-27 | 2020-08-28 | 五八有限公司 | Data cleaning method and device for database |
| CN111966867A (en) * | 2020-08-18 | 2020-11-20 | 北京金山云网络技术有限公司 | Object deleting method, data processing method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130311488A1 (en) * | 2012-01-06 | 2013-11-21 | Citus Data Bilgi Islemleri Ticaret A.S. | Time Stamp Bounded Addition of Data to an Append-Only Distributed Database Table |
| CN104657364A (en) * | 2013-11-18 | 2015-05-27 | 华为技术有限公司 | Log-structured database system query processing method and device |
| US20170097942A1 (en) * | 2015-10-01 | 2017-04-06 | Microsoft Technology Licensing, Llc. | Partitioning of geographic data |
| CN106570024A (en) * | 2015-10-10 | 2017-04-19 | 北京国双科技有限公司 | Data increment processing method and apparatus |
| US20170109392A1 (en) * | 2015-10-19 | 2017-04-20 | International Business Machines Corporation | Supporting updatable repeated values over variable schema |
| CN108228817A (en) * | 2017-12-29 | 2018-06-29 | 华为技术有限公司 | Data processing method, device and system |
-
2018
- 2018-12-20 CN CN201811564243.2A patent/CN109815213A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130311488A1 (en) * | 2012-01-06 | 2013-11-21 | Citus Data Bilgi Islemleri Ticaret A.S. | Time Stamp Bounded Addition of Data to an Append-Only Distributed Database Table |
| CN104657364A (en) * | 2013-11-18 | 2015-05-27 | 华为技术有限公司 | Log-structured database system query processing method and device |
| US20170097942A1 (en) * | 2015-10-01 | 2017-04-06 | Microsoft Technology Licensing, Llc. | Partitioning of geographic data |
| CN106570024A (en) * | 2015-10-10 | 2017-04-19 | 北京国双科技有限公司 | Data increment processing method and apparatus |
| US20170109392A1 (en) * | 2015-10-19 | 2017-04-20 | International Business Machines Corporation | Supporting updatable repeated values over variable schema |
| CN108228817A (en) * | 2017-12-29 | 2018-06-29 | 华为技术有限公司 | Data processing method, device and system |
Non-Patent Citations (4)
| Title |
|---|
| PHILIP HOWARD: "Append-only databases and the GDPR conundrum", 《HTTPS://WWW.BLOORRESEARCH.COM/2018/02/APPEND-DATABASES-GDPR-CONUNDRUM/?CN-RELOADED=1》 * |
| XUEJIANBEST: "hive表数据更新的一种解决方案（使用spark进行）", 《HTTPS://BLOG.CSDN.NET/XUEJIANBEST/ARTICLE/DETAILS/80449773》 * |
| 喝醉的清茶: "数据库 技术人都要了解的redis持久化", 《HTTPS://SEGMENTFAULT.COM/A/1190000015750985?UTM_SOURCE=TAG-NEWEST》 * |
| 王丽娜等: "一种通用数据库批量数据删除方法", 《福建电脑》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111597149A (en) * | 2020-04-27 | 2020-08-28 | 五八有限公司 | Data cleaning method and device for database |
| CN111597149B (en) * | 2020-04-27 | 2023-03-31 | 五八有限公司 | Data cleaning method and device for database |
| CN111966867A (en) * | 2020-08-18 | 2020-11-20 | 北京金山云网络技术有限公司 | Object deleting method, data processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105630863B (en) | Transaction control block for multi-version concurrent commit status | |
| US11709821B2 (en) | Tracking change data in a database | |
| US9805074B2 (en) | Compressed representation of a transaction token | |
| CN109977274B (en) | Data query and verification method, system, equipment and storage medium | |
| US8484108B2 (en) | Tracking entities during identity resolution | |
| US20200364185A1 (en) | Method for data replication in a data analysis system | |
| CN104040481A (en) | Method Of And System For Merging, Storing And Retrieving Incremental Backup Data | |
| CN107908503A (en) | Recover database from standby system streaming | |
| CN111259004B (en) | Method for indexing data in storage engine and related device | |
| EP2380090B1 (en) | Data integrity in a database environment through background synchronization | |
| CN104021145A (en) | Mixed service concurrent access method and device | |
| CN104572920A (en) | Data arrangement method and data arrangement device | |
| US10216739B2 (en) | Row-based archiving in database accelerators | |
| US9390111B2 (en) | Database insert with deferred materialization | |
| US20210286804A1 (en) | Targeted sweep method for key-value data storage | |
| US7653663B1 (en) | Guaranteeing the authenticity of the data stored in the archive storage | |
| CN109815213A (en) | It is deleted on a kind of Append-Only database and the method and system of modification data | |
| CN106959989A (en) | The synchronous method and device in master/slave data storehouse | |
| US10409799B2 (en) | Supporting updatable repeated values over variable schema | |
| Kvet et al. | Relational pre-indexing layer supervised by the DB_index_consolidator Background Process | |
| WO2007049289A2 (en) | Method and system for re-population of data in a database | |
| CN115905259B (en) | Pure column type updating method and device supporting row-level concurrency control | |
| CN111753141A (en) | Data management method and related equipment | |
| CN112069192A (en) | Multi-master with ownership transfer | |
| CN115878655A (en) | Data operation method and device, computer equipment and storage medium |
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 |
Application publication date: 20190528 |
|
| RJ01 | Rejection of invention patent application after publication |