Database query code generation and optimization based on the cos

Details Database query code generation and optimization based on the cos Database query code generation and optimization based on the cos

1984-05-25

1989-05-09

Zache, Raulfe B.

Boots, shoes, and leggings

364200, G06F 1500

Patent

active

048294276

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 information from the logical tree to the scan analyzer, which specifies what methods are available for accessing information 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 incorporates the query code for the access method in the query code which it generates from the logical tree.

REFERENCES:
patent: 3906455 (1975-09-01), Houston et al.
patent: 3916387 (1975-10-01), Woodrum
patent: 4130867 (1978-12-01), Bachman et al.
patent: 4384325 (1983-03-01), Slechta, Jr. et al.
patent: 4468728 (1984-08-01), Wang
patent: 4497039 (1985-01-01), Kitakami et al.
patent: 4504907 (1985-03-01), Manning et al.
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4531186 (1985-07-01), Knapman

Affiliated with

Also associated with

Rating

Database query code generation and optimization based on the cos does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database query code generation and optimization based on the cos, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database query code generation and optimization based on the cos will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-94001