The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 19, 2013
Filed:
May. 27, 2009
Dimitrios Tsirogiannis, Toronto, CA;
Stavros Harizopoulos, San Francisco, CA (US);
Mehul A. Shah, Saratoga, CA (US);
Janet L. Wiener, Palo Alto, CA (US);
Goetz Graefe, Madison, WI (US);
Dimitrios Tsirogiannis, Toronto, CA;
Stavros Harizopoulos, San Francisco, CA (US);
Mehul A. Shah, Saratoga, CA (US);
Janet L. Wiener, Palo Alto, CA (US);
Goetz Graefe, Madison, WI (US);
Hewlett-Packard Development Company, L.P., Houston, TX (US);
Abstract
A method of performing a multi-way join of a plurality of database relations includes executing a plurality of pipelined two-way joins with the database relations. Each two-way join has two sequential phases. In the first phase, missing attributes of the input relations that are required to evaluate a joining criterion specific to said two-way join are fetched from a non-volatile memory device, and the input relations are joined according to the criterion. In the second phase, any additional missing attributes of the input relations are fetched from the non-volatile memory device as assigned by an optimization process executed prior to commencing the multi-way join.