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

Method, device and system for managing cache result set

A management method and a technology for managing devices, which are applied in the field of devices and systems, and the management method of cached result sets, can solve the problems of CPU time consumption, small size, and low degree of access to result sets, and achieve efficient utilization

Inactive Publication Date: 2014-03-12
HUAWEI TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Then, for the case where the access level of the result set is not high, the number of base tables that the result set depends on has been changed a lot, and obtaining the result set takes a long time in the CPU, it is not only meaningless to update the cached result set, but it will even reduce the DBMS system. performance

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, device and system for managing cache result set
  • Method, device and system for managing cache result set
  • Method, device and system for managing cache result set

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0022] like figure 1 As shown, the embodiment of the present invention provides a management method for a cached result set, including:

[0023] 11. When the base table (Table) on which the result set in the cache depends is changed, determine the current number of visits S of the result set, and the CPU time t taken to obtain the result set for the first time cpu , CPU time t occupied by updating the result set ucpu , the current CPU busyness b ...

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

An embodiment of the invention discloses a method, a device and a system for managing a cache result set. The method includes that when a base table that a result set relies on in a cache is changed, determining current access times S of a result set, CPU (central processing unit) occupied time tcpu in acquisition of the result set for the first time, CPU occupied time tucpu in updating of the result set, current busy degree bcpu of a CPU and update times m of the result set; and when the value of a parameter c determined by the S, the tcpu, the tucpu and bcpu is larger than a preset value c0, or the value of the m is larger than a preset m0 and the value of a parameter n determined by the S and the m is larger than a preset value n0 in a certain period, then determining to update the result set, and if not, determining to invalid the result set. By the method and the device for managing the cache result set, system resources can be rationally utilized, and the cache result set can be efficiently utilized.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of databases, and in particular, to a management method, device and system for cached result sets. Background technique [0002] With the increasing degree of social informatization, especially the innovation of database technology, the capacity of database is growing faster and faster. Then, how to obtain target information accurately and quickly from such a large-capacity database puts forward higher requirements for DBMS (Database Management System, database management system) query technology. [0003] The most important point in the query technology is the query response time. The shorter the query response time and the more accurate the data obtained from the query, the more popular the DBMS will be. In order to achieve a short response time, the result set caching technology has appeared, which is to cache the result set of the database (or called base table (Table)) query. When...

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
Inventor 宋娇
Owner HUAWEI TECH CO LTD