PostgreSQL block

A block device and storage capacity technology, applied in the PostgreSQL block field, can solve the problems of security loopholes, data security cannot be guaranteed, and file system expansion troubles, etc., to achieve the effect of improving read and write speed and security.

Active Publication Date: 2016-05-11
CHINA COMM SOFTWARE TECH CO LTD +1
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0027] Second, the expansion of the file system is also very troublesome
[0028] Third, the migration of databases between different systems is extremely complex, requiring high professional knowledge of operators
[0029] Fourth, the database 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 block
  • PostgreSQL block
  • PostgreSQL block

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0074] Example one:

[0075] Such as Figure 4 As shown, the PostgreSQL block of the present invention is the smallest unit allocated to the data table in the PostgreSQL database system, and the storage capacity of the PostgreSQL block is equal to 4MB.

[0076] Of course, it is also possible that the storage capacity of the PostgreSQL block is greater than 4KB.

[0077] It may also be that the storage capacity of the PostgreSQL block is a positive integer multiple of 8KB.

[0078] It may also be that the storage capacity of the PostgreSQL block is a natural number times of 2 of 8KB.

[0079] More may be, the storage capacity of the PostgreSQL block is 1MB, 2MB, 8MB, 16MB, 32MB, 64MB, 128MB, 256MB, 512MB or 1024MB.

Example Embodiment

[0080] Embodiment two:

[0081] Such as Figure 4 As shown, the PostgreSQL block storage device read-write module of the present invention is a PostgreSQL block storage device read-write module that manages the aforementioned PostgreSQL block in the PostgreSQL block storage device.

[0082] The PostgreSQL block storage device read-write module can be constructed on the PostgreSQL database system.

[0083] The PostgreSQL block storage device read-write module manages the PostgreSQL blocks in the PostgreSQL block storage device through the PostgreSQL block-data table mapping relationship table and the free PostgreSQL block table.

[0084] The PostgreSQL block-data table mapping relationship table includes fields Relfilenode, Reltablespace, Forknum, Blockid, Blockno, and the free PostgreSQL block table includes fields Blockid, Isfree, and Dev.

[0085] The PostgreSQL block storage device read-write module has the following sub-modules:

[0086] Allocate submodules of PostgreSQL blocks,

[0...

Example Embodiment

[0102] Embodiment three:

[0103] Such as Figure 4 As shown, the present invention is based on the data reading and writing method of the PostgreSQL block storage device, using the PostgreSQL block storage device read and write module as described above to read and write the PostgreSQL block as described above.

[0104] A. In the database background driver layer, the driver of the PostgreSQL block storage device read-write module completes the operation of the block file, and its main tasks are:

[0105] a. Through the file handle manager to manage the read and write interface of the upper-level business to the underlying device, to achieve a high-concurrency read and write interface;

[0106] b. Realize the overwriting of the PostgreSQL block storage device, directly locate the specified location of the PostgreSQL block storage device, and write the specified length of data;

[0107] B. According to the PostgreSQL block-data table mapping relationship table oid and table space, locat...

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

PropertyMeasurementUnit
Storageaaaaaaaaaa
Storageaaaaaaaaaa
Storageaaaaaaaaaa
Login to view more

Abstract

The invention discloses a PostgreSQL block. The PostgreSQL block is the minimum unit allocated to a data table in a PostgreSQL database system, and the storage capacity of the PostgreSQL block is larger than 4 KB; the storage capacity of the PostgreSQL block is a positive integer multiple of 8 KB; the storage capacity of the PostgreSQL block is a product of 8KB and 2 to the Nth, wherein N is a natural number; the storage capacity of the PostgreSQL block is 1 MB, 2 MB, 4 MB, 8 MB, 16 MB, 32 MB, 64 MB, 128 MB, 256 MB, 512 MB or 1024 MB. The query speed and the read-write speed can be greatly increased and can be increased at the rate of 10%-20% under the same rear-end storage condition; data of the database can be safer: the data are stored in a block device according to established rules and are safer in terms of security; with the adoption of distributed storage, the data can be stored in a fragmentation manner and stored in multiple different data nodes and are a hundred times safer than data stored in a single magnetic disk in terms of security; database services and data separation are realized.

Description

technical field [0001] The invention relates to a PostgreSQL database storage device, in particular to a PostgreSQL block for storing a PostgreSQL data table in a PostgreSQL database. 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 warehousing requirements force us to give up real-time indexing, and the data scanning of large data volumes is limited by the IO 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 l...

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): G06F3/06
CPCG06F16/00G06F3/061G06F3/0631G06F3/0644G06F3/0674
Inventor 朱晓伟
Owner CHINA COMM SOFTWARE TECH 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