1. A method of searching a multilevel partitioned database, the method comprising:
receiving a query for data from the multilevel partitioned database, wherein the multilevel partitioned database includes multiple rows of partitioned data that are partitioned into plurality of levels, wherein each level is partitioned based on a different column;
statically including partitions from one or more first levels of the plurality of levels of the multilevel partitioned database for execution of the query;
determining an estimate of partitions from at least a second level in the one or more first level partitions to be dynamically included;
dynamically including at least some of the estimated partitions;
joining at least two tables of the multilevel partitioned database based on a cost of joining the tables, the cost calculated as a function of the statically included partitions and the estimate of the partitions to be dynamically included;
executing the query over the statically included partitions and the dynamically included partitions by;
accessing at least one data storage facility;
performing the joining of the at least two tables;
scanning sorted rows of the at least some of the statically included partitions and dynamically included partitions; and
stopping execution of the query when a row from a dynamically included partition indicates a partition that no longer matches a query value, wherein dynamically including partitions occurs while scanning rows of the statically included partitions during execution of the query.
2. The method of claim 1 wherein dynamically including at least some of the partitions comprises converting a query value to a converted query value.
3. The method of claim 2 wherein the converted query value is used to index into a partition.
4. The method of claim 3 wherein rows are retrieved from the partition until the converted query value no longer matches information in a row.
5. The method of claim 4 and further comprising repeating retrieval of rows from partitions at one or more levels.
6. The method of claim 1 wherein the multilevel partitioned database is distributed over multiple access module processors and wherein the method is performed on each such access module processor.
7. A database system having multiple level partitioned data, the system comprising:
a storage device and a computer processor;
a parsing engine including code stored on the storage device and running on the computer processor that receives a query for data from the multilevel partitioned database that includes multiple rows of partitioned data that are partitioned into a plurality of levels, wherein each level is partitioned based on a different column, statically includes partitions from one or more first levels of the plurality of levels of the multilevel partitioned database for execution of the query, determines an estimate of partitions from at least a second level in the one or more first level partitions to be dynamically included, dynamically includes at least some of the estimated partitions, joins at least two tables of the multilevel partitioned database based on a cost of joining the tables, the cost calculated as a function of the statically included partitions and the estimate of partitions to be dynamically included, and executes the query over the statically included partitions and the dynamically included partitions by, accessing at least one data storage facility, performing the joining of the at least two tables, scanning sorted rows of the at least some of the statically included partitions and dynamically included partitions, and stops execution of the query when a row from a dynamically included partition indicates a partition that no longer matches a query value, wherein the dynamically including partitions occurs while scanning rows of the statically included partitions during execution of the query.
8. The system of claim 7 wherein dynamically including at least some of the partitions comprises converting a query value to a converted query value for partitions.
9. The system of claim 8 wherein the converted query value is used to index into a partition.
10. The system of claim 9 wherein rows are retrieved from a partition until the converted query value no longer matches information in a row.
11. The system of claim 10 wherein the parsing engine repeats retrieval of rows from various level partitions.
12. The system of claim 7 and further comprising multiple access module processors having database data distributed on multiple storage devices within the access module processors.
The claims below are in addition to those above.
All refrences to claim(s) which appear below refer to the numbering after this setence.
1. A beverage apparatus comprising:
a hollow body defining at least a portion of a brewing chamber;
a piston controllably movable in at least a portion of the hollow body;
a filter operatively associated with the hollow body;
a liquid delivery system communicating with the hollow body;
a controller for controllably dispensing liquid from the liquid delivery system into the hollow body for mixing with a beverage making substance disposed in the hollow body to produce a beverage, controllably moving the piston through the hollow body for dispensing through the filter a beverage produced from the liquid and beverage substance;
a beverage reservoir coupled to a dispensing nozzle and controllably communicating with the hollow body for selectively controllably receiving beverage dispensed from the hollow body for controllable accumulation of multiple servings of beverage therein and selective controlled dispensing of beverage therefrom; and
a controllable valve communicating with the hollow body and coupled to the controller, the valve selectively controllably dispensing brewed beverage for human consumption to the reservoir or to a separate container via the dispensing nozzle.
2. The beverage apparatus of claim 1, further comprising an agitation assembly coupled to the controller and operatively associated with the hollow body for agitating beverage substance and liquid in the hollow body during a brewing cycle.
3. The beverage apparatus of claim 2, further comprising the agitation assembly operatively associated with the filter for providing agitation proximate to the filter.
4. The beverage apparatus of claim 2, in which the agitation assembly moves air through at least a portion of the hollow body for providing air agitation of beverage substance and liquid.
5. The beverage apparatus of claim 1, in which the piston is controllably operated downwardly through the hollow body to drive the combination of liquid and beverage substance against the filter to dispense beverage through the filter.
6. The beverage apparatus of claim 1, in which the piston is controllably operated upwardly through the hollow body to drive the combination of liquid and beverage substance against the filter to dispense beverage through the filter.
7. A beverage apparatus comprising:
a hollow body defining at least a portion of a brewing chamber;
a piston controllably movable in at least a portion of the hollow body;
a filter operatively associated with the hollow body;
a liquid delivery system communicating with the hollow body;
a controller for controllably dispensing liquid from the liquid delivery system into the hollow body for mixing with a beverage making substance disposed in the hollow body to produce a beverage, controllably moving the piston through the hollow body for dispensing through the filter a beverage produced from the liquid and beverage substance;
a beverage reservoir controllably communicating with the hollow body for selectively controllably receiving beverage dispensed from the hollow body for controllable accumulation of multiple servings of beverage therein and selective controlled dispensing of beverage therefrom; and
controllable means for selectively dispensing brewed beverage for human consumption from the hollow body to the reservoir or from the hollow body to a separate container.