Data querying method and device

A data query and data technology, applied in the field of data query, can solve problems such as difficult guarantee of system availability, poor scalability, unstable service, etc., and achieve the effect of improving system availability and reducing the proportion of error reports

Active Publication Date: 2018-09-28
ADVANCED NEW TECH CO LTD
View PDF3 Cites 7 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
  • Data querying method and device
  • Data querying method and device
  • Data querying method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The solutions provided in this specification will be described below in conjunction with the accompanying drawings.

[0025] figure 1 It is a schematic diagram of an implementation scenario of an embodiment disclosed in this specification. exist figure 1 , the data is stored in the database system 100, and the database system 100 may be a distributed storage system located in the cloud. Multiple querying business entities such as figure 1 The business entities A, B and C shown 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 a business entity executes, when it requests a query from the database system, it is referred to as a query system. query system in figure 1 is shown as 400 in. In order to avoid the pressure brought by all query requests directly to the database system, a ca...

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 provides a data querying method. The method comprises the following steps of: obtaining a query request from a query system, wherein the query request is used for requesting to query data in a database system; obtaining a cache setting label corresponding to the query request, wherein the cache setting label comprises cache invalidation time and an automatic invalidation label; determining whether cache data corresponding to the query request are invalid or not according to the cache invalidation time; and if the cache data are invalid, querying data in the database system and returning result data to the query system according to a query result of querying the data in the database system and the state of the automatic invalidation label. The invention alsoprovides a querying device corresponding to the querying method. Therefore, the data can be queried 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 device. Background technique [0002] With the development of computer and Internet technology, the storage and query of massive data has become a frequently used operation 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 all the queries on these massive data directly arrive at the storage system, it will put great pressure on the storage system. Therefore, in some solutions, a cache layer, such as TAIR cache, is added before the storage system. When an external system queries data, it first queries the cache layer, and if the cached data does not exist or has expired, it then queries the storage system. [0003] However, from the practical results, there are still some shortcomings in this way. ...

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): G06F17/30
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