Method and system to prefetch data in databases
AssigneeAlibaba Group Holding Limited
InventorsFang ZHENG, Ruiping LI, Cheng ZHU, Congnan LUO, Huaizhi LI, Xiaowei ZHU
Life of this patent
Estimating the term…
Abstract
The present disclosure provides systems and methods for prefetching data in databases. One method for prefetching data in a database comprises receiving a database query on the database, determining one or more sets of adjacent columns access by the database query, and for each set of adjacent columns of the one or more determined sets, prefetching data in the adjacent columns.
Claims20
A method for prefetching data in a database, the method comprising:
- receiving a database query on the database;
- determining one or more sets of adjacent columns accessed by the database query;
- and
- for each set of adjacent columns of the one or more determined sets, prefetching data in the adjacent columns.
A database system, comprising:
- a memory storing a set of instructions;
- and
- a processor configured to execute the set of instructions to cause the database system to:
- receive a database query on a database in the database system;
- determine one or more sets of adjacent columns accessed by the database query;
- and
- for each set of adjacent columns of one or more determined sets, prefetch data in the adjacent columns.
A non-transitory computer readable medium that stores a set of instructions that is executable by one or more processors of a database system to cause the database system to initiate a method comprising:
- receiving a database query on a database in the database system;
- determining one or more sets of adjacent columns accessed by the database query;
- and
- for each set of adjacent columns of the one or more determined sets, prefetching data in the adjacent columns.
Dependencies are inferred from the claim text.