GP database data storage method based on SAS and SSD

Abstract

The invention discloses a GP database data storage method based on SAS and SSD, and aims to solve the technical problem that the storage performance and effective data storage of a GP database are difficult to balance. The method comprises the steps of obtaining a to-be-stored data table; storing the to-be-stored data tables into different storage spaces of the GP database based on a storage space division principle; periodically obtaining data tables stored in different storage spaces of the GP database; performing storage space inspection on the stored data table based on a storage space division principle, and migrating the data table according to a storage space inspection result, wherein the storage space of the GP database comprises an SSD (Solid State Disk) mounted under one directory and an SAS (Serial Attached SCSI) mounted under the other directory. According to the invention, high IO performance and good storage efficiency can be realized.

Description

technical field [0001] The invention relates to a method for storing data in a GP database based on SAS and SSD, and belongs to the technical field of databases. Background technique [0002] The data warehouse built on the basis of Greenplum has a large storage capacity and high requirements for storage performance. If pure SAS is used as the database storage space, there may be insufficient IO performance. However, if all SSD disks are used as database storage There is also the situation that the construction cost is too high and resources are wasted. [0003] In general, data warehouses such as Greenplum Database have a large amount of historical data, and the query frequency of this part of data is relatively low. However, the hybrid disk storage methods on the market do not better divide the specific storage space of various types of data, nor provide a balanced rule to ensure the performance level of the hybrid disk and the effective storage of data. In long-term use...

AI Technical Summary

Problems solved by technology

[0004] In order to solve the problem that the storage performance of the Greenplum database and the effective storage of data are difficult to balance in the prior art, the present invention proposes a GP database data storage method based on SAS and SSD. The stored data tables are space-divided to ensure that frequently used data tables are stored in hot disks, and other data tables are stored in warm disks, which not only reduces data storage costs, but also achieves higher IO performance and better storage efficiency

Images