Patent ID: 7493318

Claim:
A method in which a computer executes a recursive access instruction including an initial query instruction for generating an initial table, a recursive query instruction for sequentially generating individual intermediate tables, and a final query instruction for generating and outputting a final table formed from the individual intermediate tables, prior to executing a program subjected to prefetching to prefetch data necessary to execute the program from a database and supply the data to the program, comprising: a step of acquiring the program; a step of detecting a query instruction to select a record which satisfies a predetermined selection condition from a target table, and to generate a resultant table from the recursive query instruction as a target query instruction to be a prefetching target; an initial query instruction generating step of generating the initial query instruction; an iterative processing step for generating an intermediate table; a recursive query instruction generating step of generating an instruction for processing a recursive query corresponding to each iterative processing step, as a recursive query instruction; and a final query instruction generating step of generating the final query instruction, wherein in the initial query instruction generating step, an instruction for generating a table including a variable value, which is preset prior to a start of the iterative processing step in the program, as the initial table, is generated as the initial query instruction; in the recursive query instruction generating step, in each iterative processing step to be sequentially executed, the instruction for processing a recursive query generates a next intermediate table by selecting an intermediate table including a resultant table generated due to the target query instruction of a prior iterative processing step or therebefore, a column to be referred to by the target query instruction of next iterative processing and thereafter, and the record satisfying the selection condition, as the recursive query instruction; and in the final query instruction generating step, the instruction to select at least a portion of a column in the intermediate table that is sequentially generated due to the recursive query instruction is generated as the final query instruction.