公开(公告)号：US09965516B2

公开(公告)日：2018-05-08

申请号：US14284248

申请日：2014-05-21

Applicant: Oracle International Corporation

Inventor： Rafi Ahmed ,  Gautam Kumar Parai

IPC: G06F17/30

CPC classification number: G06F17/30489 ,  G06F17/30466

Abstract: A method and apparatus for outer-joined and/or cross-joined table elimination for duplicate-insignificant queries is provided. A query block of a query specifies a join between a first table and a second table. The join is one of an outer join and a cross join. A first determination is made that the query block contains no references to the second table to be processed after the join. A second determination is made that the query block is duplicate-insignificant. In response to making the first determination and the second determination, the query block is transformed into a transformed query, where the second table is eliminated from a corresponding query block in the transformed query.

公开(公告)号：US20150339349A1

公开(公告)日：2015-11-26

申请号：US14284248

申请日：2014-05-21

Applicant: Oracle International Corporation

Inventor： Rafi Ahmed ,  Gautam Kumar Parai

IPC: G06F17/30

CPC classification number: G06F17/30489 ,  G06F17/30466

Abstract: A method and apparatus for outer-joined and/or cross-joined table elimination for duplicate-insignificant queries is provided. A query block of a query specifies a join between a first table and a second table. The join is one of an outer join and a cross join. A first determination is made that the query block contains no references to the second table to be processed after the join. A second determination is made that the query block is duplicate-insignificant. In response to making the first determination and the second determination, the query block is transformed into a transformed query, where the second table is eliminated from a corresponding query block in the transformed query.

Abstract translation: 提供了用于重复查询的外连接和/或交叉连接表消除的方法和装置。 查询的查询块指定第一个表和第二个表之间的连接。 连接是外连接和交叉连接之一。 首先确定查询块不包含在连接之后要处理的第二个表的引用。 第二个确定是查询块是重复的 - 重要的。 响应于进行第一确定和第二确定，将查询块变换为经变换的查询，其中从转换查询中的相应查询块中删除第二表。