Techniques for pruning a data object during operations that join multiple data objects

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 7020661
SERIAL NO

10193620

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

Techniques for eliminating one or more portions of a data object from any join step of an operation that joins multiple data objects include determining that an operation joins a first data object and a second data object. The second data object includes multiple portions. Each of multiple data units of the first data object is scanned. Based on data in the data units of the first data object, information is generated. The information indicates a portion of the second data object for exclusion. The indicated portion is excluded from an output of the operation. Only one or more portions of the second data object that are not indicated for exclusion in the information are included in a particular join step involving the second data object. By pruning a large second table, such as a fact table, the computational resources consumed by the joins are substantially reduced.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
ORACLE INTERNATIONAL CORPORATION500 ORACLE PARKWAY REDWOOD CITY CA 94065

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Cruanes, Thierry Redwood City, CA 314 2298
Dageville, Benoit Foster City, CA 474 5529
Zait, Mohamed Sunnyvale, CA 61 2422

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation