Vipul M Shah

US Patent:

6553369, Apr 22, 2003

Filed:

Mar 11, 1999

Appl. No.:

09/266703

Inventors:

Todd Guay - Nashua NH
Jonathan Soule - Belmont CA
Yong Feng - Foster City CA
Vipul Shah - Mountain View CA
Geoffrey Wilson - Nashua NH
Jay Rossiter - Palo Alto CA

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 3, 707 10, 709223, 709224, 709226, 705 7, 705 8, 705 9

Abstract:

An intelligent approach for performing administrative functions generally involves performing a set of administrative function steps within a âmaintenance windowâ that is defined by one or more specified time periods. First, a set of administrative function steps to be performed are identified. The set of administrative function steps is prioritized to produce a set of prioritized administrative function steps. Then, the set of prioritized administrative function steps is performed during the maintenance window. Aspects and features of the invention include: identifying and prioritizing administrative function steps; estimated function times and maintenance window; failure prediction; environment recommendations; history information and learning techniques; saving state and context information; and user feedback.

US Patent:

6766318, Jul 20, 2004

Filed:

Feb 13, 2003

Appl. No.:

10/366794

Inventors:

Todd Guay - Nashua NH
Jonathan Soule - Belmont CA
Yong Feng - Foster City CA
Vipul Shah - Mountain View CA
Geoffrey Wilson - Nashua NH
Jay Rossiter - Palo Alto CA

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 3, 707 10, 707100, 707102, 7071041

Abstract:

An intelligent approach for collecting statistical information in information systems generally involves performing a set of administrative function steps within a âmaintenance windowâ that is defined by one or more specified time periods. First, a set of administrative function steps to be performed are identified. The set of administrative function steps is prioritized to produce a set of prioritized administrative function steps. Then, the set of prioritized administrative function steps is performed during the maintenance window. Aspects and features of the invention include: identifying and prioritizing administrative function steps; estimated function times and maintenance window; failure prediction; environment recommendations; history information and learning techniques; saving state and context information; and user feedback.

US Patent:

6374257, Apr 16, 2002

Filed:

Jun 16, 1999

Appl. No.:

09/334362

Inventors:

Todd Guay - Nashua NH
Vipul Shah - Mountain View CA
Jonathan Soule - Belmont CA
Yao Feng - Belmont CA

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707103R, 707 4, 707101, 707102

Abstract:

A method and apparatus for identifying one or more schemas from which a Structured Query Language (SQL) statement may have been executed is provided. According to the method, to identify schemas from which a database command may have been executed a set of object references that are included in the database command is determined. From the set of object references, one or more ambiguous object references that are contained in the set of object references are identified. A set of one or more schemas that contain objects that correspond to each of the one or more ambiguous object references is then identified. In one aspect, the step of identifying the one or more ambiguous object references includes the steps of identifying any qualified object references from the set of object references that is associated with a schema identifier that identifies a particular schema for which the qualified object reference is to execute; identifying any public synonyms from the set of object references that represents an alias that may be used in multiple schemas to identified a single object; and determining the one or more ambiguous object references by selecting from the set of object references only those object references that have not been identified as either qualified object references or public synonyms.