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

Data query method and 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 avoid response timeout and improve availability.

Active Publication Date: 2021-04-02
JIANGSU SUNING LOGISTICS CO LTD
View PDF3 Cites 1 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 and device, computer equipment and storage medium
  • Data query method and device, computer equipment and storage medium
  • Data query method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, not to limit the present application.

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

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

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 relates to a data query method and device, computer equipment and a storage medium. The method comprises the steps of receiving a query request, and when the query request is a real-timequery request, obtaining resource use information of a relational database server; if the resource use information of the relational database server meets a preset condition, calling the relational database server to obtain data corresponding to the query request from a relational database; if the resource use information of the relational database server does not meet the preset condition, calling a search engine server to obtain data corresponding to the query request from a search engine database, wherein the time for writing the same data into the relational database is earlier than the time for writing the data into the search engine database. By adopting the method, the database system can be switched at any time according to the resource use condition under the condition of high concurrency of the query request, so that response timeout of the query request is avoided, and the availability and stability of the whole database system are improved.

Description

technical field [0001] The present application relates to the field of database technology, in particular to a data query method, device, 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, it is the most commonly used database at present. [0003] For relational database systems, a master-slave deployment 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 (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...

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 Applications(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