Multi-tenancy data storage and access method and apparatus
First Claim
1. A method of storing and accessing multi-tenancy data, the method comprising the steps of:
- creating a plurality of table sets in one or more databases, wherein each table set is used to store data of a group of tenants selected from a plurality of tenants;
accessing data of a tenant in a table set in response to receiving a data access request from the tenant;
recording relationships between the tenants and the table sets in a multi-tenancy metadata repository, wherein the step of accessing the data of the tenant comprises the steps of finding the table set by querying the metadata repository and accessing the data of the tenant in the table set based on the result received from the query of the metadata repository; and
determining a maximum number of table sets and a maximum table sharing rate of each database, wherein the step of creating a plurality of table sets is performed according to the determined maximum number of table sets and maximum table sharing rate of each database.
0 Assignments
0 Petitions
Accused Products
Abstract
A method, apparatus, and a computer program product for storing and accessing multi-tenancy data. The method includes the steps of: creating a plurality of table sets in one or more databases, wherein each table set is used to store data of a group of tenants selected from a plurality of tenants; accessing data of a tenant in a table set in response to receiving a data access request from the tenant; and recording relationships between the tenants and the table sets in a multi-tenancy metadata repository, wherein the step of accessing the data of the tenant comprises the steps of finding the table set by querying the metadata repository and accessing the data of the tenant in the table set based on the result received from the query of the metadata repository.
-
Citations
6 Claims
-
1. A method of storing and accessing multi-tenancy data, the method comprising the steps of:
-
creating a plurality of table sets in one or more databases, wherein each table set is used to store data of a group of tenants selected from a plurality of tenants; accessing data of a tenant in a table set in response to receiving a data access request from the tenant; recording relationships between the tenants and the table sets in a multi-tenancy metadata repository, wherein the step of accessing the data of the tenant comprises the steps of finding the table set by querying the metadata repository and accessing the data of the tenant in the table set based on the result received from the query of the metadata repository; and determining a maximum number of table sets and a maximum table sharing rate of each database, wherein the step of creating a plurality of table sets is performed according to the determined maximum number of table sets and maximum table sharing rate of each database. - View Dependent Claims (2)
-
-
3. An apparatus for storing and accessing multi-tenancy data, comprising:
-
a memory; a tangible non-transitory computer readable storage medium accessible to said memory; at least one processor, coupled to said memory; a creation processing module stored in said computer readable storage medium which, when loaded into said memory, causes said at least one processor to be operative to create a plurality of table sets in one or more databases, wherein each table set is used to store data of a group of tenants selected from a plurality of tenants; a multi-tenancy data router stored in said computer readable storage medium which, when loaded into said memory, causes said at least one processor to be operative to access data of a tenant in a table set in response to receiving a data access request from the tenant; and a multi-tenancy metadata repository stored in said computer readable storage medium which, when loaded into said memory, causes said at least one processor to be operative to record the corresponding relationships between tenants and table sets; wherein the multi-tenancy data router, when loaded into said memory, further causes said at least one processor to be operative to find the table set by querying the metadata repository and access the data of the tenant in the table set based on a result received from the query of the metadata repository; further comprising a determination module stored in said computer readable storage medium which, when loaded into said memory, causes said at least one processor to be operative to determine a maximum number of table sets and maximum table sharing rate of each database, wherein the creation module, when loaded into said memory, further causes said at least one processor to create the plurality of table sets in the one or more databases according to the determined maximum number of table sets and maximum table sharing rate of each database. - View Dependent Claims (4)
-
-
5. An article of manufacture comprising a computer program product for storing and accessing multi-tenancy data, said computer program product comprising:
-
a tangible non-transitory computer-readable storage medium, storing in a non-transitory manner computer readable program code, the computer readable program code comprising; computer readable program code configured to create a plurality of table sets in one or more databases, wherein each table set is used to store data of a group of tenants selected from a plurality of tenants; computer readable program code configured to access data of a tenant in a table set in response to receiving a data access request from the tenant; computer readable program code configured to record relationships between the tenants and the table sets in a multi-tenancy metadata repository, wherein the computer readable program code configured to access the data of the tenant comprises computer readable program code configured to perform the steps of finding the table set by querying the metadata repository and accessing the data of the tenant in the table set based on the result received from the query of the metadata repository; and computer readable program code configured to determine a maximum number of table sets and a maximum table sharing rate of each database, wherein the computer readable program code configured to create a plurality of table sets creates the plurality of table sets according to the determined maximum number of table sets and maximum table sharing rate of each database. - View Dependent Claims (6)
-
Specification