3. The method of claim 2 , further comprising: based on at least one of the storage information and the index information, identifying second one or more portions of second one or more relational tables managed by the database server, wherein the second one or more relational tables store the first data of the XML datatype in the second one or more portions; retrieving the second one or more portions of the second one or more relational tables from the database server; and storing the second one or more portions of the second one or more relational tables in the mid-tier cache; wherein the step of rewriting the query into the relational query further comprises writing the relational query against the second one or more portions of the second one or more relational tables that are stored in the mid-tier cache.
2. The method of claim 1 , wherein, 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 storage information associated with the first data of the XML datatype, wherein the storage information indicates a particular representation of the XML datatype; and based at least on the storage information, identifying the first one or more relational tables.