System and method for an efficient and scalable multitenant database implementation for services platforms, including cloud services platforms
AssigneeOpen Text Corporation
InventorDhatchana Moorthy Sekar
Life of this patent
Estimating the term…
Abstract
Embodiments of a services application on web services platform that employs embodiments of a database architecture for use in multitenant environments that replicates the same schema in the context of a database are disclosed. These schemas can be accessed using a database access object corresponding to the database and a particular schema for a particular tenant. In particular, the object identifier used to access the objects of the schema may be algorithmically generated based on the tenant.
Claims18
A web services system, comprising:
- a multitenant web services application deployed on a web services platform;
- a database layer, comprising a database;
- a non-transitory computer readable medium, comprising instructions for:
- establishing a first schema in the database for a first tenant of the web services application;
- establishing a second schema in the database for a second tenant of the web services application, wherein the first schema is a replica of the second schema;
- in response to receiving a first request from a first user at a first client application:
- determining that the first request is associated with the first tenant;
- based on the determination that the first request is associated with the first tenant, establishing a first session at the web service application, the first session associated with the first client application;
- establishing a first database connection object configured to access the first schema of the database;
- and
- associating the first database connection object with the first user session;
- in response to receiving a second request from a second user at a second client application:
- determining that the second request is associated with the second tenant;
- based on the determination that the second request is associated with the second tenant, establishing a second session at the web service application, the second session associated with the second client application;
- establishing a second database connection object configured to access the second schema of the database;
- and
- associating the second database connection object with the second user session;
- receiving a third request at the web services application;
- determining if the third request is associated with the first tenant or the second tenant;
- based on a determination that the third request is associated with the first tenant, performing the third request by accessing the first schema in the database associated with the first tenant using the first session and first database connection object associated with the first schema;
- and
- based on a determination that the third request is associated with the second tenant, performing the third request by accessing the second schema in the database associated with the second tenant using the second session and second database connection object associated with the second schema.
A method, comprising:
- establishing a first schema in a database for a first tenant of a multitenant web services application deployed on a web services platform;
- establishing a second schema in the database for a second tenant of the web services application, wherein the first schema is a replica of the second schema;
- in response to receiving a first request from a first user at a first client application:
- determining that the first request is associated with the first tenant;
- based on the determination that the first request is associated with the first tenant, establishing a first session at the web service application, the first session associated with the first client application;
- establishing a first database connection object configured to access the first schema of the database;
- and
- associating the first database connection object with the first user session;
- in response to receiving a second request from a second user at a second client application:
- determining that the second request is associated with the second tenant;
- based on the determination that the second request is associated with the second tenant, establishing a second session at the web service application, the second session associated with the second client application;
- establishing a second database connection object configured to access the second schema of the database;
- and
- associating the second database connection object with the second user session;
- receiving a third request at the web services application;
- determining if the third request is associated with the first tenant or the second tenant;
- based on a determination that the third request is associated with the first tenant, performing the third request by accessing the first schema in the database associated with the first tenant using the first session and first database connection object associated with the first schema;
- and
- based on a determination that the third request is associated with the second tenant, performing the third request by accessing the second schema in the database associated with the second tenant using the second session and second database connection object associated with the second schema.
A non-transitory computer readable medium comprising instructions for:
- establishing a first schema in a database for a first tenant of a multitenant web services application deployed on a web services platform;
- establishing a second schema in the database for a second tenant of the web services application, wherein the first schema is a replica of the second schema;
- in response to receiving a first request from a first user at a first client application:
- determining that the first request is associated with the first tenant;
- based on the determination that the first request is associated with the first tenant, establishing a first session at the web service application, the first session associated with the first client application;
- establishing a first database connection object configured to access the first schema of the database;
- and
- associating the first database connection object with the first user session;
- in response to receiving a second request from a second user at a second client application:
- determining that the second request is associated with the second tenant;
- based on the determination that the second request is associated with the second tenant, establishing a second session at the web service application, the second session associated with the second client application;
- establishing a second database connection object configured to access the second schema of the database;
- and
- associating the second database connection object with the second user session;
- receiving a third request at the web services application;
- determining if the third request is associated with the first tenant or the second tenant;
- based on a determination that the third request is associated with the first tenant, performing the third request by accessing the first schema in the database associated with the first tenant using the first session and first database connection object associated with the first schema;
- and
- based on a determination that the third request is associated with the second tenant, performing the third request by accessing the second schema in the database associated with the second tenant using the second session and second database connection object associated with the second schema.
Dependencies are inferred from the claim text.