Query Optimization with Memory I/O Awareness
AssigneeSybase, Inc.
InventorsRamanujam Seshadri Halasipuram, Edwin Anthony Seputis
Life of this patent
Estimating the term…
Abstract
System, method, computer program product embodiments and combinations and sub-combinations thereof for tuning query execution performance in a database management system are described. In an aspect, query optimization in a database management system (DBMS) with memory I/O (input/output) awareness includes determining compensated physical I/O (PIO) values indicative of memory I/O operations, including an approximate cache occupancy level, of an executing query in a DBMS, and utilizing the compensated PIO values as feedback to a query optimizer of the DBMS for optimization of future query execution.
Claims19
A computer-implemented method for query optimization in a database management system (DBMS) with memory I/O (input/output) awareness, the method comprising:
- determining compensated physical I/O (PIO) values indicative of memory I/O operations, including an approximate cache occupancy level, of an executing query in a DBMS;
- and
- utilizing the compensated PIO values as feedback to a query optimizer of the DBMS for optimization of future queries.
A system for query optimization in a database management system (DBMS) with memory I/O (input/output) awareness, the system comprising:
- a. storage means;
- b. processing means coupled to the storage means;
- and
- c. database management means coupled to the storage means and controlled by the processing means, the database management means determining compensated physical I/O (PIO) values indicative of memory I/O (input/output) operations of an executing query on the storage means and utilizing the compensated PIO values as feedback for optimization of future queries.
A computer program product having control logic stored therein, said control logic enabling a processor to perform query optimization in a database management system (DBMS) with memory I/O (input/output) awareness, said control logic comprising:
- first computer readable program code means for enabling a processor to determine compensated physical I/O (PIO) values indicative of memory I/O (input/output) operations, including an approximate cache occupancy level, of an executing query in a DBMS;
- and
- second computer readable program code means for enabling a processor to provide the compensated PIO values as feedback to a query optimizer of the DBMS for optimization of future query execution.
Dependencies are inferred from the claim text.