Method to help in optimizing a query from a relational data base

Details Method to help in optimizing a query from a relational data base Method to help in optimizing a query from a relational data base

1993-09-29

1996-02-27

Black, Thomas G.

Boots, shoes, and leggings

395700, 395157, 364DIG1, 3642821, 3642805, 3642863, G06F 900, G06F 1500

Patent

active

054956056

ABSTRACT:
The method for help in optimizing a query (10) in a window (24) of a screen of a work station consists of forming a tree (26) representative of the execution plan of the query, representing the tree on the screen (25), making a syntactical analysis of the query in order to form a syntactical graph, comparing the elements of the tree with those of the graph, and completing the tree with elements contained only in the graph. The advantageous result is a method of syntactical analysis consisting of analyzing the function of the RDBMS in order to determine in particular the types of nodes of the syntactical graph and preferably the information associated with these type of nodes.

REFERENCES:
patent: 4769772 (1988-09-01), Dwyer
patent: 4829427 (1989-05-01), Green
patent: 4887218 (1989-12-01), Natarajan
patent: 5091852 (1992-02-01), Tsuchida et al.
patent: 5113354 (1992-05-01), Harper et al.
patent: 5195178 (1993-03-01), Krieger et al.
patent: 5307445 (1994-04-01), Dalal et al.
patent: 5317742 (1994-05-01), Bapat
patent: 5331554 (1994-07-01), Graham
patent: 5335345 (1994-08-01), Frieder et al.
patent: 5345585 (1994-09-01), Iyer et al.
Proceedings of the Fifth Int'l Conf. on Data Engineering Feb. 10, 1989 pp. 590-597 Ching Ooi et al. "Extending a DBMS for Geographic Applications".

Affiliated with

Also associated with

Rating

Method to help in optimizing a query from a relational data base does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method to help in optimizing a query from a relational data base, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method to help in optimizing a query from a relational data base will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1686066