Patent ID: 9002827
Filing Date: 2015-04-07
Classification: G06F

Abstract:
1. A computerized method of evaluating and modifying a database data request, the method comprising: receiving a data request identifying data to retrieve from two or more database table columns from two or more database tables, the data request received as a Structured Query Language (SQL) statement; building, by executing instructions on a computer processor, a list in a memory device of all database tables specified in the data request; for each column in the data request, identifying each table from the list of all tables within which the column is present; determining if any of the identified tables are highly utilized tables; identifying a least number of one or more non-highly utilized tables that together include all of the columns of the data request; and modifying the SQL statement of the data request by changing the table of one or more of the columns in the received data request to use a least number of highly utilized tables possible.