Presenting query plans of a database system

Details Presenting query plans of a database system Presenting query plans of a database system

2007-06-19

2007-06-19

Lo, Weilun (Department: 2179)

Data processing: presentation processing of document, operator i

Operator interface

Help presentation

C715S853000, C715S965000

Reexamination Certificate

active

09796289

ABSTRACT:
An execution plan of a query for a parallel database system is determined. In one arrangement, the parallel database system is a relational database management system. The execution plan of the query is determined by an optimizer program. Execution plans are inserted into one or more explain tables that are accessible by a visual explain and compare module to display the steps of the execution plan in a graphical user interface. Parallel execution of steps of the execution plan can be depicted in the graphical user interface. Further, plural execution plans for a given query under different conditions may be compared.

REFERENCES:
patent: 4937036 (1990-06-01), Beard et al.
patent: 5303383 (1994-04-01), Neches et al.
patent: 5640584 (1997-06-01), Kandasamy et al.
patent: 5844554 (1998-12-01), Geller et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5872904 (1999-02-01), McMillen et al.
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 5966712 (1999-10-01), Sabatini et al.
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6414307 (2000-07-01), Jones et al.
patent: 2002/0070953 (2002-06-01), Barg et al.
Oracle Corporation, “SQL Language: Reference Manual, Version 6.0,” pp. 5-1 to 5-5, 5-96 to 5-97 (1990).
D.D. Chamberlin et al., “Views, Authorization, and Locking in a Relational Data Base System,” National Computer Conference, pp. 425-430 (1975).
D.D. Chamberlin et al., “Sequel 2: A Unified Approach to Data Definition, Manipulation, and Control,” IBM Journal of Research and Development, vol. 20, pp. 560-575 (Nov. 1976).
M.W. Blasgen et al., “On the Evaluation of Queries in a Relational Data Base System,” IBM Research Report RJ 1745, pp. 1-44 (Apr. 1976).
M.W. Blasgen et al., “Storage and Access in Relational Data Bases,” IBM Systems Journal, No. 4, pp. 363-377 (1977).
P. Griffiths Selinger et al., ACM, “Access Path Selection in a Relational Database Management System,” pp. 23-34 (1979).
Masaru Kitsuregawa et al., Institute of Industrial Science, University of Tokyo, “Query Execution for Large Relations on Functional Disk System,” pp. 159-167 (1989).
Eugene Wong et al., ACM Transactions on Database Systems, vol. 1, No. 3, “Decomposition-A Strategy for Query Processing,” pp. 223-241 (Sep. 1976).

Affiliated with

Also associated with

Rating

Presenting query plans of a database 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 Presenting query plans of a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Presenting query plans of a database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3870814