Todd P Guay, 6110 N London Dr, Nashua, NH 03062

6374257, Apr 16, 2002

Jun 16, 1999

09/334362

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

Oracle Corporation - Redwood Shores CA

G06F 1730

707103R, 707 4, 707101, 707102

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.

6553369, Apr 22, 2003

Mar 11, 1999

09/266703

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

Oracle Corporation - Redwood Shores CA

G06F 1730

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

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.

6598038, Jul 22, 2003

Sep 17, 1999

09/398616

Todd Guay - Nashua NH
Gregory Smith - Merrimack NH
Geoffrey Wilson - Amherst NH
Jay Rossiter - Palo Alto CA

Oracle International Corporation - Redwood Shores CA

G06F 1730

707 2, 707 10, 707101, 707205

A workload reduction mechanism for index tuning is described that selects relevant database statements from a database workload, standardizes a format of the relevant database statements and reduces the formatted, relevant database statements into a representative set of database statements. These statements may then be provided to an index tuning mechanism.

6766318, Jul 20, 2004

Feb 13, 2003

10/366794

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

Oracle International Corporation - Redwood Shores CA

G06F 1730

707 3, 707 10, 707100, 707102, 7071041

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.

7272589, Sep 18, 2007

Nov 1, 2000

09/703909

Todd P. Guay - Nashua NH, US
Gregory S. Smith - Merrimack NH, US
Ari W. Mozes - San Carlos CA, US
Gaylen D. Royal - Bedford NH, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707 2, 707 3, 707 4, 707 5

A method evaluates a plurality of candidate index sets for a workload of database statements in a database system by first generating baseline statistics for each statement in the workload. An index superset is formed by combining an existing or current index set and a proposed index set. A candidate index set is derived from the index superset, the candidate index being one of the plurality of candidate index sets. Statistics for a statement are generated by first creating an execution plan which represents an efficient series of steps for executing the statement given the candidate index set. The execution plan is evaluated, and statistics based on the evaluation of the execution plan are generated and recorded. The cost of the execution plan is then determined and statistics are generated. Statistics for each candidate index set are rolled up and presented to a user or an index tuning mechanism.

2005007, Apr 7, 2005

Oct 3, 2003

10/678800

Todd Guay - Nashua NH, US
Dimitris Nakos - Palo Alto CA, US

G06F017/30

707200000

Techniques for making aggregated entries in a database table which aggregate information from other entries in tables in the database system. The techniques permit the aggregated entries to contain not only metric values aggregated from the other entries by techniques such as averaging in which the individual values are lost, but also sets of individual values from the other entries. One area of application for the techniques is the roll up tables used in the management systems for database management systems to reduce the size of historic information about events that have occurred in the database management system. Each roll up entry in a roll up table is an aggregated entry that contains information about some number of events. A roll up entry that uses the techniques contains a representation of a set whose values are the occurrence times of the events that are represented by the rollup record. Among the techniques that can be used to represent the set of occurrence times are a comma list of the occurrence times and a bit map which has a bit for each second in a day. Roll up entries that contain such representations of sets of occurrence times may be analyzed to determine whether occurrences of events are related, and if they are, the fact of the relationship can be used to design filters that can be applied in the roll up process, in error reporting, and in the analysis of the roll up tables.

5907844, May 25, 1999

Mar 20, 1997

8/821387

Todd Guay - Nashua NH
Gregory Smith - Nashua NH

Oracle Corporation - Redwood Shores CA

G06F 1730

707100

A method for providing persistent, dynamic external control of rule-based decision making through inherited user defined rules (UDRs) within a computer controlled relational database management system (RDBMs). Within the novel system, objects are grouped together in a parent-child hierarchy where a child has one parent and each parent can have multiple children. Each object can have one or more pre-defined ("hardcoded") rules associated with it; these hardcoded rules are executed in a sequence to arrive at parameter values which, when applied, tune the database environment. The novel system provides a mechanism for creating UDRs which are associated with a particular object and used by particular hardcoded rules which process the particular object. For a given hardcoded rule, if a processed object does not have a UDR defined within, then a search is made up the object's ancestry (e. g. , its parentage) until a defined UDR is located within an ancestor object; this value is then used to modify the behavior of the hardcoded rule.

5852818, Dec 22, 1998

Dec 23, 1996

8/772298

Todd Guay - Nashua NH
Gregory Smith - Nashua NH
Geoffrey Wilson - Nashua NH
Gaylen Royal - Bedford NH
Jonathan Riel - Nashua NH

Oracle Corporation - Redwood Shores CA

G06F 1730

707 1

A method for non-recursive data driven parameter evaluation within an information management system (e. g. , a relational database management system, RDBMS). Parameters are attributes within an RDBMS system whose value can be modified to influence the manner in which a database environment responds. Depending on the character of the data within a database environment or the hardware resources allocated to the database, the parameter values have a large influence on the performance efficiency of the database. For instance, a parameter value may influence the memory size of certain data storage areas within a database environment and, if set too small, can cause an inefficiently large amount of input/output accesses to occur as data is moved in and out of disk storage. Also, many parameters are data dependent on other parameters. The novel system presents an automated system for evaluating parameters using a non-recursive evaluation process.