Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching
First Claim
1. A method for processing queries, the method comprising the computer-implemented steps of:
- receiving a query at a mid-tier node of a multi-tier system, wherein the mid-tier node is communicatively connected to a database server in a database tier of the multi-tier system;
wherein the mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by the database server;
determining whether the query includes one or more operators for requesting first data of an eXtensible Markup Language (XML) datatype from the database server, wherein the XML datatype is supported as a native datatype by the database server; and
if a determination is made that the query includes the one or more operators, then performing at least the steps of;
retrieving, from the database server, first one or more portions of first one or more relational tables that are managed by the database server, wherein the first one or more relational tables store index information associated with the first data of the XML datatype in the first one or more portions;
storing the first one or more portions of the first one of more relational tables in the mid-tier cache; and
rewriting the query into a relational query against at least the first one or more portions of the first one of more relational tables that are stored in the mid-tier cache.
2 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
26 Claims
-
1. A method for processing queries, the method comprising the computer-implemented steps of:
-
receiving a query at a mid-tier node of a multi-tier system, wherein the mid-tier node is communicatively connected to a database server in a database tier of the multi-tier system; wherein the mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by the database server; determining whether the query includes one or more operators for requesting first data of an eXtensible Markup Language (XML) datatype from the database server, wherein the XML datatype is supported as a native datatype by the database server; and if a determination is made that the query includes the one or more operators, then performing at least the steps of; retrieving, from the database server, first one or more portions of first one or more relational tables that are managed by the database server, wherein the first one or more relational tables store index information associated with the first data of the XML datatype in the first one or more portions; storing the first one or more portions of the first one of more relational tables in the mid-tier cache; and rewriting the query into a relational query against at least the first one or more portions of the first one of more relational tables that are stored in the mid-tier cache. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
Specification