Providing consistent tenant experiences for multi-tenant databases

摘要

The present invention extends to methods, systems, and computer program products for providing consistent tenant experiences at multi-tenant database. Embodiments of the invention include an import service that facilitates data imports without any distribution logic on a tenant. A tenant (caller) provides data in essentially any order. The import service understands the distribution of data across multiple databases and determines for any given piece of import data what database the import data is to be inserted into. Accordingly, the tenant (caller) is relieved from having to know how the data is distributed across a set (of potentially hundreds or thousands) of databases. The import service can optimize an import process to provide load balancing and fairness across a dynamic distributed database system. For example, the import service can insure that a large import by one tenant does not deprive the import other tenants of appropriate resources.

主权项

1. At a computer system, the computer system including a processor and system memory, the computer system included in a dynamic distributed database system, the dynamic distributed database system maintaining a plurality of databases across a plurality of nodes, a method for providing a consistent user experience when importing data into databases maintained by the dynamic distributed database system, the method comprising:
accessing first data, the first data associated with a tenant of a dynamic distributed database system, the first data having a plurality of data portions, each of the plurality of data portions having values within one or more ranges of a database of the tenant; importing one or more data portions, from among the plurality of data portions, into the dynamic distributed database system, including for each of the one or more data portions:
referring to a global partition map for the dynamic distributed database system to schedule the data portion for insertion into an appropriate database for the tenant, the appropriate database for the tenant at a node of the dynamic distributed database system; accessing second data, the second data associated with a second tenant of the dynamic distributed database system, the second data having values within one or more ranges of a database of the second tenant; suspending import of the first data subsequent to accessing the second data and prior to completing import of all of the plurality of data portions such that a one or more data portions, from among the plurality of data portions, remain to be processed; subsequent to suspending importing the first data into the dynamic distributed database system, importing a portion of the second data into the dynamic distributed database system, including:
referring to the global partition map to schedule the portion of the second data for insertion into appropriate database for the second tenant, the appropriate database for the second tenant at a node of the dynamic distributed database system.