PostgreSQL database mass data management method and system

A massive data management and database technology, which is applied in the fields of electrical digital data processing, special data processing applications, and data processing input/output process, etc. Reduce the predictability of data storage and other problems, to achieve the effect of reducing management and maintenance costs, important market value, and improving maintenance efficiency

Active Publication Date: 2016-08-24
WUHAN HONGXIN TECH SERVICE CO LTD
View PDF5 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

With the continuous emergence of various business systems, the predictability of data storage is relatively reduced according to the needs of different types of data, and the difficulty of presetting data space is increasing. This requires different systems to be configured with d

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
  • PostgreSQL database mass data management method and system
  • PostgreSQL database mass data management method and system
  • PostgreSQL database mass data management method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] The invention is applied in the data analysis system of the mobile packet domain based on the database technology. The specific implementation of the present invention will be described below according to the drawings and embodiments.

[0066] The basic principle of the embodiment of the present invention is: pay attention to the principle of PostgreSQL database data storage, add the configuration of table space, table object, index object and system information adopted by database mass storage, and combine the system automatic service mechanism to complete the data of massive database management work. The embodiment of the present invention is based on the PostgreSQL database platform, and completes the initialization of the system automatic management configuration data through a set of information configuration scheme of the designed automatic management mode, and then combines the system timing scheduling mechanism to realize automatic data management.

[0067] On ...

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 postgreSQL database mass data management method and system. The method is implemented based on a Linux platform and includes the steps that mass storage management configuration initialization is performed, and system timing scheduling is started; stale data partitions beyond a reserved time quantum are deleted, and then partition data, within a reserved time quantum and beyond an actual storage cycle, in non-stale data partitions is cleared away; storage space checking is performed, whether a storage space supports pre-expansion or not is judged, if yes, partition pre-expansion operation and index establishment are performed, and otherwise, an adaptive simplification mechanism is triggered. According to the postgreSQL database mass data management method and system, the validity, availability and expandability of data are guaranteed, a numerical basis is provided for data expansion, the maintenance efficiency of database administrators is effectively improved, the database management and maintenance cost is greatly reduced, and the postgreSQL database mass data management method and system have significant market value.

Description

technical field [0001] The invention relates to the technical field of database applications, in particular to a method and system for managing massive data of a PostgreSQL database based on a Linux platform. Background technique [0002] PostgreSQL database is an open source, practical, efficient, and widely used general-purpose database management system. Its traditional data management methods are mainly divided into two types: one is that the amount of data can be controlled within a predictable range, and it can be completed at one time. The deployment of data storage space does not need to be expanded in the future; the other is to rely on the database DBA to conduct daily inspections to maintain the normal operation of the database. With the continuous emergence of various business systems, the predictability of data storage is relatively reduced according to the needs of different types of data, and the difficulty of presetting data space is increasing. This requires...

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/30G06F3/06
CPCG06F3/0644G06F16/2282
Inventor 肖建桥胡志勇叶仕祥蔡剑峰肖伟明余道敏
Owner WUHAN HONGXIN TECH SERVICE 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