Invention Grant
- Patent Title: Changing the compression level of query plans
- Patent Title (中): 更改查询计划的压缩级别
-
Application No.: US13469317Application Date: 2012-05-11
-
Publication No.: US08949222B2Publication Date: 2015-02-03
- Inventor: Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras , Mark W. Theuer
- Applicant: Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras , Mark W. Theuer
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Owen J. Gamon; Roy W. Truelson
- Main IPC: G06F7/76
- IPC: G06F7/76 ; G06F17/30

Abstract:
In an embodiment, a query plan is compressed to data in a cache at a high compression level if a runtime of a query that the query plan implements is greater than a high time threshold. The query plan is compressed to the data in the cache at a medium compression level if the runtime of the query that the query plan implements is less than the high time threshold and greater than a low time threshold. The query plan is stored to the data in the cache at an uncompressed level if the runtime of the query that the query plan implements is less than the low time threshold.
Public/Granted literature
- US20130304723A1 CHANGING THE COMPRESSION LEVEL OF QUERY PLANS Public/Granted day:2013-11-14
Information query