Database program acceleration

摘要

A method and system are provided to automatically generating structured query language (SQL) to accelerate program execution in a database. Analysis of a target program checks usage status of objects and field data, and to determine which columns and table of a database record are required for program access. The SQL is generated to return only necessary data based upon which columns of which tables of the database record are likely to be accessed by the program.