System and method of query transformation
First Claim
Patent Images
1. A query transformation system for transforming nested aggregates in a query, the query transformation system comprising:
- a nested aggregate analysis module for analysing a query that is not supported by a target database system; and
a nested aggregate transformation module for transforming the query into a semantically equivalent query that is supported by the target database system.
4 Assignments
0 Petitions
Accused Products
Abstract
A query transformation system for transforming nested aggregates in a query is provided. The query transformation system comprises a nested aggregate analysis module for analysing a query that is not supported by a target database system, and a nested aggregate transformation module for transforming the query into a semantically equivalent query that is supported by the target database system.
49 Citations
10 Claims
-
1. A query transformation system for transforming nested aggregates in a query, the query transformation system comprising:
-
a nested aggregate analysis module for analysing a query that is not supported by a target database system; and
a nested aggregate transformation module for transforming the query into a semantically equivalent query that is supported by the target database system. - View Dependent Claims (2, 3)
-
-
4. A method of nested aggregate transformation, the method comprising the steps of:
-
analysing a query that is not supported by a target database system; and
transforming the query into a semantically equivalent query that is supported by the target database system. - View Dependent Claims (5, 6)
-
-
7. A method of nested aggregate transformation, the method comprising the steps of:
-
generating a derived table to compute aggregates;
extracting nested aggregates and moving nested aggregates into a select list of the derived table; and
determining whether the transformation is to be performed, including the steps of;
detecting nested aggregates; and
detecting framed aggregates and report aggregates;
if nested aggregates are detected, performing the transformation, including the steps of;
marking a nested aggregate for insertion into an inner select list;
marking a report aggregate for insertion into the inner select list if it does not contain a nested aggregate or there are framed aggregates present; and
detecting framed aggregates; and
adding expressions to the inner select list of the derived table.
-
-
8. A computer data signal embodied in a carrier wave and representing sequences of instructions which, when executed by a processor, cause the processor to perform a method of nested aggregate transformation, the method comprising the steps of:
-
analysing a query that is not supported by a target database system; and
transforming the query into a semantically equivalent query that is supported by the target database system.
-
-
9. A computer-readable medium having computer readable code embodied therein for use in the execution in a computer of a method of nested aggregate transformation, the method comprising the steps of:
-
analysing a query that is not supported by a target database system; and
transforming the query into a semantically equivalent query that is supported by the target database system.
-
-
10. A computer program product for use in the execution in a computer of a query transformation system for transforming nested aggregates in a query, the computer program product comprising:
-
a nested aggregate analysis module for analysing a query that is not supported by a target database system; and
a nested aggregate transformation module for transforming the query into a semantically equivalent query that is supported by the target database system.
-
Specification