Please download the dossier by clicking on the dossier button x
×

Implementing a logically partitioned data warehouse using a container map

  • US 10,628,422 B2
  • Filed: 10/21/2016
  • Issued: 04/21/2020
  • Est. Priority Date: 10/23/2015
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • receiving at a first database server a query from a database client during a session with an application root specifying to retrieve one or more records of a database object that match one or more predicates from a plurality of member pluggable databases of the application root, wherein the plurality of member pluggable databases are contained within a container database to which the first database server provides access;

    the first database server identifying one or more particular pluggable databases of the plurality of member pluggable databases that are implicated by the query based on a container map stored within the application root, wherein the container map specifies a mapping between each partitioning criterion of a set of partitioning criteria and a corresponding pluggable database of the plurality of member pluggable databases;

    the first database server executing the query only on each pluggable database of the one or more particular pluggable databases to produce a respective result set of records from the database object;

    the first database server aggregating the respective result set of results from each pluggable database of the one or more particular pluggable databases into an aggregated result set for the query;

    the first database server sending the aggregated result set to the database client.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×