Patent ID: 8290936
Filing Date: 2012-10-16
Classification: G06F

Abstract:
1. A computer implemented method comprising: selecting a FIRST INPUT/OUTPUT execution plan from a plurality of execution plans that has a lowest estimated execution time for finding a number of records that satisfy a query and are simultaneously viewable; executing the FIRST INPUT/OUTPUT execution plan for a first time period to create a FIRST INPUT/OUTPUT result set, wherein the executing the FIRST INPUT/OUTPUT execution plan comprises executing for the first time period that is before the second time period if a maximum time that the query is to execute minus a FIRST INPUT/OUTPUT estimated time of execution of the FIRST INPUT/OUTPUT execution plan is greater than a first threshold and the FIRST INPUT/OUTPUT estimated time is less than an ALL INPUT/OUTPUT estimated time of execution of the ALL INPUT/OUTPUT execution plan; wherein the executing the FIRST INPUT/OUTPUT execution plan further comprises if the maximum time expired and all records that satisfy the query are not found, continuing the executing the FIRST INPUT/OUTPUT execution plan if a number of records not found by the executing the FIRST INPUT/OUTPUT execution plan is less than a second threshold; wherein the executing the FIRST INPUT/OUTPUT execution plan further comprises if the maximum time expired, all records that satisfy the query are not found, and the number of records not found by the executing the FIRST INPUT/OUTPUT execution plan is greater than the second threshold, then continue the executing FIRST INPUT/OUTPUT execution plan if a user consents; selecting an ALL INPUT/OUTPUT execution plan from the plurality of execution plans that has a lowest estimated execution time for finding all records that satisfy the query; executing the ALL INPUT/OUTPUT execution plan for a second time period to create an ALL INPUT/OUTPUT result set, wherein the executing the ALL INPUT/OUTPUT execution plan further comprises executing the ALL INPUT/OUTPUT execution plan if the maximum time minus an elapsed time since the query was received is less than a third threshold; wherein the executing the ALL INPUT/OUTPUT execution plan further comprises if the maximum time expired and all records that satisfy the query are not found, then continue the executing the ALL INPUT/OUTPUT execution plan if a number of records not found by the executing the ALL INPUT/OUTPUT execution plan is less than a fourth threshold; wherein the executing the ALL INPUT/OUTPUT execution plan further comprises if the maximum time expired, all records that satisfy the query are not found, and the number of records not found by the executing the ALL INPUT/OUTPUT execution plan is greater than the fourth threshold, then continuing the executing the ALL INPUT/OUTPUT execution plan if the user consents; displaying the FIRST INPUT/OUTPUT result set if the FIRST INPUT/OUTPUT result set comprises more records than the ALL INPUT/OUTPUT result set; and displaying the ALL INPUT/OUTPUT result set if the ALL INPUT/OUTPUT result set comprises more records than the FIRST INPUT/OUTPUT result set.