Optimization of database network traffic based upon data-use analysis

A method of processing a database query from a client in a client-server database management system, the method comprising:

• receiving a database query from a client;
• and
• responding to the database query by returning to the client only a subset of the data requested by the client in the database query based upon a usage statistic associated with the database query;
• wherein the method further comprises determining the subset of data to be returned to the client in response to the database query based upon the usage statistic, wherein the database query requests a plurality of columns from at least one row of data from a table stored in the database management system, wherein determining the subset of data to be returned to the client includes determining a subset of the plurality of columns to return for the at least one row of data, wherein the usage statistic is associated with which of the plurality of columns are likely to be used by the client, and wherein the subset of the plurality of columns includes only those columns likely to be used by the client.

A method of processing a database query from a client in a client-server database management system, the method comprising:

• receiving a database query from a client;
• and
• responding to the database query by returning to the client only a subset of the data requested by the client in the database query based upon a usage statistic associated with the database query;
• wherein the method further comprises determining the subset of data to be returned to the client in response to the database query based upon the usage statistic, wherein the database query requests a plurality of rows from a table stored in the database management system, wherein determining the subset of data to be returned to the client includes determining a subset of the plurality of rows to return, and wherein the usage statistic is associated with a number of rows actually used by a client in response to the database query during a prior execution of the database query, the method further comprising generating the usage statistic based upon the prior execution of the database query.

An apparatus, comprising:

• a memory;
• and
• program code resident in the memory and configured to respond to a database query from a client in a client-server database management system by returning to the client only a subset of the data requested by the client in the database query based upon a usage statistic associated with the database query such that less than all of the data requested by the client in the database query is returned to the client in response to the database query;
• wherein the program code is further configured to determine the subset of data to be returned to the client in response to the database query based upon the usage statistic, wherein the database query requests a plurality of columns from at least one row of data from a table stored in the database management system, wherein the program code is configured to determine the subset of data to be returned to the client by determining a subset of the plurality of columns to return for the at least one row of data, wherein the usage statistic is associated with which of the plurality of columns are likely to be used by the client, and wherein the subset of the plurality of columns includes only those columns likely to be used by the client.

An apparatus, comprising:

• a memory;
• and
• program code resident in the memory and configured to respond to a database query from a client in a client-server database management system by returning to the client only a subset of the data requested by the client in the database query based upon a usage statistic associated with the database query such that less than all of the data requested by the client in the database query is returned to the client in response to the database query;
• wherein the program code is further configured to determine the subset of data to be returned to the client in response to the database query based upon the usage statistic, wherein the database query requests a plurality of rows from a table stored in the database management system, wherein the program code is configured to determine the subset of data to be returned to the client by determining a subset of the plurality of rows to return, and wherein the usage statistic is associated with a number of rows actually used by a client in response to the database query during a prior execution of the database query, the program code further configured to generate the usage statistic based upon the prior execution of the database query.