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:
May. 29, 2018

Filed:

Jan. 30, 2015
Applicant:

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

Inventors:

Danica Porobic, Chavannes-pres-Renens, CH;

Sabina Petride, Hayward, CA (US);

Sam Idicula, Santa Clara, CA (US);

Assignee:

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

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 17/30 (2006.01);
U.S. Cl.
CPC ...
G06F 17/30094 (2013.01); G06F 17/30129 (2013.01); G06F 17/30498 (2013.01); G06F 17/30979 (2013.01);
Abstract

A method for distributing tables to a cluster of nodes managed by database management system (DBMS), is disclosed. Multiple data placement schemes are evaluated based on a query workload set to select a data placement scheme for the cluster of nodes. Tables, used in join operations in the workload set, are selected for evaluation of data placement schemes. Query execution costs for the workload set are generated based on estimating a query execution cost for each data placement scheme for the tables. The data placement scheme that has least costly estimated execution cost for the workload set is selected as the data placement scheme for the cluster of nodes managed by DBMS.


Find Patent Forward Citations

Porobic, Danica. (2018). Workload aware data placement for join-based query processing in a cluster (U.S. Patent No. 9984081). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/9984081

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

Loading…