Method of query transformation using window aggregation

Details Method of query transformation using window aggregation Method of query transformation using window aggregation

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2418163

A method of query transformation using window aggregation to transform queries involving subqueries. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.

Affiliated with

Also associated with

Rating

Method of query transformation using window aggregation does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method of query transformation using window aggregation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of query transformation using window aggregation will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-2058813