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

Method and device for realizing concurrent I/O (Input/Output) in database system

A database and file system technology, applied in the computer field, can solve problems such as data damage and affect the overall performance of the database system, and achieve the effects of eliminating file locking, increasing transaction processing speed, and improving performance

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

AI Technical Summary

Problems solved by technology

Since some files in the database system are cached by using the file buffer, implementing parallel I / O of the database system at the basic file system level will affect the overall performance of the database system and bring the risk of data damage

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 device for realizing concurrent I/O (Input/Output) in database system
  • Method and device for realizing concurrent I/O (Input/Output) in database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0037] It should be noted that, if there is no conflict, the embodiments of the present invention and various features in the embodiments can be combined with each other, and all are within the protection scope of the present invention. In addition, 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.

[0038] Embodiments of the present invent...

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 method and a device for realizing concurrent I / O (Input / Output) in a database system. The method comprises the following steps: configuring a file in the database system by using a no file system caching option of a structured query language statement and starting concurrent I / O for the file. Specifically, a table space corresponding to the file in the database system is established or modified by using the no file system caching option of the structured query language statement, and the concurrent I / O is started for the table space. The concurrent I / O is started for the file in the database system by using the NO FILE SYSTEM CACHING option, so that double caching and unnecessary file locking can be eliminated on the premise of guaranteeing that the performance and the completeness of the file cached in a file caching area used in the database system are not affected; thus the occupation of a memory and a CPU (Central Processing Unit) resource is reduced, the performance of an application program is obviously improved, and the transaction processing rate is improved; the method and the device are particularly suitable for the database system after migration.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for realizing concurrent I / O in a database system. Background technique [0002] The file buffer cache is a buffer area opened by the operating system in memory to store frequently accessed data and minimize the frequency of physical disk I / O. When the cache hit ratio is high, the use of the file buffer cache can effectively reduce the number of disk I / O. When an application program sends a read request to the operating system, the operating system first looks for the data corresponding to the read request in the file buffer cache, and if the data is found, it obtains the data from the file buffer cache and writes it to the application Program buffer without going to disk. If the data is not found, the data is fetched from disk, stored in the file buffer cache, and transferred to the application buffer. [0003] However, since the database system has its ...

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): G06F17/30
CPCG06F16/172G06F16/24552
Inventor 张立雨
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
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