Data processing method and device

A data processing and data row technology, applied in the database field, can solve problems such as performance degradation, affecting database availability, and increasing database I/O, so as to achieve the effect of improving availability

Active Publication Date: 2018-09-04
XIAOMI INC
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During the long period of deleting data, the I / O of the database will increase and the performance will decrease, thus affecting the availability of the database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data processing method and device
  • Data processing method and device
  • Data processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present disclosure as recited in the appended claims.

[0056] See figure 1 As shown, it is a flow chart of a data processing method shown according to an exemplary embodiment, including the following steps.

[0057] In step 101, the data row to be processed is determined in the data table.

[0058] In step 102, the data rows to be processed are exported in n batches.

[0059] In step 103, the data rows exported in each batch are deleted...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a data processing method and device and belongs to the field of databases. The method comprises: determining a to-be-processed data line in a data table; educing the to-be-processed data line in n batches; deleting the data line which is educed in each batch from the data table; or, deleting the data line from the data table after the data line is archived to another data table. According to the data processing method and device disclosed by the invention, the educed data line is deleted by virtue of multi-batch data educing operation and less data educing operation of each batch, so that the problem in the correlated technology that the usability of the database is affected by relatively long data deleting time is solved; and when the large-scale data is deleted or archived, the data table is not locked on a large scale, the pressure on the data table in unit time is relatively small and the performance of the data table is not affected, so that the effect of the usability of the data table is improved.

Description

technical field [0001] The disclosure relates to the field of databases, in particular to a data processing method and device. Background technique [0002] In the process of using the database, we often encounter working scenarios that need to delete specified data from a large-capacity data table. The specified data can be data that is no longer needed or that needs to be archived to other data tables. [0003] In the data processing methods provided by related technologies, relevant data needs to be locked when data is deleted, but since there are generally many data to be deleted, for example, to delete 100,000 rows of data, 100,000 rows of data need to be locked. During a long period of data deletion, the I / O of the database will increase and the performance will decrease, thereby affecting the availability of the database. Contents of the invention [0004] In order to overcome the problems existing in related technologies, the present disclosure provides a data pr...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/21
Inventor 窦锦帅谭国斌沈建荣马哲
Owner XIAOMI INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap