Optimizer for use in a data base system

Details Optimizer for use in a data base system Optimizer for use in a data base system

G - Physics

06

F

354/34

G06F 15/00 (2006.01)

Patent

CA 1270061

ABSTRACT An optimizer-code generator for use in a data base system. The optimizer-code generator employs a component called a scan analyzer for performing implementation-dependent analysis and providing implementation-dependent query code. The optimizer-code generator receives a query in logical tree form. It first- optimizes the logical tree. In so doing, it provides infor- mation from the logical tree to the scan analyzer, which specifies what methods are available for accessing informa- tion required for the query and what each of the available methods costs. The optimizer-code generator uses the cost information in its optimization of the logical tree and specifies the access methods to be used in the logical tree. The code generator then uses the logical tree to generate query code. In so doing, it provides the specifications of the access methods to the scan analyzer, which returns query code for the access method. The code generator then incor- porates the query code for the access method in the query code which it generates from the logical tree.

490358

Affiliated with

Also associated with

Rating

Optimizer for use in a data base system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimizer for use in a data base system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizer for use in a data base system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1273099