Invention Grant
- Patent Title: Transitive local predicated across multiple joins
-
Application No.: US15033519Application Date: 2013-12-06
-
Publication No.: US10769149B2Publication Date: 2020-09-08
- Inventor: Sreenath Bodagala , James Laurence Finnerty
- Applicant: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
- Applicant Address: US CA Santa Clara
- Assignee: MICRO FOCUS LLC
- Current Assignee: MICRO FOCUS LLC
- Current Assignee Address: US CA Santa Clara
- International Application: PCT/US2013/073687 WO 20131206
- International Announcement: WO2015/084407 WO 20150611
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2455

Abstract:
In an example, a transitive local predicates may be inferred across multiple joins, wherein the multiple outer joins include multiple outer joins. A query connecting tables by the multiple joins is analyzed. A local predicate may then be identified from the analyzed query and may be determined to be either a where-clause local predicate or an on-clause local predicate. Accordingly, a transitive local predicate may be inferred across a selection of the tables based on the determination.
Public/Granted literature
- US20160283552A1 TRANSITIVE LOCAL PREDICATES ACROSS MULTIPLE JOINS Public/Granted day:2016-09-29
Information query