Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 7499909
APP PUB NO 20080005093A1
SERIAL NO

11481159

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A method and apparatus for processing queries is provided. A query is received at a mid-tier node of a multi-tier system. The mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by a database server in a database tier of the multi-tier system. At the mid-tier node, a determination is made whether the received query includes an operator for requesting data of an XML datatype from the database server, where the XML datatype is supported as a native datatype by the database server. If a determination is made that the query includes such operator, then one or more portions of one or more relational tables are retrieved from the database server and stored in the mid-tier cache. The one or more relational tables store, in the one or more portions, index information associated with the requested data of the XML datatype. The received query is rewritten into a relational query against at least the one or more portions of the one or more relational tables that are stored in the mid-tier cache.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • ORACLE INTERNATIONAL CORPORATION

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Krishnaprasad, Muralidhar Fremont, US 106 5971
Liu, Zhen Hua San Mateo , US 112 2558

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation