Microsoft Technology Licensing, LLC

Marc Windle

Alexander Hopmann

Balinder Malhi

Zach Rosenfield

Jason Matthew Cahill

Eric B Fox

Patrick Simek

Erick Raymundo Lerma

An online service includes databases that are upgraded while still processing requests. For example, web servers continue to request operations on the database while it is being upgraded. The schema of the database is upgraded before the web servers are upgraded to utilize the upgraded schema. Changes that are made to the upgraded schema are backwards compatible with the schema being used during the upgrade process. Restrictions are placed on the operations performed on the database during the upgrade process. After upgrading the schema, the web servers of the online service are upgraded to use the upgraded schema.

Online database availability during upgrade

An online service includes managed databases that include one or more tenants (e.g. customers, users). A multi-tenant database may be split between two or more databases while the database being split continues processing requests. For example, web servers continue to request operations on the database while content is being moved. After moving the content, tenant traffic is automatically redirected to the database that contains the tenant's content.

Dynamically splitting multi-tenant databases

Growing community of inventors

Abbotsford, Canada

Marc Windle