Method for Oracle regularly deleting stale data in database

A database and data technology, applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as slow deletion

Inactive Publication Date: 2009-10-14
北京闻言科技有限公司
View PDF0 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

A bad data deletion strategy will slow down the deletion and form a large amount of disk fragmentation

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0009] Main steps of the present invention are as follows:

[0010] Step 1: When setting up the database, merge the content with similar content and the same format into one table. The database partition technology is used in the table to divide the table into different partitions and sub-partitions according to the storage time and content category, so that the table can be divided according to the partition The settings to flexibly delete expired data.

[0011] Step 2: Set up stored procedures and functions in the database, and define methods and rules for deleting expired files. Content data is divided into data with strong timeliness and average timeliness. For data with strong timeliness, the database strategy is to keep it for one to two months. Timeliness The general content retention time is two to three months. There are also some data with poor timeliness, which are permanently retained.

[0012] Step 3: Store procedures and scheduled tasks in the database, execut...

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 relates to a method for Oracle regularly deleting stale data in a database. Firstly, database contents are respectively placed on different areas according to classification; then, a storing process and a function in the database are set, and a method and a rule for deleting a stale file are defined; and finally, a timed task (can be carried out on an operation system) in the database is set, and executing operation comprises the steps of adding the areas which can contain new data and deleting subareas of the stale data, if all subareas of the areas are deleted, parent areas are deleted. The invention can rapidly delete the stale data in the high-volume database under the conditions that the database performance is not reduced, and the operation is incessant.

Description

technical field [0001] The invention relates to a method for Oracle to periodically eliminate outdated data in a database. In particular, it relates to a method for quickly clearing outdated data in a massive database under the condition that the performance of the database is not degraded and the operation is not interrupted. Background technique [0002] The database is an important part of the application system of massive data. As time goes by, when the amount of data stored in the database reaches a certain level, the usage of disk space will increase, and the performance of the database will decline rapidly. A bad data deletion strategy will slow down the deletion and form a large amount of disk fragmentation. In a TB-level database system, a data strategy for fast and safe deletion is a must. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a method for quickly deleting expired data in a database. [000...

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 北京闻言科技有限公司
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