Aravind Yalamanchi

6708178, Mar 16, 2004

Jun 4, 2001

09/871720

Eugene I. Chong - Concord MA
Souripriya Das - Nashua NH
Charles G. Freiwald - Amherst NH
Jagannathan Srinivasan - Nashua NH
Aravind Yalamanchi - Nashua NH

Oracle International Corporation - Redwood Shores CA

G06F 1730

707101, 707102

A system for organizing and accessing a database. The system includes a primary B+tree index, a secondary B+tree index, a plurality of mapping table row identifiers stored in the secondary B+tree index and a plurality of database addresses for leaf blocks of the primary B+tree index corresponding to mapping table rows.

6826563, Nov 30, 2004

May 29, 2001

09/865599

Eugene I. Chong - Concord MA
Jagannathan Srinivasan - Nashua NH
Souripriya Das - Nashua NH
Charles G. Freiwald - Amherst NH
Aravind Yalamanchi - Nashua NH

Oracle International Corporation - Redwood Shores CA

G06F 1730

707 4, 707 3

A method for building bitmap indexes on a primary B+tree used for storing data in the database that has a mapping table associated with it. The bitmap index is built by using the mapping table row identifiers.

6859808, Feb 22, 2005

May 31, 2001

09/867678

Eugene I. Chong - Concord MA, US
Jagannathan Srinivasan - Nashua NH, US
Souripriya Das - Nashua NH, US
Charles G. Freiwald - Amherst NH, US
Aravind Yalamanchi - Nashua NH, US
Mahesh Jagannath - Burlington MA, US
Anh-Tuan Tran - Vacaville CA, US
Ramkumar Krishnan - Nashua NH, US

Oracle International Corporation - Redwood Shores CA

G06F017/30

707101, 707102, 707 3

A mapping mechanism for a primary B+tree in a database management system. The primary B+tree includes a plurality of rows. The mapping mechanism includes introducing a mapping table that includes a plurality of rows, including a row for each row of the primary B+tree, and that stores the logical identifier of the corresponding primary B+tree row. In addition, reverse mapping is provided by augmenting a primary B+tree to include in each primary B+tree row a physical row identifier of the corresponding mapping table row. An auxiliary structure created on a primary B+tree can make use of the proposed mapping mechanism. Specifically, the auxiliary structures refers to primary B+tree rows indirectly by storing the physical row identifier of the corresponding mapping table row.

7054872, May 30, 2006

May 29, 2001

09/865598

Souripriya Das - Nashua NH, US
Aravind Yalamanchi - Nashua NH, US
Eugene I. Chong - Concord MA, US
Jagannathan Srinivasan - Nashua NH, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707100

A method for maintaining a system for database management. The method includes recording the addresses of newly created leaf blocks during a split operation on a primary B+tree and maintaining the new addresses in a list as part of primary B+tree metadata.

7107282, Sep 12, 2006

Feb 12, 2003

10/365771

Aravind Yalamanchi - Nashua NH, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707102

First data that represents a level associated with an element within an expression, such as an XPath expression, is generated from the expression, and stored in one or more columns of a table. Second data that represents a condition on an attribute of the element is generated from the expression, and stored in one or more columns of the same or a different table. A plurality of expressions can be processed as such, and a determination made whether any of the expressions match with a given hierarchical data item, such as an XML document, that includes a value that corresponds to an attribute that is associated with an element that resides at a particular level within the data item. Such determination is made based on whether the particular level matches the first data and the value satisfies the second data associated with a given expression.

7127467, Oct 24, 2006

Sep 24, 2002

10/254383

Aravind Yalamanchi - Nashua NH, US
Dieter Gawlick - Palo Alto CA, US
Jagannathan Srinivasan - Nashua NH, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707102

A method for managing expressions includes receiving a first query that includes a first conditional expression. The first expression is then represented as data in a column of a table. A second query is received that specifies a first set of criteria, and the second query is executed to select data based at least on whether expressions in the column satisfy the first set of criteria. In an embodiment, the second query further specifies a second set of criteria, wherein executing the second query includes selecting data based on whether data in columns other than the expression column satisfy the second criteria. A special index is defined, which can be created on the column that stores the expressions as data, to filter large sets of expressions efficiently. A method of evaluating an expression set stored as data in a table classifies each predicate from each expression, and filters the expression set based on the predicate classification.

7567975, Jul 28, 2009

Mar 16, 2005

11/083159

Aravind Yalamanchi - Nashua NH, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00

707102, 707100

In the scenario in which a rule set is defined for composite events, instances of the associated primitive events are added to a database-centric rules engine one at a time. Rules that rely on these events fire the corresponding actions when instances of all the corresponding primitive events are detected. Intermediate states of the rule evaluations are persistently stored in the database, thereby avoiding repeated evaluation of portions of rules and supporting efficient incremental evaluation of the rules. The rules defined within a rule set could vary significantly, using various rule condition language constructs such as “any” and negation constructs. The state information generated from evaluating the rules belonging to a single rule set is all stored in a single relational table and managed using direct SQL and DML commands.

7590650, Sep 15, 2009

May 26, 2006

11/441622

Aravind Yalamanchi - Nashua NH, US

Oracle International Corporation - Redwood Shores CA

G06F 17/30

707102

First data that represents a level associated with an element within an expression, such as an XPath expression, is generated from the expression, and stored in one or more columns of a table. Second data that represents a condition on an attribute of the element is generated from the expression, and stored in one or more columns of the same or a different table. A plurality of expressions can be processed as such, and a determination made whether any of the expressions match with a given hierarchical data item, such as an XML document, that includes a value that corresponds to an attribute that is associated with an element that resides at a particular level within the data item. Such determination is made based on whether the particular level matches the first data and the value satisfies the second data associated with a given expression.