Invention Grant
- Patent Title: Systems, methods, and media for improving the effectiveness and efficiency of database query optimizers
-
Application No.: US16617245Application Date: 2018-06-01
-
Publication No.: US11327967B2Publication Date: 2022-05-10
- Inventor: Olga Papaemmanouil , Mitch Cherniack , Zhan Li
- Applicant: BRANDEIS UNIVERSITY
- Applicant Address: US MA Waltham
- Assignee: BRANDEIS UNIVERSITY
- Current Assignee: BRANDEIS UNIVERSITY
- Current Assignee Address: US MA Waltham
- Agency: Quarles & Brady LLP
- International Application: PCT/US2018/035624 WO 20180601
- International Announcement: WO2018/223010 WO 20181206
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F16/21

Abstract:
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.
Information query