Managing execution of a query against selected data...

Details Managing execution of a query against selected data... Managing execution of a query against selected data...

2011-06-14

2011-06-14

Mofiz, Apu M (Department: 2157)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

C707S713000, C707SE17014, C707SE17044

Reexamination Certificate

active

07962442

ABSTRACT:
The present invention generally relates to data processing, and more specifically to executing queries against a partitioned database. One embodiment provides a computer-implemented method of managing execution of a query against a partitioned database having a plurality of data partitions. The method comprises receiving a query having conditional filtering logic to restrict the data records in the partitioned database to a result set satisfying the conditional filtering logic. On the basis of an indication that only a subset of the result set is to be returned, a subset of data partitions is determined from the plurality of data partitions from which the subset of the result set can be retrieved. Then, the query is executed only against the subset of data partitions.

REFERENCES:
patent: 4853843 (1989-08-01), Ecklund
patent: 5812840 (1998-09-01), Shwartz
patent: 5918225 (1999-06-01), White et al.
patent: 5956706 (1999-09-01), Carey et al.
patent: 6014656 (2000-01-01), Hallmark et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6212524 (2001-04-01), Weissman et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6598038 (2003-07-01), Guay et al.
patent: 6625593 (2003-09-01), Leung et al.
patent: 6738755 (2004-05-01), Freytag et al.
patent: 6754653 (2004-06-01), Bonner et al.
patent: 7299220 (2007-11-01), Chaudhuri et al.
patent: 7343367 (2008-03-01), Muras et al.
patent: 7350172 (2008-03-01), Koh et al.
patent: 7447679 (2008-11-01), Shankar et al.
patent: 7616840 (2009-11-01), Erol et al.
patent: 7756861 (2010-07-01), Muras et al.
patent: 2002/0116589 (2002-08-01), Gold
patent: 2002/0143751 (2002-10-01), Chow et al.
patent: 2004/0133538 (2004-07-01), Amiri et al.
patent: 2004/0215638 (2004-10-01), Kapoor et al.
patent: 2005/0021505 (2005-01-01), Bernal et al.
patent: 2005/0049987 (2005-03-01), Meek et al.
patent: 2005/0076043 (2005-04-01), Benedetti et al.
patent: 2005/0081210 (2005-04-01), Day et al.
patent: 2005/0192921 (2005-09-01), Chaudhuri et al.
patent: 2005/0235054 (2005-10-01), Kadashevich
patent: 2006/0089946 (2006-04-01), Schumacher
patent: 2006/0248056 (2006-11-01), Fang et al.
patent: 2006/0259457 (2006-11-01), Muras et al.
patent: EP 1 544 753 (2004-11-01), None
Bowman et al., Optimization of Query Streams Using Semantic Prefetching, Dec. 2005, ACM, vol. 30, Issue 4, pp. 1056-1101.
Zuzarte et al., WinMagic: Subquery Elimination Using Window Aggregation, Jun. 2003, ACM, pp. 652-656.

Affiliated with

Also associated with

Rating

Managing execution of a query against selected data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Managing execution of a query against selected data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Managing execution of a query against selected data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2648259