Database cache construction method and apparatus, computer device, and storage medium

A construction method and database technology are applied in the fields of devices, computer equipment, storage media, and database cache construction methods, and can solve problems such as data query performance degradation, increase in database I/O pressure, and impact on user experience.

Active Publication Date: 2019-03-29
WONDERSHARE TECH CO LTD
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the amount of data in a single table of the database reaches a certain level, if the data is obtained by directly accessing the database, t

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 cache construction method and apparatus, computer device, and storage medium
  • Database cache construction method and apparatus, computer device, and storage medium
  • Database cache construction method and apparatus, computer device, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] 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 some of the embodiments of the present invention, but not all of them. 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.

[0030] It should be understood that when used in this specification and the appended claims, the terms "comprising" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude one or Presence or addition of multiple other features, integers, steps, operations, elements, components and / or collections thereof.

[0031] It should also be understood that the terminology 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
Login to view more

PUM

No PUM Login to view more

Abstract

The embodiment of the invention discloses a database cache construction method and apparatus, a computer device and a storage medium. The method comprises the following steps: a memory database is preset to store the table names of all data tables in a target database; If a cache creation request is received, acquiring table names of each data table stored in the in-memory database; creating an index module corresponding to a table name of each data table, wherein the index module comprises a primary index, an incremental index and a real-time index; constructing cache of the target database is constructed based on the primary index, the incremental index, and the real-time index. The invention creates an index module to cache the data in the data table for each data table in the target database, which can improve the access efficiency of the data and reduce the access pressure of the database at the same time.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a database cache construction method, device, computer equipment and storage medium. Background technique [0002] In the era of big data, with the continuous enrichment of business, the explosive growth of data poses a severe challenge to the query capability of the database, and the processing of high concurrency and massive data has increasingly become an important factor affecting system performance. When the amount of data in a single table of the database reaches a certain level, if the data is obtained by directly accessing the database, the I / O pressure of the database will be increased, resulting in a decrease in data query performance and seriously affecting the user experience. Contents of the invention [0003] In view of this, the embodiments of the present invention provide a database cache construction method, device, computer equipment, and storage med...

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/2455
Inventor 颜洪辉肖泽伟
Owner WONDERSHARE TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap