Techniques for partition pruning

Details Techniques for partition pruning Techniques for partition pruning

2005-05-04

2010-10-12

Mahmoudi, Tony (Department: 2169)

Data processing: database and file management or data structures

Database and file access

Preparing data for information retrieval

C707S794000, C706S012000, C706S045000

Reexamination Certificate

active

07814104

ABSTRACT:
Techniques are described for performing partition pruning in situations where previous database servers could not. Specifically, techniques are provided for (1) performing partition pruning based on predicates that involve non-prefix subsets of composite partitioning keys, (2) performing partition pruning when a global index access path is used to execute a query, and (3) performing partition pruning when predicates on partitioning columns are OR-ed together. More generally, techniques are described for partition pruning based on a non-contiguous set of not-pruned partitions.

REFERENCES:
patent: 5222234 (1993-06-01), Wang et al.
patent: 5515531 (1996-05-01), Fujiwara et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 6003036 (1999-12-01), Martin
patent: 6014656 (2000-01-01), Hallmark et al.
patent: 6341289 (2002-01-01), Burroughs et al.
patent: 6438562 (2002-08-01), Gupta et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6587854 (2003-07-01), Guthrie et al.
patent: 6665684 (2003-12-01), Zait et al.
patent: 6816853 (2004-11-01), Agarwal et al.
patent: 6842753 (2005-01-01), Chaudhuri et al.
patent: 6931390 (2005-08-01), Zait et al.
patent: 6957225 (2005-10-01), Zait et al.
patent: 6965891 (2005-11-01), Jakobsson et al.
patent: 7020656 (2006-03-01), Gong
patent: 7020661 (2006-03-01), Cruanes et al.
patent: 2006/0047622 (2006-03-01), Folkert et al.
patent: 2010/0070448 (2010-03-01), Omoigui
Oracle Corp., “Parallelism and Partitioning,” Oracle8iData Warehousing Guide, Release 2 (8.1.6), chapter 5, retrieved from internet at <http://download-uk.oracle.com/docs/cd/A87860—01/doc/server.817/a76994/parpart.htm>, retrieved on Nov. 4, 2005, 16 pages.
Sybase, Transact-SQL Guide, Adaptive Server Enterprise 15.0, Oct. 2005, pp. 363-371.
“Oracle Database Administrator's Guide”, 10g Release 1(10.1), Part No. B10739-01, Dec. 2003—Chapter 16 “Managing Partitioned Tables and Indexes” pp. 1-25.

Affiliated with

Also associated with

Rating

Techniques for partition pruning does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4231429