Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database all-in-one machine capable of realizing high-speed storage

A high-speed storage and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problem that the database integrated machine technology has not been popularized and applied, and achieve the effect of reducing scale and solving performance problems.

Inactive Publication Date: 2014-06-18
南京斯坦德云科技股份有限公司
View PDF4 Cites 29 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The early database all-in-one machine can well guarantee the reliability of the database system and operating system, but the low-speed I / O performance of the disk prevents the database all-in-one machine technology from being promoted and applied

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
  • Database all-in-one machine capable of realizing high-speed storage
  • Database all-in-one machine capable of realizing high-speed storage
  • Database all-in-one machine capable of realizing high-speed storage

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0083] Further, see Figure 4 , discloses the work flow chart of the high-speed storage database integrated machine according to the present invention. Including the following steps:

[0084] Step1:

[0085] When the application server 4 initiates a transaction request, it sends the SQL statement to the computing cluster 1, and lets a process of a certain node of the computing cluster 1 process the statement. That is to say, the Oracle application server 4 does not perform any operations, and its main task is to send some SQL statements generated by the application server 4 to the computing cluster 1 . Although there is also a database process in the application server 4, the role of this process is different from that of the database server. Only the database process on the database server will process the SQL statement. However, there is a problem that needs to be explained, that is, the process of the application server 4 corresponds to the process of the database serve...

Embodiment 2

[0094] 2 computing servers and 3 fusion-io storage servers are used as the shared storage storage architecture, the data adopts the asm normal redundancy redundancy scheme, and all files are stored on the fusion-io storage server for performance testing.

[0095] 1.IOPS test, IOPS (Input / Output Operations Per Second), that is, the number of read and write (I / O) operations per second.

[0096] Table 1 IOPS test results

[0097] serial number project IOPS value throughput 1 Pure reading 156,000 1219.88 M / s 2 80% read, 20% write 136,000 1101.68 M / s

[0098] Note: The size test is based on the block being 8k.

[0099] Figure 5(a) The pure read IOPS and delay diagram of this embodiment are shown, Figure 5(b) The mixed read and write IOPS and delay diagram of this embodiment are shown.

[0100] 2. TPM test value

[0101] Fusion-io stores TPM test values ​​as follows:

[0102]

[0103] Single node and RAC database TPM peak value

[...

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

No PUM Login to View More

Abstract

The invention discloses a database all-in-one machine capable of realizing high-speed storage. The database all-in-one machine is characterized by comprising a computing cluster, an Infiniband network cluster and a Fusion-io distributed storage, wherein the computing cluster comprises a plurality of computing servers which are used for computing; the computing servers form the computing cluster; the Infiniband network cluster comprises a plurality of Infiniband interchangers which are used for data exchange; the Fusion-io distributed storage comprises a plurality of Fusion-io storage servers. A Fusion-io flash memory product is introduced to a storage system of the database all-in-one machine, the I / O (Input / Output) bottleneck problem of the database all-in-one machine is effectively solved, the exponential order promotion is brought for performance indexes such as storage IOPS (Input / Output Operations Per Second) and throughput, and the database all-in-one machine capable of realizing high-speed storage is suitable for database application scenes with higher requirements such as high concurrency and high throughput.

Description

technical field [0001] The present application relates to a database integrated machine, in particular, a database integrated machine using Fusion ioMemory high-speed storage. Background technique [0002] In recent decades, there has been a severe asymmetry between I / O performance and CPU processing performance in computer systems, and with the rapid development of CPU technology, this gap will become wider and wider. At the same time, the emergence of various new applications such as social networks, the Internet of Things, and the mobile Internet, as well as the more refined processing requirements of high-performance computing, have led to explosive growth in the scale of data processing. Frequent I / O requests have seriously restricted the processing capacity of computer systems, so I / O processing capacity has become an urgent problem in computer systems. [0003] Traditional disk storage systems have made a lot of efforts for this. The disk system utilizes the paralle...

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): H04L29/08G06F17/30
Inventor 储浩黄启国高静
Owner 南京斯坦德云科技股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com