System for prefetching data necessary to execute program...

Details System for prefetching data necessary to execute program... System for prefetching data necessary to execute program...

2006-12-07

2009-02-17

Ali, Mohammad (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07493318

ABSTRACT:
In order to improve the efficiency of execution of a program by prefetching data necessary to execute the program, a system is provided that causes a computer to execute a recursive query prior to a program being subjected to prefetching. This system detects from iterative processing in the program a query to generate a resultant table by selecting a record that satisfies a selection condition from a target table. The system generates an initial query to generate an initial table that includes values of variables that are set prior to starting the iterative processing in the program. Furthermore, the system generates a recursive query to generate the next intermediate table that is referred to in the next and later cycles of the iterative processing, in the recursive query corresponding to each cycle of the iterative processing that is sequentially performed, from an intermediate table that includes resultant tables generated by a target query in the preceding cycles of the iterative processing and the target table. Furthermore, the system generates a final query to generate a final table from the intermediate table sequentially generated by the recursive query.

REFERENCES:
patent: 2004-295458 (2004-10-01), None
Masaharu Murozumi, et al., Exposition of next generation standard “SQL99”—from relational to object relational, Interop Magazine, Japan, Softbank Publishing Corp., Dec. 1, 1999, vol. 9, No. 10, pp. 91-101.
Nagasuka et al., “High Speed Function of Batch Processing by Virtualizing Input-Output and Parallel Execution: PREST”, vol. 35, No. 5, May 1994, pp. 856-864.

Affiliated with

Also associated with

Rating

System for prefetching data necessary to execute program... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System for prefetching data necessary to execute program..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for prefetching data necessary to execute program... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4126540