Efficient evaluation of SQL pivot operations

Details Efficient evaluation of SQL pivot operations Efficient evaluation of SQL pivot operations

2008-07-21

2011-10-18

Alam, Hosain (Department: 2166)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C707S793000

Reexamination Certificate

active

08041731

ABSTRACT:
Techniques are described herein for supporting efficient evaluation of pivot operations. In an embodiment, a pivoting query on a data table is received. The query identifies pivot columns, measure columns, and grouping columns. In response to receiving the query, a staging table that comprises new pivot columns, aggregated columns, and new grouping columns may be created. For each particular unique combination of values of the grouping columns and the pivot columns in the data table, stored values in the measure columns in the data table are aggregated for certain rows in the plurality of rows in the data table. Each row of the certain rows comprises the each particular unique combination of values of the grouping columns and the pivot columns in the data table. Results of aggregating are stored in the staging table. Data that has been populated in the staging table is transposed into a result set.

REFERENCES:
patent: 6298342 (2001-10-01), Graefe et al.
patent: 2005/0039114 (2005-02-01), Naimat et al.
Conor Cunningham, Cesar A. Galindo-Legaria, Goetz Graefe; PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS; 2004, Porceeding of the 30th VLDB Conference, p. 998-1009.

Affiliated with

Also associated with

Rating

Efficient evaluation of SQL pivot operations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Efficient evaluation of SQL pivot operations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Efficient evaluation of SQL pivot operations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4293281