Invention Grant
- Patent Title: Database query time estimator
-
Application No.: US15596203Application Date: 2017-05-16
-
Publication No.: US10599652B2Publication Date: 2020-03-24
- Inventor: Lokesh Dasam
- Applicant: Dell Products L. P.
- Applicant Address: US TX Round Rock
- Assignee: Dell Products, L.P.
- Current Assignee: Dell Products, L.P.
- Current Assignee Address: US TX Round Rock
- Agency: Campbell Stephenson LLP
- Agent Shiv S. Naimpally
- Main IPC: G06F16/2453
- IPC: G06F16/2453

Abstract:
A Database Query Time Estimator (DQTE) module as a run-time tool to estimate and display the total time to complete a database query while the query is executing. The DQTE module invokes a runtime algorithm to compute the set of rows or blocks in a database that will be resulted at each step of a query's execution plan. The DQTE module may optimize the current execution plan to create one or more parent-child processes and may assign tasks to these processes to monitor the progress of each step in the execution plan. The progress of the child processes is then rolled up to the root parent level to come up with a time value, which is the Estimated Time of Arrival (ETA) to complete the whole execution of the query. The DQTE module may read only the header information of the database objects for a complete snapshot of the object.
Public/Granted literature
- US20180336246A1 DATABASE QUERY TIME ESTIMATOR Public/Granted day:2018-11-22
Information query