A distributed high-performance database all-in-one system

Abstract

The invention relates to a distributed high-performance database all-in-one machine system which comprises a database all-in-one machine and an auxiliary module configured in the database all-in-one machine. The database all-in-one machine comprises a user host, an Oracle application host, a storage device and a data storage network, wherein the user host is used for business processing, the Oracle application host returns a processing result to the user host, the storage device stores data needed by the user host, and the data storage network is connected with the Oracle application host and the storage device. The auxiliary module comprises a storage device management module, a distributed high-performance intelligent storage module and an Oracle host adaption module, wherein the storage device management module is used to schedule the storage device in a unified manner, the distributed high-performance intelligent storage module communicates with the storage device management module to realize distributed high-performance intelligent storage of the storage device, and the Oracle host adaption module is used to map the storage device into a standard storage hardware resource. Compared with the prior art, the distributed high-performance database all-in-one machine system has the advantages of large processing data bulk, high processing speed, high processing performance and high reliability.

Description

technical field [0001] The invention relates to the field of Oracle database storage management, in particular to a distributed high-performance database all-in-one system. Background technique [0002] Oracle database is an excellent DMBS launched by Oracle Corporation. Currently, Oracle DBMS and related products are used in almost every industrial field in the world. Regardless of the online transaction processing and data warehouse applications of large enterprises, or small and medium-sized online transaction processing services, there are many typical applications successfully used by the Oracle database system. [0003] In order to deploy Oracle database, the most common structure is multi-node RAC (Real Application Cluster) plus shared storage. figure 1 It is a typical construction method, including 1 user host 1, Oracle RAC node 2 and shared storage device 3. This structural mode has existed in the data center for more than ten years, is mature, reliable, and quite ...

AI Technical Summary

Problems solved by technology

The current FC network can reach a maximum interface rate of 16Gb / s. Even if mid-to-high-end storage uses multi-port parallelism, its throughput can only reach the level of 4-5GB / s. This is in the face of TB-level data processing. Said that the general business hours are more than 20 hours, which is obviously unable to meet the business needs of users

[0007] Therefore, the database deployment mode under the traditional Oracle RAC structure has serious performance bottlenecks in the processing of large amounts of data.

Images