Invention Grant
- Patent Title: Automated query tuning method, computer program product, and system for MPP database platform
-
Application No.: US16913822Application Date: 2020-06-26
-
Publication No.: US11657047B1Publication Date: 2023-05-23
- Inventor: Giri Babu Shivarathri
- Applicant: Giri Babu Shivarathri
- Applicant Address: US WA Issaquah
- Assignee: Giri Babu Shivarathri
- Current Assignee: Giri Babu Shivarathri
- Current Assignee Address: US WA Issaquah
- Agency: Plager Schack LLP
- Agent Mark H. Plager; Alexis J. Saenz
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2455 ; G06F11/30 ; G06F16/17 ; G06F11/34 ; G06F16/28

Abstract:
A method if improving the performance of any SQL query in a Massively Parallel Processing (MPP) database platform replicates a query and breaks the query down into its objects so that iterations of the query components may be analyzed for areas affecting performance. The method builds the query from the lowest part of the query (for example, a single database object may be used in the query) and rebuilds the query by iteratively adding more objects along with their related logic (joins, group by clause, select list, etc.). In each iteration, the process analyzes for the underlying causes of lower performance and fixes them.
Information query