US 10,706,025 B2Granted

Database system providing single-tenant and multi-tenant environments

AssigneeAmazon Technologies, Inc.

InventorsSwaminathan Sivasubramanian, Stefano Stefani

Life of this patent

Estimating the term…

Loading patent…

Abstract

A database service may provide multi-tenant and single-tenant environments in which tables may be maintained on behalf of clients. The service (or underlying system) may create database instances and tables in either or both types of environments (e.g., by default or according to various parameter values specified in requests to create the instances or tables). When receiving and servicing requests directed to a table hosted in a single-tenant environment, the system may elide at least some of the authentication or metering operations that would be performed when servicing requests directed to tables hosted in a multi-tenant environment. Tables may be moved from a single-tenant environment to a multi-tenant environment, or vice versa, automatically by the system (e.g., dependent on an observed, expected, or desired throughput) or in response to an explicit request from a client to do so (e.g., to increase throughput or reduce cost).

Claims24

Dependent claims

A system, comprising:

one or more processors;
a memory coupled to the one or more processors;
and
one or more storage nodes;
wherein the memory stores program instructions that when executed by the one or more processors cause the one or more processors to implement a database service that provides database services in a multi-tenant environment and in a single-tenant environment to one or more database service clients, wherein a multi-tenant environment comprises an environment in which database tables for multiple clients are hosted collectively in a single database instance, and wherein a single-tenant environment comprises an environment in which database tables for different clients are hosted in different database instances;
wherein the database service is configured to:
receive a request from a client to create a database instance, wherein the request specifies that the database instance is to be created in a multi-tenant environment;
provision one or more of the one or more storage nodes to create a database instance in a multi-tenant environment on behalf of the requesting client;
receive a request from a client to create another database instance, wherein the request specifies that the other database instance is to be created in a single-tenant environment;
provision one or more of the one or more storage nodes to create a database instance in a single-tenant environment on behalf of the requesting client;
receive a request from a client to create a table, wherein the request specifies whether the table is to be created in database instance in a multi-tenant environment or in a single-tenant environment;
and
create a table in a database instance in the specified environment.

10 more elements

A method, comprising:

performing by one or more computers that implement a database service that provides database services in a multi-tenant environment and in a single-tenant environment to database service clients, wherein the multi-tenant environment comprises an environment in which at least portions of tables for multiple clients are hosted collectively in a single database instance or storage node:
receiving a request to create a table;
in response to said receiving,
creating the table in a database instance in a given one of:
the multi-tenant environment or the single-tenant environment, wherein one or more storage nodes were provisioned to create the database instance in the given environment;
receiving and servicing one or more requests to perform database operations that target the table;
and
subsequent to said receiving and servicing:
moving the table to a database instance in the other one of:
the multi-tenant environment or the single-tenant environment, wherein one or more other storage nodes were provisioned to create the database instance in the other environment;
and
receiving and servicing one or more additional requests to perform database operations that target the table.

9 more elements

A non-transitory, computer-readable storage medium storing program instructions that when executed on one or more computers cause the one or more computers to perform:

receiving a request to create a database table;
in response to said receiving, creating a database table in a database instance in a single-tenant environment of a database service that provides database services in a multi-tenant environment and in the single-tenant environment to database service clients, wherein the multi-tenant environment comprises an environment in which at least portions of tables for multiple clients are hosted collectively in a single database instance or storage node, wherein one or more storage nodes were provisioned to create the database instance in the single-tenant environment;
receiving and servicing one or more requests to access the database table;
determining that the database table should be moved to a database instance in the multi-tenant environment, dependent on an observed, expected, or desired throughput for receiving or servicing requests, wherein one or more other storage nodes were provisioned to create the database instance in the multi-tenant environment;
and
in response to said determining, moving the database table to a database instance in the multi-tenant environment.

3 more elements

A system, comprising:

one or more computers;
and
a memory storing program instructions that when executed on the one or more computers cause the one or more computers to perform:
receiving a request to create a database table;
in response to said receiving, creating a database table in database instance in a multi-tenant environment of a database service that provides database services in the multi-tenant environment and in a single-tenant environment to database service clients, wherein the multi-tenant environment comprises an environment in which at least portions of tables for multiple clients are hosted collectively in a single database instance or storage node, and wherein one or more storage nodes were provisioned to create the database instance in the multi-tenant environment;
receiving and servicing one or more requests to access the database table;
determining that at least a portion of the database table should be moved to a database instance in the single-tenant environment, dependent on an observed, expected, or desired throughput for receiving or servicing requests, wherein one or more other storage nodes were provisioned to create the database instance in the single-tenant environment;
and
in response to said determining, moving the at least a portion of the database table to a database instance in the single-tenant environment.

6 more elements

Dependencies are inferred from the claim text.