SYSTEMS, METHODS, AND MEDIA FOR IMPROVING THE EFFECTIVENESS AND EFFICIENCY OF DATABASE QUERY OPTIMIZERS

Systems, methods, and media for measuring the effectiveness and efficiency of database query optimizers are provided. In some embodiments, a system is provided, comprising: memory storing instructions that, when executed, cause a processor to: submit a first database query; receive a runtime to exec...

Full description

Saved in:
Bibliographic Details
Main Authors CHERNIACK, Mitch, PAPAEMMANOUIL, Olga, LI, Zhan
Format Patent
LanguageEnglish
Published 07.05.2020
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:Systems, methods, and media for measuring the effectiveness and efficiency of database query optimizers are provided. In some embodiments, a system is provided, comprising: memory storing instructions that, when executed, cause a processor to: submit a first database query; receive a runtime to execute the first database query using a plan selected by a query optimizer; receive runtimes to execute the first database query using a plurality of test plans; determine, based on the runtimes, a metric indicative of the effectiveness of the query optimizer; and cause the metric indicative of the effectiveness of the query optimizer to be presented to a user.
Bibliography:Application Number: US201816617245