Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for deleting data in bulk

A technology for deleting data and databases, which is applied in electronic digital data processing, special data processing applications, instruments, etc., can solve the problems of long deletion time and low deletion efficiency, and achieve the effect of high deletion efficiency

Inactive Publication Date: 2009-07-29
ZTE CORP
View PDF0 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The purpose of the present invention is to provide a method for deleting data in large batches in an ORACLE database, which effectively solves the problems of low deletion efficiency and long deletion time in the prior art, and can realize disk defragmentation and high water mark in the deletion process compression

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
  • Method for deleting data in bulk
  • Method for deleting data in bulk

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In order to better understand the present invention, the present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0026] see figure 1 , the process flow of the data deletion method of the present invention includes the following steps:

[0027] 100. Data deletion preparation: make statistics on the total number of records in the current deletion table and the number of records to be deleted, so as to clarify the data volume of the current deletion task;

[0028] 102. Judgment on whether this method is applicable: In the following two cases, the deletion efficiency of the method of the present invention is not high, and other deletion methods in the 104 process should be used;

[0029] 104. If you want to delete all the data, you can directly use the truncate statement, which is more efficient; if you want to delete a small amount of data, you can directly use the delete statement;

[0030] 106. Analyze...

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 method for data deletion in batch in an ORACLE database, which has the following steps: A. a where condition for retention data is analyzed according to deletion conditions; B. an exp command is used for exporting retention data meeting the where condition in a compression way; C. the original table is cleared; and D. the retention data is exported back to the database. In step C, the original table is cleared in the way of a drop original table and a truncate original table, compression of high water line and recovery of database table space can be realized. The method deletes data in batch under the conditions of batch data, has high deletion efficiency, performs disk efragmentation in the data table, and completes the compression operation of the high water line in the process of data deletion in one step without any additional database operations.

Description

technical field [0001] The invention belongs to the field of database data deletion, and in particular relates to a method for deleting data in large batches in an oracle database under the condition of a large amount of data. Background technique [0002] In the communication field, performance management and alarm management are two important functions of the telecom network management system, and they are also two functions that generate a large amount of data in the network management system. After the network management has been running for a period of time (such as two years), the on-site network management needs to upgrade the version. The upgrade of the network management database is the most time-consuming and important part of the network management version upgrade process. A large number of historical alarm data in the network management database And performance statistics will greatly increase the time for database upgrades and occupy a lot of disk space. However...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 徐春生詹荣国
Owner ZTE CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com