JAMES HYDE GRAY, II
Pilots at Coolbrook Ave, Phoenix, AZ

6353821, Mar 5, 2002

Dec 23, 1999

09/472362

James E. Gray - Phoenix AZ

Bull HN Information Systems Inc. - Billerica MA

G06F 1730

707 2, 707 3

A database management optimizer detects patterns in SQL that occur when search conditions are present that represent ranges of values across multiple columns of a table. These patterns are recognized and translated into simpler key value ranges that can be used to provide more efficient use of database indexes.

4342387, Aug 3, 1982

Apr 28, 1977

5/791961

James H. Gray - Phoenix AZ

Research Associates, Ltd. - Phoenix AZ

B65G 2510

198746

A method and an apparatus for linearly conveying wheeled vehicles are disclosed wherein at least one wheel of the vehicle is supported by a plate which reciprocates longitudinally through a forward stroke and a reverse stroke. The supported wheel is engaged and blocked to prevent its rotation during the forward stroke, thereby pushing the wheel, and thus the vehicle, to a forward position with the plate. During the reverse stroke, the wheel is free to rotate, permitting the plate to return to its rearmost position while the wheel remains at the forward position. During subsequent forward strokes, the wheel is similarly engaged and blocked and the vehicle is sequentially advanced the length of the forward stroke during each reciprocation of the plate. The means for blocking the supported wheel during the forward stroke are selectively displaced to prevent displacement of the vehicle except on command from the conveyor operator.

5758335, May 26, 1998

Sep 27, 1996

8/722825

James E. Gray - Phoenix AZ

Bull HN Information Systems Inc. - Billerica MA

G06F 1730

707 2

A method for improving the efficiency of queries in relational database management systems that use the exhaustive method of query optimization. The join structure of the query is examined prior to query optimization and tables are ordered according to graph theory. The tables in the FROM clause of the query are then reordered before query optimization. The access plan is thus developed from an already near-optimal table ordering. As a result, the number of table permutations examined during query optimization is pruned, the time to examining large numbers of table order permutations is avoided, and the optimization cost is reduced.

4039075, Aug 2, 1977

May 9, 1975

5/576169

James Harrel Gray - Phoenix AZ

B65G 2504

198746

A method and an apparatus for linearly conveying wheeled vehicles are disclosed wherein at least one wheel of the vehicle is supported by a plate which reciprocates longitudinally through a forward stroke and a reverse stroke. The supported wheel is engaged and blocked to prevent its rotation during the forward stroke, thereby pushing the wheel, and thus the vehicle, to a forward position with the plate. During the reverse stroke, the wheel is free to rotate, permitting the plate to return to its rearmost position while the wheel remains at the forward position. During subsequent forward strokes, the wheel is similarly engaged and blocked and the vehicle is sequentially advanced the length of the forward stroke during each reciprocation of the plate.

4007053, Feb 8, 1977

Sep 8, 1975

5/611279

James H. Gray - Phoenix AZ

Cyprus Specialty Steel - Phoenix AZ

B08B 102

134 6

The system disclosed is a brushing installation for use in scrubbing the front, rear and sides of a motor vehicle. A pair of front/side brushes and a pair of side/rear brushes provide double coverage of these surfaces during a single passage of the vehicle. The brushes are suspended from short, side-mounted pivot arms and displacement of the brushes during operation is a function of vehicle position relative to the brushing installation.