Partition pruning with composite partitioning

A method for partitioning an object to enable partition pruning for a wider variety of statements that access the object, the method comprising the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• by using a partitioning technique other than hash partitioning, partitioning the object at a first level by applying a first partitioning criteria to the object to produce a first set of partitions;
• and
• by using a partitioning technique other than range-based partitioning, partitioning the object at a second level by applying a second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.

A method for partitioning an object in a system that includes a plurality of nodes, the method comprising the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• partitioning the object at a first level by applying a first partitioning criteria to the object to produce a first set of partitions;
• partitioning the object at a second level by applying a second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• and
• storing said second set of partitions at a location accessible to all nodes of said plurality of nodes that require access to data from said object;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.

A method for partitioning an object to enable partition pruning for a wider variety of statements that access the object, the method comprising the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• receiving data from a user that specifies at least a first partitioning criteria for said object and a second partitioning criteria for said object;
• partitioning the object at a first level by applying said first partitioning criteria to the object to produce a first set of partitions;
• and
• partitioning the object at a second level by applying said second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.

A computer-readable medium carrying instructions for partitioning an object to enable partition pruning for a wider variety of statements that access the object, the computer-readable medium comprising instructions for performing the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• partitioning the object at a first level by applying a first partitioning criteria to the object to produce a first set of partitions;
• partitioning the object at a second level by applying a second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• and
• partitioning the object at a third level by applying a third partitioning criteria to each partition in said second set of partitions to produce a third set of partitions;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.

A computer-readable medium carrying instructions for partitioning an object to enable partition pruning for a wider variety of statements that access the object, the computer-readable medium comprising instructions for performing the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• by using a partitioning technique other than hash partitioning, partitioning the object at a first level by applying a first partitioning criteria to the object to produce a first set of partitions;
• and
• by using a partitioning technique other than range-based partitioning, partitioning the object at a second level by applying a second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.

A computer-readable medium carrying instructions for partitioning an object in a system that includes a plurality of nodes, the computer-readable medium comprising instructions for performing the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• partitioning the object at a first level by applying a first partitioning criteria to the object to produce a first set of partitions;
• partitioning the object at a second level by applying a second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• and
• storing said second set of partitions at a location accessible to all nodes of said plurality of nodes that require access to data from said object;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.

A computer-readable medium carrying instructions for partitioning an object to enable partition pruning for a wider variety of statements that access the object, the computer-readable medium comprising instructions for performing the steps of:

• performing multi-level partitioning of the object by applying partitioning criteria on a per-level basis for a plurality of partitioning levels, wherein the step of applying partitioning criteria comprises:
• receiving data from a user that specifies at least a first partitioning criteria for said object and a second partitioning criteria for said object;
• partitioning the object at a first level by applying said first partitioning criteria to the object to produce a first set of partitions;
• and
• partitioning the object at a second level by applying said second partitioning criteria to each partition in said first set of partitions to produce a second set of partitions;
• wherein, for every level at which said object is partitioned, the same partitioning function is used to produce all partitions in said level.