Management method and device for storage space in database

A storage space and management method technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem of low operation efficiency of adding, deleting, modifying and querying, so as to reduce the occupation ratio, optimize the storage space, and improve the response speed Effect

Inactive Publication Date: 2017-11-03
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Then after a large amount of fragmented space is generated, the efficiency of adding, deleting, modifying and querying this table will become lower

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
  • Management method and device for storage space in database
  • Management method and device for storage space in database
  • Management method and device for storage space in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0034] The steps shown in the flowcharts of the figures may be performed in a computer system, such as a set of computer-executable instructions. Also, although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0035] figure 1 It is a flow chart of the method for managing the storage space in the database provided by the present invention. figure 1 The methods shown include:

[0036] Step 101, after deleting entries in the data table in the database, record th...

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 management method and device for storage space in a database. The method includes the steps of after deleting table items in a data table in the database, recording data block information corresponding to fragment data in the storage space, wherein the fragment data is generated by the data table after each-time deleting operation; calculating the sum of data blocks occupied by fragments of the data table in the storage space; according to the sum of the data blocks occupied by the fragments, judging whether or not the storage space is released; if yes, releasing the data blocks occupied by the fragments of the data table in the storage space.

Description

technical field [0001] The invention relates to the field of database management, in particular to a method and device for managing storage space in a database. Background technique [0002] The most important part of a database is the data table. According to the database management content, there can be multiple data tables, and different data tables can be used in association. There can be keywords, primary keys, indexes, etc. in the database to maintain and manage the content. [0003] When there are many delete operations on a table, the space occupied by the table and its related indexes will be discontinuous, resulting in a large amount of fragmented space. Then, after a large amount of fragmented space is generated, the efficiency of adding, deleting, modifying and querying this table will become lower. Contents of the invention [0004] In order to solve the above technical problems, the present invention provides a method and device for managing storage space ...

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
IPC IPC(8): G06F17/30
CPCG06F16/217G06F16/2282
Inventor 高宁
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
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