Apparatus and method for decomposing database queries for databa

Details Apparatus and method for decomposing database queries for databa Apparatus and method for decomposing database queries for databa

1994-01-31

1998-04-21

Black, Thomas G.

Boots, shoes, and leggings

3952002, 3952005, 39520006, 395840, 395477, 39542106, 39518209, 364DIG1, 3642821, 3642814, 3642824, G06F 1500, G06F 1730

Patent

active

057428069

ABSTRACT:
An improved system for database query processing by means of "query decomposition" intercepts database queries prior to processing by a database management system ("DBMS"). The system decomposes at least selected queries to generate multiple subqueries for application, in parallel, to the DBMS, in lieu of the intercepted query. Responses by the DBMS to the subqueries are assembled by the system to generate a final response. The system also provides improved methods and apparatus for storage and retrieval of records from a database utilizing the DBMS's cluster storage and index retrieval facilitates, in combination with a smaller-than-usual hash bucket size.

REFERENCES:
patent: 4860201 (1989-08-01), Stolfio et al.
patent: 4870568 (1989-09-01), Kahle et al.
patent: 4876643 (1989-10-01), Mc Neill et al.
patent: 4991087 (1991-02-01), Burkowski et al.
patent: 5060143 (1991-10-01), Lee
patent: 5121494 (1992-06-01), Dias et al.
patent: 5146540 (1992-09-01), Natarajan
patent: 5210870 (1993-05-01), Baum et al.
patent: 5379420 (1995-01-01), Ullner
patent: 5423037 (1995-06-01), Huasshod
patent: 5469354 (1995-11-01), Hatakeyama et al.
patent: 5495606 (1996-02-01), Borden et al.
Chen, Arbee L.P., "OuterJoin Optimization in Multi Database Systems", Bell Communication Research, IEEE, 1990, pp. 211-218.
Goetz Graefe, "Volcano, an Extensible and Parallel Query Evaluation System", University of Colorado at Boulder, CU-CS-481-90, Jul. 1990, pp. 1-44.

Affiliated with

Also associated with

Rating

Apparatus and method for decomposing database queries for databa does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for decomposing database queries for databa, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for decomposing database queries for databa will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2068064