Patent ID: 7979431

Claim:
A method for use in a data processing system which includes a presentation tier, a database tier, and a middle tier between the presentation and database tiers, wherein the presentation tier has a user interface, the database tier has a database, and the middle tier has an intelligent query language enhancer for modifying an original user query from the user interface with no further user interaction from a user after the user has provided the original user query via the user interface, the method comprising: receiving at the user interface an original user query from a user, wherein the original user query specifies a user requested dataset to be retrieved from the database; automatically at the intelligent query language enhancer, with no further user interaction after the user has provided the original user query via the user interface, modifying the original user query to provide a modified user query which specifies a subset of the user requested dataset; and executing at the intelligent query language enhancer the modified user query and not the original user query against the database to retrieve from the database only the subset of the user requested dataset and not the entire user requested dataset and thereby to reduce network traffic between the database in the database tier and the intelligent query language enhancer in the middle tier.