Search

Rohan V Angrish

from Sunnyvale, CA
Age ~45

Rohan Angrish Phones & Addresses

  • 555 E Washington Ave APT 2314, Sunnyvale, CA 94086 (408) 735-8309
  • 555 Washington Ave, Sunnyvale, CA 94086
  • 808 Salt Ct, Redwood City, CA 94065
  • 204 Canoe Ct, Redwood City, CA 94065
  • Stanford, CA
  • 555 E Washington Ave APT 2314, Sunnyvale, CA 94086

Industries

Computer Software

Resumes

Resumes

Rohan Angrish Photo 1

Rohan Angrish

View page
Location:
Mumbai, Maharashtra, India
Industry:
Computer Software

Publications

Us Patents

Techniques For Partial Rewrite Of Xpath Queries In A Relational Database

View page
US Patent:
7386568, Jun 10, 2008
Filed:
Nov 8, 2004
Appl. No.:
10/984471
Inventors:
James W. Warner - Mountain View CA, US
Zhen Hua Liu - San Mateo CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Anand Manikutty - Foster City CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707102
Abstract:
Techniques are described for executing queries that have XPath sections that specify unmappable paths. The techniques involve splitting the unmappable paths into (1) a mappable path fragment, and (2) an unmappable path fragment. After an unmappable path has been split into a mappable path fragment and an unmappable path fragment, the XPath section is replaced with a replacement XPath section. The replacement XPath section specifies two operations: a “mappable operation” that is based on the mappable path fragment, and an “unmappable operation” that is based on the unmappable path fragment. The portion of the replacement XPath section that specifies the mappable operation is rewritten to access underlying relational structures. Consequently, when the rewritten query is executed, a smaller amount of XML data needs to be materialized to evaluate the unmappable path fragment than would otherwise have been required to evaluate the original unmappable path.

Techniques For Efficiently Storing And Querying In A Relational Database, Xml Documents Conforming To Schemas That Contain Cyclic Constructs

View page
US Patent:
7523131, Apr 21, 2009
Filed:
Feb 10, 2005
Appl. No.:
11/056312
Inventors:
James W. Warner - Mountain View CA, US
Abhyudaya Agrawal - San Francisco CA, US
Hui Zhang - Fremont CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Ravi Murthy - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Nipun Agarwal - Santa Clara CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Anand Manikutty - Foster City CA, US
Rohan Angrish - Redwood City CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/00
US Classification:
707102, 707 4, 715234
Abstract:
To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.

Optimization Of Queries Over Xml Views That Are Based On Union All Operators

View page
US Patent:
7685150, Mar 23, 2010
Filed:
Sep 27, 2005
Appl. No.:
11/237286
Inventors:
Anand Manikutty - Foster City CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Vikas Arora - San Francisco CA, US
James W. Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Hui Zhang - Fremont CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707102
Abstract:
Optimization is provided for database statements involving XML data, e. g. , XPath and XQuery, which operate over views that use aggregate set operators, e. g. , UNION ALL. As part of a “view merge” stage of query transformation, the query that operates over the view is merged with a query that defines the view. One or more expressions (e. g. , operators, predicates, virtual table constructs) from the query that operates over the view are then “pushed down” to operate on the individual underlying XML data constructs. “Branch elimination” is performed based on the structure of the view and the query acting over the view, based on which it is possible to determine whether any of the sub-queries, if executed, would result in the return of zero rows. If so, then such branches are eliminated from the transformed query, leaving a reduced set of data containers on which to execute the query.

Techniques For Providing Xquery Access Using Web Services

View page
US Patent:
7908286, Mar 15, 2011
Filed:
Dec 8, 2004
Appl. No.:
11/007894
Inventors:
Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Karuna Muthiah - Redwood City CA, US
Ying Lu - Sunnyvale CA, US
James W. Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Anand Manikutty - Foster City CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707759, 717159
Abstract:
An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

Mapping Web Services Description Language Documents To Xquery Functions

View page
US Patent:
7945893, May 17, 2011
Filed:
Oct 10, 2006
Appl. No.:
11/545932
Inventors:
Rohan Angrish - Redwood City CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 9/44
US Classification:
717106
Abstract:
Using a WSDL document to exchange an interface definition for back-end business logic includes automatically mapping various elements of the WSDL document to corresponding XQuery elements to generate an XQuery interface definition “skeleton”. From such an XQuery interface skeleton, an XQuery statement can be generated by filling in the body of the function that implements the logic. The XQuery statement serves as an interface definition for an interface to the function. Furthermore, at runtime a Web Service request that is based on the WSDL document can be translated into an XQuery call into an XQuery function that implements the logic defined in the WSDL document. From there, results are obtained from the XQuery function, translated into the appropriate return format defined in the WSDL, and returned.

Techniques For Providing Xquery Access Using Web Services

View page
US Patent:
8375043, Feb 12, 2013
Filed:
Jan 19, 2011
Appl. No.:
13/009712
Inventors:
Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Karuna Muthiah - Redwood City CA, US
Ying Lu - Sunnyvale CA, US
James W. Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Anand Manikutty - Foster City CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707759, 717159
Abstract:
An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

Techniques For Automatically Exposing, As Web Services, Procedures And Functions Stored In A Database

View page
US Patent:
20060136351, Jun 22, 2006
Filed:
Dec 8, 2004
Appl. No.:
11/008425
Inventors:
Rohan Angrish - Redwood City CA, US
James Warner - Mountain View CA, US
Zhen Liu - San Mateo CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Anand Manikutty - Foster City CA, US
Vikas Arora - San Francisco CA, US
Susan Kotsovolos - San Carlos CA, US
International Classification:
G06F 17/30
G06F 9/44
US Classification:
707001000, 717114000
Abstract:
A database server that manages a database retrieves metadata that is stored, within the database, in association with a procedure that is stored in the database. Based on the metadata, a Web service definition is automatically constructed to describe the procedure as a Web service. The WSDL definition can be referenced to construct SOAP messages with the appropriate arguments and in the appropriate format which, when received, are converted to a suitable format for invoking execution of the procedure by the database server.

Techniques For Efficient Integration Of Text Searching With Queries Over Xml Data

View page
US Patent:
20060224627, Oct 5, 2006
Filed:
Apr 5, 2005
Appl. No.:
11/099918
Inventors:
Anand Manikutty - Foster City CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Zhen Liu - San Mateo CA, US
James Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Susan Kotsovolos - San Carlos CA, US
Ravi Murthy - Fremont CA, US
Wesley Lin - West Covina CA, US
International Classification:
G06F 17/00
US Classification:
707104100
Abstract:
A method and apparatus for rewriting a database command containing an embedded XML expression such that the rewritten database command recites a text function, in lieu of the embedded XML expression, is provided. Advantageously, a DBMS may take advantage of the efficiencies in storing XML data within the database, while avoiding the generation of unnecessary XML elements in processing the query when the XML elements contribute nothing to the outcome of the query. Cost-base or rule-based analysis may be performed to determine how to rewrite a received database command. The database server may functionally evaluate the text function or may use an index defined on a column of the database. The text function may function as a primary filter or may reference a column upon which an index is defined, wherein the index operates at the same or higher level than a column being referenced in the embedded XML expression.
Rohan V Angrish from Sunnyvale, CA, age ~45 Get Report