Method and device for data query

A data query and data technology, applied in the field of data query, can solve the problems of poor scalability, difficult to guarantee system availability, and multiple query errors, and achieve the effect of reducing the proportion of errors and improving system availability.

Active Publication Date: 2022-06-24
ADVANCED NEW TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In such a case, if the storage system fluctuates, that is, the service is unstable, it will lead to more query errors, and it is difficult to guarantee the availability of the system
In addition, the access strategy for the cache layer needs to be written into the business code of the external system for query, which increases the risk of code intrusion, and also makes the code redundancy of the business code high and the scalability is not good

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
  • Method and device for data query
  • Method and device for data query
  • Method and device for data query

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The solution provided in this specification will be described below with reference to the accompanying drawings.

[0025] figure 1 A schematic diagram of an implementation scenario of an embodiment disclosed in this specification. exist figure 1 , the data is stored in a database system 100, which may be a distributed storage system located in the cloud. Multiple business entities making queries, such as figure 1 The illustrated business entities A, B and C can all request query data from the database system. These business entities can be servers that perform various services, such as Alipay servers, Taobao servers, and so on. In the following description, no matter what kind of business it is, a business entity that requests a query from a database system will be referred to as a query system. query system in figure 1 shown as 400. In order to avoid the pressure caused by all query requests going directly to the database system, a cache layer 200 and a product ...

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 this specification provides a method for data query, the method includes: obtaining a query request from a query system, the query request is used to query data in a database system; obtaining the cache setting tag corresponding to the query request, including cache Expiration time, and automatic invalidation label; then, according to the above cache expiration time, determine whether the cache data corresponding to the query request is invalid. If the cached data has expired, then query the database system for data, and then return the result data to the query system according to the query result of the data query to the database system and the status of the above-mentioned automatic invalidation tag. A query device corresponding thereto is also provided. In this way, data query can be performed more flexibly and efficiently.

Description

technical field [0001] One or more embodiments of this specification relate to the field of computer technology, and in particular, to a data query method and apparatus. Background technique [0002] With the development of computer and Internet technology, the storage and query of massive data have become frequently used operations in computer processing systems. Generally, in order to cope with the storage of massive data, the data is usually stored in a distributed storage system in the cloud. If the queries for these massive data all directly reach the storage system, it will cause great pressure on the storage system. Therefore, in some schemes, a caching layer is added in front of the storage system, such as the TAIR cache. When the external system performs data query, the query is first performed at the cache layer. If the cached data does not exist or has expired, the query is performed on the storage system. [0003] However, from the practical results, there are...

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/2457
Inventor 李渠成腾国凯
Owner ADVANCED NEW 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