Search International and National Patent Collections

1. (WO2018127116) DATA CLEANING METHOD AND APPARATUS, AND COMPUTER-READABLE STORAGE MEDIUM

Pub. No.:    WO/2018/127116    International Application No.:    PCT/CN2018/071506
Publication Date: Fri Jul 13 01:59:59 CEST 2018 International Filing Date: Sat Jan 06 00:59:59 CET 2018
IPC: G06F 17/30
Applicants: TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED
腾讯科技(深圳)有限公司
Inventors: LI, Yuesen
李跃森
Title: DATA CLEANING METHOD AND APPARATUS, AND COMPUTER-READABLE STORAGE MEDIUM
Abstract:
A data cleaning method and apparatus, belonging to the technical field of database application. The method comprises: adding a share update exclusive lock to a target table, and stopping a system from carrying out a DDL operation on the target table (S302); then, establishing a temporary table (S303) and establishing a temporary index (S304); copying data in the target table to the temporary table, and generating index information according to data in the temporary table (S305); then, adding an access exclusive lock to a target table to stop the system from carrying out a DML operation on the target table (S306); and then exchanging data in the target table and the temporary table and corresponding index information (S307), so as to complete the cleaning and recovery of a disk space.