Method and system for releasing database space

A database and space technology, applied in the field of database processing, can solve problems such as the inability to release storage space, and achieve the effect of ensuring long-term normal operation and not being limited by storage space

Inactive Publication Date: 2017-05-31
桂林远望智能通信科技有限公司
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to provide a method and system for releasing database space, which can automatically delete the previous database according to the set time requirements, and solve the problem that the original storage space cannot be released, thereby ensuring the long-term normal operation of the system

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 and system for releasing database space
  • Method and system for releasing database space
  • Method and system for releasing database space

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0047] The addition and deletion of the database play a key role in the application system, especially a vehicle bayonet application system, which is used to record passing pictures and store tens of thousands of passing pictures every day. Currently, the mongoDB block file storage mechanism is used. The mongoDB block file storage mechanism is: in order to avoid excessive disk fragments during data storage, the mongoDB database adopts the block storage mechanism, that is, apply for a file block in the hard disk in advance for storing data (the default size is 2G, such as adding in the startup parameters -smallfile is about 500M), as the amount of stored data increases, the original data file block is used up and then...

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 and a system for releasing a database space. The method comprises the following steps: receiving data to be stored, and recording receiving time of the data to be stored; according to a set creation rule and the recorded receiving time, determining whether to create a new database; setting tags for created databases according to a preset time format; establishing a database list, and sorting the databases according to time information in the tags; deleting the first n databases according to a predetermined database deletion parameter. According to the method and the system for releasing the database space, the data receiving time is adopted to automatically judge whether to create the new database, the first several databases can be self-deleted according to the set database deletion parameter, the number of current databases is kept in a constant state, and the problem that an original storage space cannot be released is solved, so the system can be normally operated for a long time without limitations of the storage space.

Description

technical field [0001] The invention mainly relates to the technical field of database processing, in particular to a method and system for releasing database space. Background technique [0002] The design scheme for adding and deleting databases in the system is directly related to whether the storage capacity of the entire system can operate normally. For example, the application system of the vehicle bayonet is used to record pictures of passing vehicles, using the mongoDB block file storage mechanism, and the daily bayonet The total number of passing vehicles ranges from 80,000 to 150,000, and the size of the passing pictures and license plate images generated by each passing record is 0.3M. The 3-month records are about 11 million, and the total picture size is about 3.3T. Due to the limitation of disk space, the data is only saved for 3 months, and the data and pictures older than 3 months need to be cleared. After clearing the historical data, the mongoDB data files ...

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
CPCG06F16/2282G06F16/211
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