Invention Grant
- Patent Title: Generation of an optimized query plan in a database system
-
Application No.: US16267608Application Date: 2019-02-05
-
Publication No.: US11977545B2Publication Date: 2024-05-07
- Inventor: George Kondiles , Jason Arnold
- Applicant: Ocient Inc.
- Applicant Address: US IL Chicago
- Assignee: Oclient Inc.
- Current Assignee: Oclient Inc.
- Current Assignee Address: US IL Chicago
- Agency: Garlick & Markison
- Agent Katherine C. Stuckman; Bruce E. Stuckman
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F3/06 ; G06F7/24 ; G06F9/4401 ; G06F9/50 ; G06F11/10 ; G06F12/0893 ; G06F12/109 ; G06F16/17 ; G06F16/22 ; G06F16/23 ; G06F16/242 ; G06F16/2455 ; G06F16/2457 ; G06F16/2458 ; G06F16/27 ; G06F16/901 ; H03M7/30 ; H04L67/10

Abstract:
A method includes receiving, by a first computing entity of a database system, a query request that is formatted in accordance with a generic query format. The method further includes generating, by the first computing entity, an initial query plan based on the query request and a query instruction set. The method further includes determining, by the first computing entity, storage parameters. The method further includes determining, by the first computing entity, processing resources for processing the query request based on the storage parameters. The method further includes generating, by the first computing entity, an optimized query plan from the initial query plan based on the storage parameters, the processing resources, and optimization tools. The method further includes sending, by the first computing entity, the optimized query plan to a second computing entity for distribution and execution of the optimized query plan.
Information query