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
CN105893531AActive Publication Date: 2016-08-24WUHAN HONGXIN TECH SERVICE CO LTD
5 Cites 18 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Current Assignee / Owner
WUHAN HONGXIN TECH SERVICE CO LTD
Publication Date
2016-08-24

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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