Read-write module of PostgreSQL block storage device

Abstract

The invention discloses a read-write module of a PostgreSQL block storage device. The read-write module of the PostgreSQL block storage device manages PostgreSQL blocks in the PostgreSQL block storage device and is constructed in a PostgreSQL database system. The read-write module of the PostgreSQL block storage device manages the blocks in the PostgreSQL block storage device through a mapping relationship table between the PostgreSQL blocks and a data table as well as an idle PostgreSQL block table. The read-write module of the PostgreSQL block storage device is securer for reading and writing of data in a database. The data in the database is stored in the block device according to an established rule, so that the data is higher in security. Moreover, due to the use of distributed storage, the data is subjected to fragmented storage and multiple copies are stored in different data nodes, so that the security is improved by more than a hundred times in comparison with that of a single disk.

Description

technical field [0001] The invention relates to a PostgreSQL database storage device, in particular to a PostgreSQL block storage device read-write module. Background technique [0002] With the development of the Internet, mobile Internet and the Internet of Things, we have ushered in an era of massive data, and more and more data are stored in the database, but the query time we need is getting smaller and smaller. Many application scenarios today require background storage with high concurrency, high capacity, and high response. The high-speed storage requirements force us to give up real-time indexing, and the data scanning of large data volumes is limited by the I / O on the storage side. In the current PostgreSQL database system, high-concurrency multi-database scans are basically random reads. At the same time, the throughput of ordinary disks can no longer meet the demand. [0003] In order to adapt to the application scenarios with a large amount of data, the offici...

AI Technical Summary

Problems solved by technology

[0023] First, the database data files are directly exposed to the operating system, and there are potential security risks in the data, so data security cannot be guaranteed. This is a huge security hole for some use environments that require a high level of security.

[0024] Second, the use of the disk must go through the file system layer

[0028] Third, the expansion of the file system is also very troublesome

[0029] Fourth, the migration of databases between different systems is extremely complex, requiring high professional knowledge of operators

Images