Pre-deployment of configuration settings using shared container technology

A computer-implemented method, comprising:

• generating a customized table based on a database table, the database table comprising a dataset including a tenant identifier field, key fields, and data fields, wherein generating the customized table removes the tenant identifier field;
• generating a view of the database table, wherein the view defines joins from the customized table and a centralized table, wherein the customized table comprises customer key ranges and the centralized table comprises vendor key ranges;
• creating a pointer from the view to the customized table and the centralized table that causes a request to be redirected to the customized table or the centralized table;
• defining one or more instead-of triggers used to modify the view upon an insert, upsert, or update operation on the view;
• executing the one or more instead-of triggers in response to a modification action to the view, wherein the one or more instead-of triggers determines whether the modification action applies to a customer key range or a vendor key range;
• redirecting the modification action to the customized table in response to a determination that the modification action applies to the customer key range, wherein a structured query language select function that identifies a criterion for record selection in the customer key range reads data from the customized table and writes data to the customized table;
• blocking the modification action in response to a determination that the modification action applies to the vendor key range;
• and
• automatically distributing updates to tenants.

A non-transitory computer readable storage medium storing instructions, which when executed by at least one data processor, result in operations comprising:

• generating a customized table based on a database table, the database table comprising a dataset including a tenant identifier field, key fields, and data fields, wherein generating the customized table removes the tenant identifier field;
• generating a view of the database table, wherein the view defines joins from the customized table and a centralized table, wherein the customized table comprises customer key ranges and the centralized table comprises vendor key ranges;
• creating a pointer from the view to the customized table and the centralized table that causes a request to be redirected to the customized table or the centralized table;
• defining one or more instead-of triggers used to modify the view upon an insert, upsert, or update operation on the view;
• executing the one or more instead-of triggers in response to a modification action to the view, wherein the one or more instead-of triggers determines whether the modification action applies to a customer key range or a vendor key range;
• redirecting the modification action to the customized table in response to a determination that the modification action applies to the customer key range, wherein a structured query language select function that identifies a criterion for record selection in the customer key range reads data from the customized table and writes data to the customized table;
• blocking the modification action in response to a determination that the modification action applies to the vendor key range;
• and
• automatically distributing updates to tenants.