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
- appendix
- field
- deleted
- 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 45
- 238000012986 modification Methods 0.000 title claims abstract description 9
- 230000004048 modification Effects 0.000 title claims abstract description 9
- 238000012217 deletion Methods 0.000 claims abstract description 33
- 230000037430 deletion Effects 0.000 claims abstract description 33
- 238000004891 communication Methods 0.000 claims description 14
- 238000003780 insertion Methods 0.000 claims description 7
- 230000037431 insertion Effects 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000012360 testing method Methods 0.000 claims description 2
- 241001269238 Data Species 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 6
- 230000003287 optical effect Effects 0.000 description 3
- 238000013459 approach Methods 0.000 description 1
- 230000006835 compression Effects 0.000 description 1
- 238000007906 compression Methods 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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 embodiment of the invention relates to the technical field of databases, in particular to a method and a system for deleting and modifying data on an appendix-Only database.
Background
appendix-Only is a storage representation that Only allows new rows to be added to a table, but does not allow existing rows to be updated or deleted. This allows for more compact storage on disk, since each row does not need to store the MVCC, which means that each transaction sees a snapshot of the data when querying the database, which can protect the transaction from looking at inconsistent data that may be caused by other concurrent updates on the same data row. This provides transaction isolation for each database session.
MVCC minimizes lock contention by avoiding the explicit locking approach of traditional database systems in order to achieve reasonable performance in a multi-user environment.
The main advantage of using an MVCC concurrency control model instead of locking is that the query data, read data, and locks acquired for writing data do not conflict in the acquired MVCC lock, so a read never blocks a write, and a write never blocks a read. The characteristic enables the appendix-Only to be very suitable for batch data writing, the high compression ratio and the logic backup support incremental backup, and therefore, the offset of the backup can be recorded each time. The full amount of BITMP delete markers are added for each backup.
The main characteristic of the appendix-Only database is to improve the performance of writing and querying mass data, and the application scene is mainly directed at the scene needing to read mass data at high speed.
However, in the actual production environment, some special situations are often encountered, and data needs to be modified or deleted directly in the database, so a method for modifying or deleting data on the appendix-Only database is needed.
Disclosure of Invention
In view of the above problems, embodiments of the present invention provide a method and a system for deleting and modifying data on an application-Only database.
In a first aspect, an embodiment of the present invention provides a method for deleting data in an application-Only database, including:
adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the insertion data identifies the time when the any data to be inserted is written into the appendix-Only database, and the identification field of the any data to be inserted identifies the unique mark code of the any data to be inserted on the appendix-Only database;
acquiring a deletion record table, wherein the deletion record table comprises time fields and identification fields of all data to be deleted;
and deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deletion record table.
In a second aspect, an embodiment of the present invention provides a method for modifying data on an appendix-Only database, including:
adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the insertion data identifies the time when the any data to be inserted is written into the appendix-Only database, and the identification field of the any data to be inserted identifies the unique mark code of the any data to be inserted on the appendix-Only database;
reading data to be modified in an appendix-Only database;
and modifying the data to be modified, and updating the time field of the data to be modified.
In a third aspect, an embodiment of the present invention provides a system for deleting data in an application-Only database, including:
the field module is used for adding a time field and an identification field for each data to be inserted, for any data to be inserted, the time field with the data to be inserted identifies the time when the data to be inserted is written into the appendix-Only database, and the identification field of the data to be inserted identifies the unique mark code of the data to be inserted on the appendix-Only database;
the recording module is used for acquiring a deleted recording table, and the deleted recording table comprises time fields and identification fields of all data to be deleted;
and the deleting module is used for deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deleting record table.
In a fourth aspect, an embodiment of the present invention provides a system for modifying data on an appendix-Only database, including:
the field module is used for adding a time field and an identification field for each data to be inserted, for any data to be inserted, the time field with the data to be inserted identifies the time when the data to be inserted is written into the appendix-Only database, and the identification field of the data to be inserted identifies the unique mark code of the data to be inserted on the appendix-Only database;
the reading module is used for reading data to be modified in the appendix-Only database;
and the modification module is used for modifying the data to be modified and updating the time field of the data to be modified.
In a fifth aspect, an embodiment of the present invention provides an electronic device, including:
at least one processor, at least one memory, a communication interface, and a bus; wherein,
the processor, the memory and the communication interface complete mutual communication through the bus;
the communication interface is used for information transmission between the test equipment and the communication equipment of the display device;
the memory stores program instructions executable by the processor, and the processor calls the program instructions to execute a method for deleting and modifying data on an Append-Only database provided by the first aspect and the second aspect.
In a sixth aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium, where the non-transitory computer-readable storage medium stores computer instructions that cause the computer to execute a method for deleting and modifying data on an application-Only database provided in the first and second aspects.
The method and the system for deleting and modifying data on the appendix-Only database provided by the embodiment of the invention realize the special requirement of modifying and deleting data under the condition of the existing appendix-Only database, and meet the specific requirement of a user. If a user needs to store a large amount of log data at a high speed, but needs to delete or modify some data at any time in the process of using the data, the method can meet the requirement without replacing the database.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a flowchart of a method for deleting data from an Append-Only database according to an embodiment of the present invention;
FIG. 2 is a flowchart of a method for modifying data in an Append-Only database according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a system for deleting data in an Append-Only database according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a system for modifying data in an Append-Only database according to an embodiment of the present invention;
fig. 5 illustrates a physical structure diagram of an electronic device.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a flowchart of a method for deleting data in an application-Only database according to an embodiment of the present invention, and as shown in fig. 1, the method includes:
s1, adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the data to be inserted identifies the time when the data to be inserted is written into the appendix-Only database, and the identification field of the data to be inserted identifies the unique mark code of the data to be inserted on the appendix-Only database;
s2, acquiring a deletion record table, wherein the deletion record table comprises time fields and identification fields of all data to be deleted;
and S3, deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deletion record table.
Firstly, for each data to be inserted, a time field and an identification field are added to each data to be inserted, and the example of one of the data to be inserted is taken as an example for explanation, wherein the time field represents the time for writing the data to be inserted into the database and can be accurate to millisecond level, the identification field identifies the unique mark code of the data to be inserted in the database, and the identification field can uniquely determine the data in the database.
And then acquiring a deletion record table, wherein all time fields and identification fields of data to be deleted are recorded in the deletion record table, and then deleting all data to be deleted in the appendix-Only database according to the time fields and the identification fields in the deletion record table.
The method and the system for deleting and modifying data on the appendix-Only database provided by the embodiment of the invention realize the special requirement of modifying and deleting data under the condition of the existing appendix-Only database, and meet the specific requirement of a user. If a user needs to store a large amount of log data at a high speed, but needs to delete or modify some data at any time in the process of using the data, the method can meet the requirement without replacing the database.
On the basis of the foregoing embodiment, preferably, the deleting, according to the time field and the identification field in the deletion record table, all data to be deleted in the application-Only database includes:
determining all data to be deleted according to the identification fields in the deletion record table;
determining the latest value corresponding to all the data to be deleted according to the time field of the data to be deleted;
and deleting the latest values corresponding to all data to be deleted in the appendix-Only database.
Specifically, according to the identification field in the deletion record table, searching is carried out in the database, the found data is used as the data to be deleted, then according to the time field of the data to be deleted, the insertion time of the data can be known, the latest value of the data can be known by comparing the time, and finally the latest value corresponding to all the data to be deleted in the appendix-Only database is deleted.
Fig. 2 is a flowchart of a method for modifying data on an application-Only database according to an embodiment of the present invention, and as shown in fig. 2, the method includes:
s1, adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the data to be inserted identifies the time when the data to be inserted is written into the appendix-Only database, and the identification field of the data to be inserted identifies the unique mark code of the data to be inserted on the appendix-Only database;
s2, reading data to be modified in the appendix-Only database;
s3, modifying the data to be modified, and updating the time field of the data to be modified.
Similarly, when data in the database needs to be modified, two fields, namely a time field and an identification field, are added behind each piece of data to be inserted, and one of the fields is taken as an example for explanation, the time field represents the time for writing the data to be inserted into the database and can be accurate to a millisecond level, the identification field identifies a unique mark code of the data to be inserted in the database, and the identification field can uniquely determine the data in the database.
And then reading the data to be modified in the Append-Only database, modifying the data to be modified, updating the value of the time field by the modification time of the data to be modified, and rewriting the value of the time field after the modification into the database.
On the basis of the above embodiment, it is preferable to further include:
and adding the data to be modified into a view chart, wherein the view chart comprises the latest value of the data to be modified, an identification field of the data to be modified and a time field after the data to be modified is updated.
Specifically, a client needs to be customized, and when a user modifies data through the client, the data to be modified is actually read and then modified, and the data is inserted into the view table with a new time field and an original identification field.
When the user deletes the data, the identification field of the data needing to be deleted is inserted into the deletion record table. Looking up the intersection of the two tables in the view table determines which data is deleted and the user will not display the data when querying.
The view table is actually accessed by the user when inquiring, the latest value of a certain piece of data is determined according to the identification field and the time field, and a person finds the latest data when the user inquires.
Fig. 3 is a schematic structural diagram of a system for deleting data in an application-Only database according to an embodiment of the present invention, and as shown in fig. 3, the system includes: a field module 301, a recording module 302, and a deletion module 303, wherein:
the field module 301 is configured to add a time field and an identification field for each piece of data to be inserted, where, for any piece of data to be inserted, the time field with the piece of data to be inserted identifies the time when the any piece of data to be inserted is written into the application-Only database, and the identification field with the piece of data to be inserted identifies a unique identifier of the any piece of data to be inserted on the application-Only database;
the recording module 302 is configured to obtain a deletion record table, where the deletion record table includes time fields and identification fields of all data to be deleted;
the deleting module 303 is configured to delete all data to be deleted in the appendix-Only database according to the time field and the identification field in the deletion record table.
The specific implementation process of the system is the same as that of the above method embodiment, and please refer to the above method embodiment for details, which is not described herein again.
Fig. 4 is a schematic structural diagram of a system for modifying data on an appendix-Only database according to an embodiment of the present invention, as shown in fig. 4, the system includes an identification module 401, a reading module 402, and a modification module 402, where:
the identification module 401 is configured to add a time field and an identification field for each piece of data to be inserted, where, for any piece of data to be inserted, the time field with the piece of data to be inserted identifies the time when the any piece of data to be inserted is written into the application-Only database, and the identification field with the piece of data to be inserted identifies a unique identifier of the any piece of data to be inserted on the application-Only database;
the reading module 402 is used for reading data to be modified in the appendix-Only database;
the modifying module 403 is configured to modify the data to be modified, and update a time field of the data to be modified.
The specific execution process of the embodiment of the system is the same as that of the embodiment of the method described above, and please refer to the embodiment of the method for details, which is not described herein again.
Fig. 5 illustrates a physical structure diagram of an electronic device, and as shown in fig. 5, the server may include: a processor (processor)510, a communication Interface (Communications Interface)520, a memory (memory)530, and a bus 540, wherein the processor 510, the communication Interface 520, and the memory 530 communicate with each other via the bus 540. The communication interface 540 may be used for information transmission between the server and the smart tv. Processor 510 may call logic instructions in memory 530 to perform the following method:
adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the insertion data identifies the time when the any data to be inserted is written into the appendix-Only database, and the identification field of the any data to be inserted identifies the unique mark code of the any data to be inserted on the appendix-Only database;
acquiring a deletion record table, wherein the deletion record table comprises time fields and identification fields of all data to be deleted;
and deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deletion record table.
Furthermore, the logic instructions in the memory 530 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The present embodiments provide a non-transitory computer-readable storage medium storing computer instructions that cause the computer to perform the methods provided by the above method embodiments, for example, including:
adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the insertion data identifies the time when the any data to be inserted is written into the appendix-Only database, and the identification field of the any data to be inserted identifies the unique mark code of the any data to be inserted on the appendix-Only database;
acquiring a deletion record table, wherein the deletion record table comprises time fields and identification fields of all data to be deleted;
and deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deletion record table.
Those of ordinary skill in the art will understand that: all or part of the steps for implementing the method embodiments may be implemented by hardware related to program instructions, and the program may be stored in a computer readable storage medium, and when executed, the program performs the steps including the method embodiments; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (9)
1. A method for deleting data on an appendix-Only database is characterized by comprising the following steps:
adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the insertion data identifies the time when the any data to be inserted is written into the appendix-Only database, and the identification field of the any data to be inserted identifies the unique mark code of the any data to be inserted on the appendix-Only database;
acquiring a deletion record table, wherein the deletion record table comprises time fields and identification fields of all data to be deleted;
and deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deletion record table.
2. The method according to claim 1, wherein deleting all data to be deleted in the application-Only database according to the time field and the identification field in the deletion record table specifically comprises:
determining all data to be deleted according to the identification fields in the deletion record table;
determining the latest value corresponding to all the data to be deleted according to the time field of the data to be deleted;
and deleting the latest values corresponding to all data to be deleted in the appendix-Only database.
3. The method according to claim 2, wherein the determining all data to be deleted according to the identification field in the deletion record table specifically includes:
and searching the identification field in the deletion record table in an appendix-Only database, and taking the found data as the data to be deleted.
4. A method for modifying data on an appendix-Only database is characterized by further comprising the following steps:
adding a time field and an identification field for each data to be inserted, wherein for any data to be inserted, the time field with the insertion data identifies the time when the any data to be inserted is written into the appendix-Only database, and the identification field of the any data to be inserted identifies the unique mark code of the any data to be inserted on the appendix-Only database;
reading data to be modified in an appendix-Only database;
and modifying the data to be modified, and updating the time field of the data to be modified.
5. The method of claim 4, further comprising:
and adding the data to be modified into a view chart, wherein the view chart comprises the latest value of the data to be modified, an identification field of the data to be modified and a time field after the data to be modified is updated.
6. A system for deleting data from an appendix-Only database, comprising:
the field module is used for adding a time field and an identification field for each data to be inserted, for any data to be inserted, the time field with the data to be inserted identifies the time when the data to be inserted is written into the appendix-Only database, and the identification field of the data to be inserted identifies the unique mark code of the data to be inserted on the appendix-Only database;
the recording module is used for acquiring a deleted recording table, and the deleted recording table comprises time fields and identification fields of all data to be deleted;
and the deleting module is used for deleting all data to be deleted in the appendix-Only database according to the time field and the identification field in the deleting record table.
7. A system for modifying data on an appendix-Only database, characterized by further comprising:
the identification module is used for adding a time field and an identification field for each data to be inserted, for any data to be inserted, the time field with the data to be inserted identifies the time when the data to be inserted is written into the appendix-Only database, and the identification field of the data to be inserted identifies the unique mark code of the data to be inserted on the appendix-Only database;
the reading module is used for reading data to be modified in the appendix-Only database;
and the modification module is used for modifying the data to be modified and updating the time field of the data to be modified.
8. An electronic device, comprising:
at least one processor, at least one memory, a communication interface, and a bus; wherein,
the processor, the memory and the communication interface complete mutual communication through the bus;
the communication interface is used for information transmission between the test equipment and the communication equipment of the display device;
the memory stores program instructions executable by the processor, the processor invoking the program instructions to perform the method of any one of claims 1-5.
9. A non-transitory computer-readable storage medium storing computer instructions that cause a computer to perform the method of any one of claims 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 (3)
| 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 |
| CN112632024A (en) * | 2019-10-08 | 2021-04-09 | 中兴通讯股份有限公司 | Method and electronic equipment for managing data of telecommunication network |
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 (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112632024A (en) * | 2019-10-08 | 2021-04-09 | 中兴通讯股份有限公司 | Method and electronic equipment for managing data of telecommunication network |
| 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 |
|---|---|---|
| US11550769B2 (en) | Data processing method, apparatus, and system | |
| US8924365B2 (en) | System and method for range search over distributive storage systems | |
| CN109508355B (en) | A data extraction method, system and terminal device | |
| CN107818115B (en) | Method and device for processing data table | |
| CN112084161B (en) | Database-based data processing method and device and readable storage medium | |
| US8589357B2 (en) | Techniques for automatically tracking and archiving transactional data changes | |
| US20160314161A1 (en) | Multi-Version Concurrency Control Method in Database and Database System | |
| CN110908997A (en) | Data blood margin construction method and device, server and readable storage medium | |
| US20140149368A1 (en) | Compressed Representation of a Transaction Token | |
| EP2380090B1 (en) | Data integrity in a database environment through background synchronization | |
| US9384202B1 (en) | Gateway module to access different types of databases | |
| CN107977396B (en) | A kind of updating method and table data updating device of data table of KeyValue database | |
| CN111414403A (en) | Data access method and device and data storage method and device | |
| CN112434015B (en) | Data storage method and device, electronic equipment and medium | |
| CN111753141B (en) | A data management method and related equipment | |
| CN107665255B (en) | Method, device, equipment and storage medium for key value database data change | |
| US20060224626A1 (en) | Versioned file group repository | |
| CN110209534B (en) | System and method for automatically backing up mysql database | |
| CN109815213A (en) | It is deleted on a kind of Append-Only database and the method and system of modification data | |
| CN112269802A (en) | A method and system for frequent deletion, modification and search optimization based on Clickhouse | |
| US9990378B2 (en) | Opportunistic clearing of sync states associated with a database | |
| CN113553335A (en) | Data updating method and device for columnar storage file | |
| CN113656380B (en) | Data lifecycle management method and device | |
| CN115129717A (en) | Data writing method, device and computer readable medium for realizing automatic partition | |
| CN111694853B (en) | Data increment collection method and device based on lineage, storage medium and electronic equipment |
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 |