Invention Grant
- Patent Title: Fetching optimization in multi-way pipelined database joins
- Patent Title (中): 在多路流水线数据库联接中获取优化
-
Application No.: US12473065Application Date: 2009-05-27
-
Publication No.: US08402016B2Publication Date: 2013-03-19
- Inventor: Dimitrios Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe
- Applicant: Dimitrios Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe
- Applicant Address: US TX Houston
- Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee Address: US TX Houston
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

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.
Public/Granted literature
- US20100306212A1 Fetching Optimization in Multi-way Pipelined Database Joins Public/Granted day:2010-12-02
Information query