×

Methods and apparatus for partitioning data

  • US 9,830,385 B2
  • Filed: 09/04/2013
  • Issued: 11/28/2017
  • Est. Priority Date: 09/04/2012
  • Status: Active Grant
First Claim
Patent Images

1. A data partitioning method performed by a data partitioning module executed at a server to partition data for a particular tenant of a first multitenant database of a multitenant system for a plurality of tenants, wherein the first multitenant database is configured to store data for the plurality of tenants in a table, the method comprising:

  • defining, via the data partitioning module in response to first inputs from a computer associated with the particular tenant, a set of category levels associated with a plurality of entities stored within the table of the first multitenant database, wherein each entity corresponds to a logical portion within the table of the first multitenant database, wherein the set of category levels is hierarchical in that entities within a first, higher category level depend only upon entities within a lower, second category level;

    assigning, via the data partitioning module in response to second inputs from the computer associated with the particular tenant, each of the plurality of entities to one of the category levels within the set of category levels;

    defining, via the data partitioning module in response to third inputs from the computer associated with the particular tenant, one or more partition keys for each of the category levels;

    selecting one of the partition keys and a specific instance of the selected partition key; and

    copying, via the data partitioning module based on the set of category levels and the selected partition key, all entities corresponding to the specific instance of the selected partition key from the category level for which the selected partition key is defined and all entities in a lower category level from the first multitenant database to a second database to partition part of the data for the particular tenant according to the set of category levels and the selected partition key.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×