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

Data query method, device, computer equipment and storage medium

A data query and computer program technology, applied in the database field, can solve problems such as consuming more system resources, query request response timeout, affecting database system availability and stability, etc., to improve availability and avoid response timeout effects.

Active Publication Date: 2022-08-05
JIANGSU SUNING LOGISTICS CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the case of high concurrency of query requests (reading peak), since the relational database adopts row-column storage, multiple copies have to be made to meet the query requirements. In order to maintain multiple copies, data synchronization between master and slave will consume more Multiple system resources, therefore, the availability and stability of the entire database system will be affected in the case of high concurrency, resulting in the response timeout of query requests

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the objectives, technical solutions and advantages of the present application more clear, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application.

[0034] It can be understood that the term "and / or" used in this application describes the association relationship between related objects, indicating that there can be three kinds of relationships, for example, A and / or B, which can mean that A exists alone, A and B exist simultaneously, There are three cases of B alone. The character " / " generally indicates that the contextual object is an "or" relationship.

[0035] The data query method provided in this application can be applied to such as figure 1 in the application environment shown. The terminal 102 communicates with ...

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 application relates to a data query method, apparatus, computer equipment and storage medium. The method includes: receiving a query request, and when the query request is a real-time query request, acquiring the resource usage information of the relational database server; if the resource usage information of the relational database server meets a preset condition, calling the relational database server to retrieve the relational database server from the relational database server. The database obtains the data corresponding to the query request; if the resource usage information of the relational database server does not meet the preset conditions, the search engine server is called to obtain the data corresponding to the query request from the search engine database; wherein, the same data is written to the relational database earlier at the time of writing to the search engine database. By adopting the method, the database system can be switched at any time according to the resource usage under the condition of high concurrency of query requests, thus avoiding the response time-out of the query request, thereby improving the availability and stability of the entire database system.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular, to a data query method, apparatus, computer equipment and storage medium. Background technique [0002] With the development of database technology, various types of databases have emerged, such as relational databases. Relational databases refer to databases that use a relational model to organize data. They store data in the form of rows and columns, and the storage form is easy to understand. And easy to use, is the more commonly used database. [0003] For relational database systems, a master-slave deployment method is generally adopted. The master database is used to provide write services, and the slave database is used to provide query services. However, in the case of high concurrency of query requests (peak read), since the relational database adopts the row-column storage form, multiple copies have to be made to meet the query requirements. In order to m...

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 Patents(China)
IPC IPC(8): G06F16/2455G06F16/2457G06F16/25G06F16/28
CPCG06F16/24552G06F16/24578G06F16/25G06F16/284
Inventor 王杰历吉艳孙启辰张宇飞罗学亮
Owner JIANGSU SUNING LOGISTICS CO LTD
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

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

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