Patent ID: 11954105
Assignee: ALIBABA GROUP HOLDING LIMITED
Field: Computer technology (Electrical engineering)
Classification: CPC G  H | IPC G

Claim 8:
9. A computer system for storing a query plan, comprising:
a cache including at least two storage layers and each of the storage layers is associated with a compression level for query plans;
a memory storing a set of instructions; and
at least one processor, configured to execute the set of instructions to cause the computer system to perform:
determining a use frequency of the query plan, the query plan including at least one query operator;
determining a target storage layer for storing the query plan based on the determined use frequency, wherein the cache includes at least two storage layers and each of the storage layers is associated with a compression level of query plans;
processing the query plan according to the compression level of the target storage layer, wherein processing the query plan comprises:
determining a compression level difference between the compression levels of a first storage layer and the target storage layer,
determining a compression change to the at least one query operator of the query plan based on the compression level difference, and
performing the compression change to the at least one query operator of query plan according to a compression algorithm; and

storing the processed query plan in the target storage layer, wherein the query plan is previously stored in the first storage layer different from the target storage layer and is moved from the first storage layer to the target storage layer.