Data deletion method and device of distributed database and electronic equipment
A deletion method and database technology, applied in the field of distributed databases, can solve problems such as difficulty in ensuring data deletion efficiency, and achieve the effect of improving efficiency and accuracy
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0032] When the storage capacity of the distributed database is insufficient, the user will choose to delete the specified number of rows to improve the performance of the database. However, since the data in the same table is usually stored in different data nodes, and different deletion methods are used to delete data, the time consumption is usually different. Therefore, the corresponding deletion method needs to be selected according to the actual request.
[0033] In order to quickly delete data of a specified number of rows from a distributed database, an embodiment of the present application provides a method for deleting data from a distributed database.
[0034] In the data deletion method, if the first data deletion statement is detected, then according to the unique identifier of the target table included in the first data deletion statement, it is determined which data node in the distributed database stores the data of the target table, and stores the data of the t...
Embodiment 2
[0146] Corresponding to the data deletion method of the above-mentioned distributed database in the above embodiment, Figure 4 A structural block diagram of a data deletion apparatus for a distributed database provided by an embodiment of the present application is shown. For convenience of description, only the part related to the embodiment of the present application is shown.
[0147] refer to Figure 4 , the data deletion device 4 of the distributed database includes: a first data deletion statement receiving module 41 , a first target row number determination module 42 , a target deletion method determination module 43 , and a data deletion module 44 . in:
[0148] The first data deletion statement receiving module 41 is configured to receive a first data deletion statement, where the first data deletion statement includes the unique identifier of the target table and the total number of rows to be deleted corresponding to the target table. The data nodes all store the...
Embodiment 3
[0182] Figure 5 This is a schematic structural diagram of an electronic device according to an embodiment of the present application. like Figure 5 As shown, the electronic device 5 in this embodiment includes: at least one processor 50 ( Figure 5 (only one processor is shown in the figure), a memory 51 and a computer program 52 stored in the memory 51 and executable on the at least one processor 50, the processor 50 executing the computer program 52 to achieve the above Steps in any of the various method embodiments.
[0183] The electronic device 5 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The electronic device may include, but is not limited to, the processor 50 and the memory 51 . Those skilled in the art can understand that, Figure 5 It is only an example of the electronic device 5, and does not constitute a limitation on the electronic device 5. It may include more or less components than the one sh...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More