公开(公告)号：US20140372484A1

公开(公告)日：2014-12-18

申请号：US14307301

申请日：2014-06-17

Applicant: SALESFORCE.COM, INC.

Inventor： Gary Baker ,  Scott Hansma ,  Christopher Wilson Kifuthu

IPC: G06F17/30

CPC classification number: G06F16/27

Abstract: Techniques for database multiplexing. Within a group of two or more logical databases, each having a plurality of database nodes, the group of logical databases being part of a multitenant database environment that stores data for multiple client entities each identified by a tenant identifier (ID) having one of one or more users associated with the tenant ID, wherein users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity, and wherein the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities, the tenant ID is used to determine a mapping between the tenant ID and one of the plurality of logical databases. A plurality of application servers coupled with two or more of the logical databases are used to service requests received from remote client device using the mapping to access a selected logical database corresponding to the tenant ID.

Abstract translation: 数据库复用技术。 在两个或更多个逻辑数据库的组中，每个逻辑数据库具有多个数据库节点，所述逻辑数据库组是多租户数据库环境的一部分，其存储多个客户实体的数据，每个客户端实体由租户标识符（ID）标识，租户标识符（ID） 或多个与租户ID相关联的用户，其中多个客户端实体中的每一个的用户只能访问由与相应客户端实体相关联的租户ID标识的数据，并且其中所述多租户数据库是由与所述客户端分离的实体提供的托管数据库 实体，并且向客户实体提供按需数据库服务，租户ID用于确定租户ID与多个逻辑数据库中的一个之间的映射。 与两个或多个逻辑数据库耦合的多个应用服务器被用于使用映射访问从远程客户端设备接收的请求，以访问对应于租户ID的所选择的逻辑数据库。

公开(公告)号：US11314770B2

公开(公告)日：2022-04-26

申请号：US14307301

申请日：2014-06-17

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Scott Hansma ,  Christopher Wilson Kifuthu

IPC: G06F16/27

Abstract: Techniques for database multiplexing. Within a group of two or more logical databases, each having a plurality of database nodes, the group of logical databases being part of a multitenant database environment that stores data for multiple client entities each identified by a tenant identifier (ID) having one of one or more users associated with the tenant ID, wherein users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity, and wherein the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities, the tenant ID is used to determine a mapping between the tenant ID and one of the plurality of logical databases. A plurality of application servers coupled with two or more of the logical databases are used to service requests received from remote client device using the mapping to access a selected logical database corresponding to the tenant ID.