Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and apparatus for improving database performance

A database and performance technology, applied in the field of improving database performance, can solve the problem that the disk subsystem is easy to become a bottleneck, and achieve the effect of improving access speed, performance and efficiency

Active Publication Date: 2015-11-11
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The disk subsystem can easily become a bottleneck in OLTP databases

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
  • Method and apparatus for improving database performance
  • Method and apparatus for improving database performance

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0040] The steps shown in the flowcharts of the figures may be performed in a computer system, such as a set of computer-executable instructions. Also, although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0041] Such as figure 1 Shown, the method for improving database performance of the present invention comprises:

[0042] Step 101: initializing the memory disk;

[0043] In the present invention, a part of memory is virtualized into a drive device, whi...

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 present invention discloses a method and an apparatus for improving database performance. The method comprises: initializing a memory disk; establishing a directory that needs to be mounted by the memory disk, and mounting the initialized memory disk to the the established directory; and establishing a database in the directory that the memory disk is mounted to, and storing data files of the database by using the memory disk. According to the method and the apparatus, all database operations will not cause disc I / O, thereby shortening response time of the database, increasing degree of concurrency and improving the database performance.

Description

technical field [0001] The invention relates to the fields of computer systems and databases, in particular to a method and device for improving database performance. Background technique [0002] The full name of OLTP is online transaction processing, that is, online transaction processing. OLTP users pay more attention to the concurrency and response time of the database, and the response time will directly affect the user's final experience. Typical OLTP systems include e-commerce systems, banking systems, and securities business systems, such as the business databases of Taobao and eBay, which are typical OLTP databases. [0003] The disk subsystem tends to become a bottleneck in OLTP databases. The disk subsystem has the slowest performance in the entire computer system, and the update frequency is much lower than that of the CPU and memory. [0004] In the OLTP environment, the disk subsystem is closely related to the response time of the database, and the data block...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/21G06F16/217
Inventor 杨磊
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND