Methods and apparatus for partitioning data
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for data partitioning method includes defining a set of category levels associated with a plurality of entities stored within a first database, wherein the set of category levels is hierarchical (e.g., proceeding from higher to lower levels). Each of the plurality of entities is assigned to a category level within the set of category levels. One or more partition keys are defined for at least one of the category levels. The plurality of entities are then copied to a second database based on the set of category levels and the one or more partition keys.
-
Citations
16 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A non-transitory computer-readable medium comprising computer-executable instructions that, when executed by a processing system of a server, cause the processing system to:
-
define, 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 a first multitenant database of a multitenant system that is configured to store data for the plurality of tenants in a table, wherein data for a particular tenant is stored in the table as the plurality of entities, wherein each entity corresponds to a logical portion within the table of the first 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; assign, 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; define, in response to third inputs from the computer associated with the particular tenant, one or more partition keys for each of the category levels; select one of the partition keys and a specific instance of the selected partition key; and copy, 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 Dependent Claims (8, 9, 10)
-
-
11. A multitenant system for data partitioning, comprising:
-
a computer associated with a particular tenant; a first multitenant database configured to store data for a plurality of tenants in a table, wherein data for the particular tenant is stored in the table as a plurality of entities, wherein each entity corresponds to a logical portion within the table of the first multitenant database; a server communicatively coupled to the first multitenant database, comprising; a processor configured to execute a data partitioning module to partition the data for the particular tenant, wherein the data partitioning module is configured to; define, in response to first inputs from the computer associated with the particular tenant, a set of category levels associated with the plurality of entities stored within 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, assign, 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, define, in response to third inputs from the computer associated with the particular tenant, one or more partition keys for each of the category levels, select one of the partition keys and a specific instance of the selected partition key; and copy, 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 Dependent Claims (12, 13, 14, 15, 16)
-
Specification