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

CN104346468AInactive Publication Date: 2015-02-11INSPUR BEIJING ELECTRONICS INFORMATION IND
4 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
Publication Date
2015-02-11
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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 ...

Examples

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...