Selectively upgrading clients in a multi-tenant computing system
First Claim
1. A computer-implemented method comprising:
- enabling, in a multi-tenant computing system, an application server to access a first set of tables and views in a database according to a first schema, each table being associated with one or more corresponding tenants of the multi-tenant computing system, the views in the first schema corresponding to a table in a second schema, the table in the second schema being associated with at least one tenant;
modifying the table in the second schema to add a column, the modifying being performed separately for different tenants such that a software upgrade associated with each tenant occurs during a corresponding separate time period;
generating views of the modified table as defined by the second schema in a third schema so that the third schema defines a second set of tables and views in the database; and
enabling the application server to access the second set of tables and views in the database and preventing access by the application server to the first set of tables and views in the database;
wherein;
the multi-tenant computing system forms part of a multi-tenant environment using a single software delivery architecture,the separate software upgrade for each tenant allows the software upgrade of a first tenant to occur during a downtime for the first tenant and an uptime for a second tenant,the multi-tenant computing system comprises;
at least one data repository containing;
core software platform content relating to the operation of the multi-tenant computing system which is not modifiable by the multiple tenants;
system content including data objects created in runtime by the multi-tenant computing system that are modifiable with data provided by a corresponding tenant, andtenant content including data objects or extensions to data objects that are customized for a corresponding tenant, wherein data objects or extensions to data objects of a particular tenant are not available to other tenants.
2 Assignments
0 Petitions
Accused Products
Abstract
An application server in a multi-tenant computing system is enabled access to a first set of tables and views in a database according to a first schema. The views in the first schema correspond to a table in a second schema. Thereafter, the table in the second schema is modified to add a column. Views of the modified table as defined by the second schema are generated in a third schema so that the third schema defines a second set of tables and views in the database. Subsequently, access by the application server to the second set of tables and views in the database is enabled and access by the application server to the first set of tables and views in the database is prevented. Related apparatus, systems, techniques and articles are also described.
-
Citations
15 Claims
-
1. A computer-implemented method comprising:
-
enabling, in a multi-tenant computing system, an application server to access a first set of tables and views in a database according to a first schema, each table being associated with one or more corresponding tenants of the multi-tenant computing system, the views in the first schema corresponding to a table in a second schema, the table in the second schema being associated with at least one tenant; modifying the table in the second schema to add a column, the modifying being performed separately for different tenants such that a software upgrade associated with each tenant occurs during a corresponding separate time period; generating views of the modified table as defined by the second schema in a third schema so that the third schema defines a second set of tables and views in the database; and enabling the application server to access the second set of tables and views in the database and preventing access by the application server to the first set of tables and views in the database; wherein; the multi-tenant computing system forms part of a multi-tenant environment using a single software delivery architecture, the separate software upgrade for each tenant allows the software upgrade of a first tenant to occur during a downtime for the first tenant and an uptime for a second tenant, the multi-tenant computing system comprises; at least one data repository containing; core software platform content relating to the operation of the multi-tenant computing system which is not modifiable by the multiple tenants; system content including data objects created in runtime by the multi-tenant computing system that are modifiable with data provided by a corresponding tenant, and tenant content including data objects or extensions to data objects that are customized for a corresponding tenant, wherein data objects or extensions to data objects of a particular tenant are not available to other tenants. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method comprising:
-
enabling, in a multi-tenant computing system, a first application server to access a first set of tables and views in a database according to a first schema, the views in the first schema corresponding to a table in a second schema; modifying a structure of the table in the second schema, the modifying being performed separately for different tenants of the multi-tenant computing system such that the separate modifying allows an upgrade of a first tenant to occur during a downtime for the first tenant and during an uptime for a second tenant; generating views of the modified table as defined by the second schema in a third schema so that the third schema defines a second set of tables and views in the database; and enabling a second application server to access the second set of tables and views in the database and preventing access by the first application server to the first set of tables and views in the database; wherein; the multi-tenant computing system forms part of a multi-tenant environment using a single software delivery architecture, the separate software upgrade for each tenant allows the software upgrade of a first tenant to occur during a downtime for the first tenant and an uptime for a second tenant, the multi-tenant computing system comprises; at least one data repository containing; core software platform content relating to the operation of the multi-tenant computing system which is not modifiable by the multiple tenants; system content including data objects created in runtime by the multi-tenant computing system that are modifiable with data provided by a corresponding tenant, and tenant content including data objects or extensions to data objects that are customized for a corresponding tenant, wherein data objects or extensions to data objects of a particular tenant are not available to other tenants. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A method for implementation in a database, the database comprising a first schema and a second schema having application tables, the first schema having first repository tables and first application views of the application tables, a first application server connecting to the database using the first schema, the method comprising:
-
generating a third repository schema having second repository tables; modifying a structure of the application tables in the second schema, the modifying being performed on a tenant-by-tenant basis such that a software upgrade associated with two or more tenants occurs during a separate time period, the separate software upgrade for each tenant comprising the software upgrade of a first tenant occurring during a downtime for the first tenant and an uptime for a second tenant; generating second application views in the third schema to reflect the modified structure of the application tables in the second schema; connecting a second application server to the database using the third schema; disabling access to the database by the first application server; and enabling access to the database by the second application server, wherein; the multi-tenant computing system forms part of a multi-tenant environment using a single software delivery architecture, the separate software upgrade for each tenant allows the software upgrade of a first tenant to occur during a downtime for the first tenant and an uptime for a second tenant, the multi-tenant computing system comprises; at least one data repository containing; core software platform content relating to the operation of the multi-tenant computing system which is not modifiable by the multiple tenants; system content including data objects created in runtime by the multi-tenant computing system that are modifiable with data provided by a corresponding tenant, and tenant content including data objects or extensions to data objects that are customized for a corresponding tenant, wherein data objects or extensions to data objects of a particular tenant are not available to other tenants. - View Dependent Claims (14, 15)
-
Specification