Database storage space optimization method and device, electronic equipment and storage medium

A storage space and optimization method technology, applied in the financial field, can solve problems such as slow business response and inefficient data scanning, and achieve the effects of alleviating storage pressure, improving effect and speed, and improving performance

Pending Publication Date: 2021-10-22
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the inventive concept of the present disclosure, the inventors found that there are at least the foll

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
  • Database storage space optimization method and device, electronic equipment and storage medium
  • Database storage space optimization method and device, electronic equipment and storage medium
  • Database storage space optimization method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0052] Hereinafter, embodiments of the present disclosure will be described with reference to the drawings. It should be understood, however, that these descriptions are exemplary only, and are not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Also, in the following description, descriptions of well-known structures and techniques are omitted to avoid unnecessarily obscuring the concept of the present disclosure.

[0053] The terminology used herein is for the purpose of describing particular embodiments only, and is not intended to be limiting of the present disclosure. The terms "comprising", "comprising", etc. used herein indicate the presence of features, steps, ...

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 provides a database storage space optimization method which can be applied to the field of finance and the technical field of computers. The database storage space optimization method comprises: obtaining storage information of a table space in a database, wherein the storage information comprises fragmented space information of the table space; determining a first fragmentation rate of the database according to the fragmented space information of each table space; generating a database sequence in N databases according to the size sequence of the first fragment rate of each database, wherein N is larger than or equal to 1; determining m target databases from N databases according to the database sequence, wherein N >= M >= 1; and performing spatial optimization processing on each target database to generate a spatial optimization report. The invention further provides a database storage space optimization device, equipment, a storage medium and a program product.

Description

technical field [0001] The present disclosure relates to the fields of finance and computer technology, and in particular to a database storage space optimization method, device, device, medium and program product. Background technique [0002] A database is a computer software system that stores and manages data according to its data structure. The production system runs for a long time and accumulates a large amount of historical data. At the same time, due to the frequent insertion, deletion and update of active data, a large amount of fragmented space is generated in the database. [0003] In the process of implementing the disclosed inventive concept, the inventors have found at least the following problems in related technologies: the existence of fragmented space will result in inefficient data scanning and slow business response. Contents of the invention [0004] In view of the above problems, the present disclosure provides a database storage space optimization ...

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): G06F16/22G06F16/2453
CPCG06F16/2282G06F16/2453G06F12/0253
Inventor 张明永吴晓晔吴辉张广蓉
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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