Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-06-05
1998-06-02
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707 3, 707 4, 707101, G06F 1730
Patent
active
057616540
ABSTRACT:
A method of constructing an aid to tuning of database statements comprises a data structure (stored in a memory on a computer system) which compactly represents that information which is needed about a database statement to determine the optimal series of operations (e.g., table data fetches) needed to execute the statement. The information includes the relationships between tables joined in the statement and the selectivities of logical conditions applied to rows in those tables.
REFERENCES:
patent: 5276870 (1994-01-01), Shan et al.
patent: 5495605 (1996-02-01), Cadot
patent: 5546570 (1996-08-01), McPherson, Jr. et al.
patent: 5546571 (1996-08-01), Shan et al.
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5548755 (1996-08-01), Leung et al.
patent: 5574900 (1996-11-01), Huang et al.
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5608904 (1997-03-01), Chaudhuri et al.
patent: 5619692 (1997-04-01), Malkemus et al.
patent: 5625813 (1997-04-01), Venn
patent: 5630120 (1997-05-01), Vachey
Advertisement: "Operation SQL> Storm," Oracle Integrator, May/Jun. 1995; vol. 7, No. 3, p. 36.
Black Thomas G.
Homere Jean R.
Oracle Corporation
LandOfFree
Memory structure and method for tuning a database statement usin does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Memory structure and method for tuning a database statement usin, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Memory structure and method for tuning a database statement usin will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1474158