A postgresql block storage device read and write module

Abstract

A PostgreSQL block storage device read-write module, the PostgreSQL block storage device read-write module being a PostgreSQL block storage device read-write module that manages PostgreSQL blocks in a PostgreSQL block storage device, and the PostgreSQL block storage device read-write module being constructed on a PostgreSQL database system. The PostgreSQL block storage device read-write module manages, by means of a idle PostgreSQL block table and a table of mapping relationships between PostgreSQL blocks and data tables, the PostgreSQL blocks in the PostgreSQL block storage device. The PostgreSQL block storage device read-write module will perform more secure data reading and writing operations to the database. The data in the database will be saved into the block device according to an established rule, such that the data is more secure in terms of security. Moreover, due to the use of distributed storage, the data can be saved in slices and multiple copies thereof are saved in different data nodes, and thus the security is more than a hundred times higher than 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