Method, system, and program for optimizing aggregate processing

Details Method, system, and program for optimizing aggregate processing Method, system, and program for optimizing aggregate processing

2007-07-10

2007-07-10

Gaffin, Jeffrey (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C709S203000

Reexamination Certificate

active

10325854

ABSTRACT:
Disclosed is a method, system, and program for processing an aggregate function. Rows that contain a reference to intermediate result structures are grouped to form groups. For each group, aggregate element structures are formed from the intermediate result structures and, if the aggregate function specifies ordering, the aggregate element structures are sorted based on a sort key.

REFERENCES:
patent: 5089985 (1992-02-01), Chang et al.
patent: 5428737 (1995-06-01), Li et al.
patent: 5764973 (1998-06-01), Lunceford et al.
patent: 5778354 (1998-07-01), Leslie et al.
patent: 5822747 (1998-10-01), Graefe et al.
patent: 5845299 (1998-12-01), Arora et al.
patent: 5911145 (1999-06-01), Arora et al.
patent: 6070175 (2000-05-01), Mezei
patent: 6105024 (2000-08-01), Graefe et al.
patent: 6198480 (2001-03-01), Cotugno et al.
patent: 6233610 (2001-05-01), Hayball et al.
patent: 6356906 (2002-03-01), Lippert et al.
patent: 6356920 (2002-03-01), Vandersluis
patent: 6405191 (2002-06-01), Bhatt et al.
patent: 6487546 (2002-11-01), Witkowski
patent: 6604100 (2003-08-01), Fernandez et al.
patent: 6775831 (2004-08-01), Carrasco et al.
patent: 6941521 (2005-09-01), Lin et al.
patent: 7028312 (2006-04-01), Merrick et al.
patent: 2001/0037345 (2001-11-01), Kiernan et al.
patent: 2002/0013790 (2002-01-01), Vandersluis
patent: 2002/0116412 (2002-08-01), Barnes et al.
patent: 2003/0182268 (2003-09-01), Lal
patent: 2004/0073553 (2004-04-01), Brown et al.
patent: 2004/0168124 (2004-08-01), Beisiegel et al.
patent: 0182133 (2001-11-01), None
“Efficiently publishing relational data as XML documents” Shanmugasundaram et al.□□The VLDB Journal of (2001) 10:133-154/Digital Object Identifier (DOI) 10.1007/s007780100052.
“SQL/XML is Making Good Progress”, Andrew Eisenber and Jim Melton□□SIGMOD Record, vol. 31, No. 2, Jun. 2002□□.
Microsoft Corp., “Orthogonal Optimization of Subqueries and Aggregation,” by Cesar A. Galindo-Legaria and Milind M. Joshi, pp. 571-581, from ACM SIGMOD 2001, May 21-24, Santa Barbara, CA, USA, © 2001.
Dessaux, Claire. “Exhanging XML-Based Messages on the Oracle91 Application Server” pp. 48-51, [online], available from http://www.XML-Journal.com, vol. 2, issue4, no date.
Institute of Electrical and Electronics Engineers, Inc. “XML and DB2,” by Josephine Cheng and Jane Xu of IBM Corp., p. 569 from the 16thInternational Conference on Data Engineering, Feb. 28-Mar. 3, 2000, San Diego, California, p. 1, [online], http://www.computer.org/proceedings/icde/0506/05050569abs.html, printed on Aug. 29, 2002.
IBM Corp., XML and WebSphere Studio Application Developer—Part 3, SQI and SML, p. 1-4, [online] available from http://www7b.software.ibm.co..d/techjournal/0202—haggarty/haggarty.html, printed on Aug. 29, 2002.
Visual Studio Magazine, “Create Powerful Web Reports,”: Use VB code to generate T-SQL queries . . . , by Roger Jennings, p. 1 [online] http://fawcette.com/Arc...i/2001/, printed on Aug. 29, 2002.
Syspro Times, Quarter 2, 2002, “XML Report Viewer,” p. 1-8, [online] available from www.rte-cyber.com.
IBM Corp., Research Disclosure n444208, Apr. 2001, #208, p. 709, Conversion of Final Form Data, such as AFP, to XML.
IBM Corp., Research Disclosure n451156, Nov. 2001, #156, p. 1966, Generating Hierarchical XML Data froma flat {Non-Hierarchical} Data Source.
IBM Corp., Dossier No. AUS91990412, Sep. 30, 1999.
IBM Corp., Dossier No. AUS919990421, Sep. 30, 1999.
U.S. Appl. No. 09/409,598, filed Sep. 30, 1999, entitled “Extensible Markup Language (XML) Server Pages Having Custom Document Object Model (DOM) Tags”, invented by C.S. Claussen, M.H. Conner, B.C. Zumbrunnen, and M.D. McClain.
U.S. Appl. No. 09/409,600, filed Sep. 30, 1999, entitled “Method for Processing a Document Object Model (DOM) Having Custom Tags”, invented by C.S. Claussen, M.H. Conner, and B.C. Zumbrunnen.
U.S. Appl. No. 10/325,781, filed Dec. 19, 2002, entitled “Method, System, and Program for Optimizing Processing of Nested Functions”, invented by Lin, F., Y.C.S. Chen, Y. Wang, G. Zhang, M. Cai, J.A. Cu, & L. Lee.
Canadian Patent Application Serial No. 2349905, filed Jun. 1, 2001, entitled “System and Method of Mapping Between Software Objects and Structured Language Element Based Documents”, invented by T. Green, J. Warfield, and M. Beisiegel.

Affiliated with

Also associated with

Rating

Method, system, and program for optimizing aggregate processing 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, system, and program for optimizing aggregate processing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program for optimizing aggregate processing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3817432