Check patentability & draft patents in minutes with Patsnap Eureka AI!

Data access method and device, equipment and storage medium

A data access and data technology, applied in the database field, can solve the problems of concurrency conflicts, reduce the performance of the database management system, and inconsistent data page access frequency, and achieve the effect of reducing concurrency conflicts and improving access efficiency.

Active Publication Date: 2019-11-22
SHANGHAI DAMENG DATABASE
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the database management system, the access frequency of different types of data pages is inconsistent, and some frequently accessed data pages will still cause concurrency conflicts in the Buffer Pool critical section, thereby reducing the performance of the database management system

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
  • Data access method and device, equipment and storage medium
  • Data access method and device, equipment and storage medium
  • Data access method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] figure 1 It is a flow chart of a data access method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of accessing database data. The method can be executed by a data access device, which can be composed of hardware and / or software , and generally can be integrated into a device with data access function, which may be an electronic device such as a server, a mobile terminal, or a server cluster. Such as figure 1 As shown, the method specifically includes the following steps:

[0045] Step 110, load the setting data page into the fast pool, and create a hash table corresponding to the fast pool.

[0046] Among them, the Fast Pool is created when the database starts, and the data pages in the Fast Pool are fixed. Once the data in the database is loaded into the Fast Pool, it will not be eliminated. Then a new data page is loaded into the fast pool. That is, the hash table in the fast pool will not change, there is no nee...

Embodiment 2

[0079] figure 2 It is a schematic structural diagram of a data access device provided by Embodiment 2 of the present invention. Such as figure 2 As shown, the device includes: a setting data page loading module 210 , a target data page judging module 220 and a target data page accessing module 230 .

[0080] Setting data page loading module 210, configured to load the setting data page into the fast pool, and create a hash table corresponding to the fast pool;

[0081] The target data page judging module 220 is configured to calculate a hash value according to the address of the target data page, and search whether the target data page is in the fast pool in the hash table corresponding to the fast pool according to the hash value;

[0082] The target data page access module 230 is configured to access the target data page in the fast pool according to an access mode when the target data page is in the fast pool.

[0083] Optionally, the setting data page loading module 2...

Embodiment 3

[0108] image 3 It is a schematic structural diagram of a computer device provided by Embodiment 3 of the present invention. image 3 A block diagram of a computer device 312 suitable for implementing embodiments of the invention is shown. image 3 The computer device 312 shown is only an example, and should not impose any limitation on the functions and scope of use of the embodiments of the present invention. Device 312 is typically a computing device that undertakes data access functions.

[0109] Such as image 3 As shown, computer device 312 takes the form of a general-purpose computing device. Components of computer device 312 may include, but are not limited to: one or more processors 316, storage 328, bus 318 connecting various system components including storage 328 and processor 316.

[0110] Bus 318 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, ...

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 embodiment of the invention discloses a data access method and device, equipment and a storage medium. The method comprises the following steps: loading a set data page into a fast pool, and creating a hash table corresponding to the fast pool; calculating a hash value according to a target data page address, and searching whether the target data page is in the fast pool or not in a hash tablecorresponding to the fast pool according to the hash value; and if so, accessing the target data page in the fast pool according to the access mode. According to the data acccess method, the set datapage is loaded into the fast pool, if the target data page is in the fast pool, the target data page in the fast pool can be directly accessed according to the access mode, concurrent access protection does not need to be carried out in a critical area, concurrent conflicts caused by high-frequency access to the data page can be reduced, and therefore the access efficiency of the database is improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a data access method, device, device, and storage medium. Background technique [0002] Database management systems generally use a fixed-size page (Page) as the basic unit for storing data, and use a memory cache (Buffer Pool) to store recently read or modified data pages from the disk to reduce disk I / O and improve database access speed. The general process of accessing a data page is to obtain the data page from the Buffer Pool first, and if the data page is not in the Buffer Pool, load the data page from the disk to the Buffer Pool. If the Buffer Pool is full and there are no free data pages, you need to eliminate a data page that is not currently in use, and then load the data page from the disk. BufferPool uses a hash table (Hash Table) to quickly find data pages, maintains an LRU (Least Recently Used) linked list to determine the order of...

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): G06F16/22G06F16/2455G06F12/1009
CPCG06F16/2255G06F16/2246G06F16/24552G06F12/1009
Inventor 王海龙韩朱忠
Owner SHANGHAI DAMENG DATABASE
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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