Nipun Te Agarwal

US Patent:

6351742, Feb 26, 2002

Filed:

Mar 18, 1999

Appl. No.:

09/272627

Inventors:

Nipun Agarwal - San Mateo CA
Dinesh Das - Redwood City CA
Jagannathan Srinivasan - New Hampshire CT

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 3, 2 4, 2 5, 2 6

Abstract:

A method and system for optimizing the execution of database statements are described. An aspect is directed to the generation of an execution plan for a database statement, wherein the database statement contains a predicate having one or more arguments whose values are not known at the time the execution plan is generated (e. g. , at compile time). A feature of this aspect involves passing a description of the argument(s) to the optimizer. An example of such a description includes the argument type of the predicate argument.

US Patent:

6370522, Apr 9, 2002

Filed:

Mar 18, 1999

Appl. No.:

09/272691

Inventors:

Nipun Agarwal - San Mateo CA
Dinesh Das - Redwood City CA
Viswanathan Krishnamurthy - Fremont CA
Ravi Murthy - Foster City CA
Anil Nori - San Jose CA
Jagannathan Srinivasan - New Hampshire CT

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 2, 707 3

Abstract:

A method and system for optimizing the execution of database statement is described. An aspect is related to providing a framework for the creation, association, and use of optimizer-related functions to calculate the cost of execution plans involving non-native database entities. Examples of these optimizer-related functions include selectivity, statistics, and costs functions. Another aspect is related to the optimization of database statements having non-boolean predicates. Yet another aspect is related to the determination and use of different granularity levels of information for submitting database statement predicates to optimizer-related functions. Optimizer-related functions can also be defined for system-supplied objects and entities.

US Patent:

6401083, Jun 4, 2002

Filed:

Mar 18, 1999

Appl. No.:

09/275896

Inventors:

Nipun Agarwal - San Mateo CA
Viswanathan Krishnamurthy - Fremont CA
Jagannathan Srinivasan - New Hampshire CT

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 2, 707 1, 707 3

Abstract:

A method and system for associating properties in a computer system is described. An aspect relates to a mechanism for dynamically determining the value of a property for an instance or object, which can override the property defined for the class or object type. Another aspect relates to a mechanism for dynamically changing at run-time the set of properties associated with system structures, such as classes, object types, instances, or objects. Yet another aspect relates to a mechanism that can associate or disassociate an entire set of properties at the same time, rather than having to separately associate or disassociate each property within a set of properties. A further aspect relates to a mechanism for allowing particular instances or objects to explicitly not inherit properties of its familial class or object type.

US Patent:

6421666, Jul 16, 2002

Filed:

Nov 8, 1999

Appl. No.:

09/436046

Inventors:

Ravi Murthy - Foster City CA
Jagannathan Srinivasan - Nashua NH
Nipun Agarwal - Santa Clara CA

Assignee:

Oracle Corporation - Redwood Shores CA

International Classification:

G06F 700

US Classification:

707 3

Abstract:

A method and apparatus are provided for accessing ancillary data, and for generating and accessing ancillary data more efficiently. Ancillary data is generated during execution of the operator routine of a primary operator. The ancillary data is stored in a shared content and may be accessed through ancillary operators associated with the primary operator. Metadata is used to define a primary operator and ancillary operators associated with the primary operator. A DBMS, for example, receives a statement that includes a primary and at least one of its ancillary operators, and executes routines that implement the primary operator and the ancillary operator. During execution of the routine the implements the primary operator, ancillary data is generated and stored in shared content. During the execution of the routine that implements the ancillary operator, the ancillary data is retrieved from the shared content and is used. This mechanism enables efficient execution of a family of related functions over all the records in a dataset.

US Patent:

6738782, May 18, 2004

Filed:

Mar 11, 2002

Appl. No.:

10/096008

Inventors:

Nipun Agarwal - San Mateo CA
Dinesh Das - Redwood City CA
Viswanathan Krishnamurthy - Fremont CA
Ravi Murthy - Foster City CA
Anil Nori - San Jose CA
Jagannathan Srinivasan - New Hampshire CT

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707102, 707 3

Abstract:

A method and system for optimizing the execution of database statement is described. Optimization of database statements having non-boolean predicates is disclosed. Also disclosed is the determination and use of different granularity levels of information for submitting database statement predicates to optimizer-related functions.

US Patent:

6795817, Sep 21, 2004

Filed:

May 31, 2001

Appl. No.:

09/872670

Inventors:

Nipun Agarwal - Santa Clara CA
Ravi Murthy - Hayward CA

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 2, 707 7, 707 6

Abstract:

A method and mechanism to improve the response time of a query that is executed against a partitioned database object. Only a subset or portion of the partitions are accessed during each pass through the partitions, in which only the retrieved portions of the partitions are processed, and in which results can be immediately returned for the query. Processing only a subset of a partition in a given pass permits each partition to be processed multiple times, rather than requiring a first partition to be entirely processed before processing a second partition. In one approach, the query includes a statement to order the result set for a query against a partitioned database object that contains a local index.

US Patent:

6816853, Nov 9, 2004

Filed:

May 31, 2001

Appl. No.:

09/872887

Inventors:

Nipun Agarwal - Santa Clara CA
Ravi Murthy - Hayward CA
Jagannathan Srinivasan - Nashua NH

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 1730

US Classification:

707 3, 707 2, 707 6, 707102, 707103 R

Abstract:

A method and mechanism to execute a query against a partitioned database object. Data processed or created for an earlier partition is maintained even after further processing is performed against a subsequent partition. A shared data object, such as a context object, is maintained to store data from processing the partitions of a partitioned table. Rather than discarding or overwriting the shared data object after processing each partition, the data from a subsequent partition is instead appended to the shared data object.

US Patent:

6920460, Jul 19, 2005

Filed:

May 29, 2002

Appl. No.:

10/159360

Inventors:

Jagannathan Srinivasan - Nashua NH, US
Seema Sundara - Nashua NH, US
Nipun Agarwal - Santa Clara CA, US
Ying Hu - Nashua NH, US
Timothy Chorma - Nashua NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F017/30

US Classification:

707102

Abstract:

Domain indexes (indexes created and maintained by user-defined indexing schemes) are managed on partitioned database objects that store data using a system-managed approach. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. Partition maintenance operations are performed on both the database objects and the indexes by a system-supplied partition manager. Changes in the partition maintenance operations or partitioning methods supplied by the database management system do not affect user-supplied code which is provided by the user-defined indexing scheme. User-supplied code is therefore partition operation-unaware.