Query generator

Details Query generator Query generator

2000-12-07

2008-12-16

Al-Hashemi, Sana (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07467152

ABSTRACT:
The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.

REFERENCES:
patent: 5412804 (1995-05-01), Krishna
patent: 5713020 (1998-01-01), Reiter et al.
patent: 5761654 (1998-06-01), Tow
patent: 5781896 (1998-07-01), Dalal
patent: 5832485 (1998-11-01), Chaudry
patent: 5850547 (1998-12-01), Waddington et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6016488 (2000-01-01), Bosworth et al.
patent: 6023695 (2000-02-01), Osborn et al.
patent: 6023696 (2000-02-01), Osborn et al.
patent: 6064999 (2000-05-01), Dalal
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6134543 (2000-10-01), Witkowski et al.
patent: 6212515 (2001-04-01), Rogers
patent: 6249791 (2001-06-01), Osborn et al.
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6438541 (2002-08-01), Witkowski
patent: 6449605 (2002-09-01), Witkowski
patent: 6449606 (2002-09-01), Witkowski
patent: 6449609 (2002-09-01), Witkowski
patent: 6477525 (2002-11-01), Bello et al.
patent: 6496819 (2002-12-01), Bello et al.
patent: 6581055 (2003-06-01), Ziauddin
patent: 6609131 (2003-08-01), Zait et al.
patent: 6678676 (2004-01-01), Brickell
Chaudhuri S. et al., “Optimizing Queries With Aggregate Views”, International Conference On Extending Database Technology Proceedings, Mar. 25, 1996, pp. 167-182.
Goel P. et al., “SQL query Optimization: Reordering for a General Class of Queries”, 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Que., Canada, Jun. 4-6, 1996, vol. 25, No. 2, pp. 47-56.

Affiliated with

Also associated with

Rating

Query generator does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query generator, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query generator will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4026923