The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Mar. 31, 2020

Filed:

Sep. 26, 2017
Applicant:

Oracle International Corporation, Redwood Shores, CA (US);

Inventors:

Thierry Cruanes, San Mateo, CA (US);

Junyi Xie, Dobbs Ferry, NY (US);

Yiu Woon Lau, New York, NY (US);

Assignee:

Oracle International Corporation, Redwood Shores, CA (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 17/30 (2006.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); G06F 16/2458 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24542 (2019.01); G06F 16/2454 (2019.01); G06F 16/2453 (2019.01); G06F 16/2456 (2019.01); G06F 16/2471 (2019.01); G06F 16/24544 (2019.01); G06F 16/24556 (2019.01); G06F 16/24568 (2019.01);
Abstract

Techniques are provided for sharing expression evaluation across a database management system and a storage layer. In an embodiment, a computer identifies, in a query execution plan compiled for a query, a plurality of target operators that includes an expression that computes a common value. A storage layer evaluates the expression that computes the common value during a table scan of stored data indicated by the expression. For at least one target operator of the plurality of target operators, the computer modifies a row input of the at least one target operator to add a column to receive an evaluation result comprising the common value from the storage layer. The query execution plan is performed by a database management system and the storage layer.


Find Patent Forward Citations

Cruanes, Thierry. (2020). Methods and apparatus of shared expression evaluation across rdbms and storage layer (U.S. Patent No. 10606834). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/10606834

Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile

Loading…