发明申请
- 专利标题: Fetching Optimization in Multi-way Pipelined Database Joins
- 专利标题(中): 在多路流水线数据库连接中获取优化
-
申请号: US12473065申请日: 2009-05-27
-
公开(公告)号: US20100306212A1公开(公告)日: 2010-12-02
- 发明人: Dimitrios Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe
- 申请人: Dimitrios Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe
- 申请人地址: US TX Houston
- 专利权人: HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P.
- 当前专利权人: HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P.
- 当前专利权人地址: US TX Houston
- 主分类号: G06F17/30
- IPC分类号: G06F17/30 ; G06F7/00 ; G06F12/02 ; G06F12/00
摘要:
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.
公开/授权文献
- US08402016B2 Fetching optimization in multi-way pipelined database joins 公开/授权日:2013-03-19
信息查询