Unlock instant, AI-driven research and patent intelligence for your innovation.

Update cached database query results

A technology for query results and data caching, applied in the field of database

Active Publication Date: 2017-07-18
AMADEUS S
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, another problem with such caching methods is keeping the precomputed query results up to date in order to ensure that the queries answered by the cached results correctly reflect the state of the corresponding large database

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
  • Update cached database query results
  • Update cached database query results
  • Update cached database query results

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] general description

[0024] Before turning to a detailed diagram-based description, first reference will be made to figure 1 Elaborate on some general aspects.

[0025] To be able to handle batch computing requests or database queries that require computations based on large amounts of underlying data, database query results corresponding to the desired query are typically precomputed and cached (the term "query" is subsequently used to include things such A general term for any type of information retrieval request, requests for batch computations, and other forms of requests). The cached results are stored and returned to the querying entity in response to the query actually occurring. figure 1 Such a database system 1 is shown on an abstract level. Basic data is stored in computing platform 3 connected to cache platform 2 . Caching platform 2 issues recalculation commands to computing platform 3, which then sends corresponding results back to caching platform 2 ...

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

A data cache platform maintains pre-computed database query results computed by a computation platform based on data maintained in the computation platform and is configured to determine probabilities of the pre-computed database query results being outdated, to automatically issue re-computation orders to the computation platform for updating pre- computed database query results on the basis of the determined probabilities of the pre- computed database query results being outdated and to receive the updated pre-computed database query results as results of the re-computation orders. The probability determination depends on a probabilistic model and on the occurrence of asynchronous real-time events. The real-time events are indeterministic with regard to the expiration of the cached database query results and only have a probabilistic influence on the discrepancies between the database query results maintained in the data cache platform and presumed actual database query results.

Description

technical field [0001] The present invention is aimed at the technical field of databases. More specifically, it focuses on strategies for precomputing and caching database query results and keeping those results up to date. Background technique [0002] A common problem in database technology is ensuring short response times for database queries that require the processing of large amounts of data. For example, such computational power-consuming processes have to respond to so-called "open-ended" processes that contain only little input information (e.g. specify only one or two of a dozen possible parameters and / or specify a wide range of parameter values). query" and, therefore, typically result in a large number of results. Possibilities to accelerate data processing by increasing hardware performance are limited. Therefore, improving the mechanism under the large amount of data processing has attracted people's attention. [0003] One general approach to shorten quer...

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): G06F17/30
CPCG06F16/24539G06Q10/02G06Q50/14
Inventor D·克拉博瑞尼G·莱纳德B·贾宁L·伊斯纳尔迪N·麦洛特C-A·罗伯林R·达尼埃罗
Owner AMADEUS S