Invention Grant
- Patent Title: System and method for optimizing large database management systems with multiple optimizers
-
Application No.: US15991192Application Date: 2018-05-29
-
Publication No.: US10747765B2Publication Date: 2020-08-18
- Inventor: Jason Arnold , George Kondiles
- Applicant: OCIENT INC.
- Applicant Address: US IL Chicago
- Assignee: OCIENT INC.
- Current Assignee: OCIENT INC.
- Current Assignee Address: US IL Chicago
- Agency: Garlick & Markison
- Agent Timothy W. Markison
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F16/00 ; G06F16/2453 ; G06F16/23 ; G06F16/901 ; G06F16/21 ; G06F16/2455

Abstract:
A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.
Public/Granted literature
- US20190034485A1 SYSTEM AND METHOD FOR OPTIMIZING LARGE DATABASE MANAGEMENT SYSTEMS WITH MULTIPLE OPTIMIZERS Public/Granted day:2019-01-31
Information query