Modified query execution plans in hybrid memory systems for in-memory databases
AssigneeSap SE
InventorAhmad Hassan
Life of this patent
Estimating the term…
Abstract
Implementations of the present disclosure include methods, systems, and computer-readable storage mediums for receiving a query from an application, processing a query execution plan (QEP) of the query using a cache simulator to simulate queries to an in-memory database in a hybrid memory system, providing a miss-curve based on the QEP, the miss-curve relating miss-ratios to memory sizes, and determining relative sizes of a first type of memory and a second type of memory in the hybrid memory system at least partially based on the miss-curve.
Claims20
A computer-implemented method executed by one or more processors, the method comprising:
- receiving, by the one or more processors, a query from an application;
- processing, by the one or more processors, a query execution plan (QEP) of the query using a cache simulator to simulate queries to an in-memory database in a hybrid memory system;
- providing, by the one or more processors, a miss-curve based on the QEP, the miss-curve relating miss-ratios to memory sizes;
- and
- determining relative sizes of a first type of memory and a second type of memory in the hybrid memory system at least partially based on the miss-curve.
A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
- receiving a query from an application;
- processing a query execution plan (QEP) of the query using a cache simulator to simulate queries to an in-memory database in a hybrid memory system;
- providing a miss-curve based on the QEP, the miss-curve relating miss-ratios to memory sizes;
- and
- determining relative sizes of a first type of memory and a second type of memory in the hybrid memory system at least partially based on the miss-curve.
A system, comprising:
- a computing device;
- and
- a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations comprising:
- receiving a query from an application;
- processing a query execution plan (QEP) of the query using a cache simulator to simulate queries to an in-memory database in a hybrid memory system;
- providing a miss-curve based on the QEP, the miss-curve relating miss-ratios to memory sizes;
- and
- determining relative sizes of a first type of memory and a second type of memory in the hybrid memory system at least partially based on the miss-curve.
Dependencies are inferred from the claim text.