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:
Apr. 21, 2020

Filed:

Oct. 21, 2016
Applicant:

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

Inventor:

Thomas Baby, Auburn, WA (US);

Assignee:

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

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/00 (2019.01); G06F 16/2455 (2019.01); G06F 16/28 (2019.01); G06F 16/27 (2019.01); G06F 16/25 (2019.01); G06F 16/21 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24554 (2019.01); G06F 16/21 (2019.01); G06F 16/25 (2019.01); G06F 16/252 (2019.01); G06F 16/27 (2019.01); G06F 16/283 (2019.01);
Abstract

In an approach, a database management system logically partitions a database object (such as a table) across multiple pluggable databases of a container database. When a database server receives a query at an application root, the database server consults a container map which provides a mapping between a set of partitioning criteria and a set of member pluggable databases of the application root. Using the container map, the database server identifies one or more pluggable databases of the set of member pluggable databases of the application root that contain records which potentially have the ability to match the predicates of the query. The database server then limits the execution of the query to the identified pluggable databases, effectively pruning away records contained by the other pluggable databases to increase the efficiency of executing the query.


Find Patent Forward Citations

Loading…