公开(公告)号：US20180218030A1

公开(公告)日：2018-08-02

申请号：US15421036

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

CPC classification number: G06F16/2425

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement filters every reference to the one or more tables by the organization_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：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的所选择的逻辑数据库。

公开(公告)号：US20130282720A1

公开(公告)日：2013-10-24

申请号：US13691452

申请日：2012-11-30

Applicant: SALESFORCE.COM, INC.

Inventor： Gary Baker ,  Sonali Agrawal ,  James Ferguson ,  Frank Lopez ,  Jamie No

IPC: G06F17/30

CPC classification number: G06F17/30091 ,  G06F8/30 ,  G06F17/30705

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating evaluation of data types for dynamic lightweight objects in an on-demand services environment. In one embodiment and by way of example, a method includes uploading a data file having data at a first computing device in response to a request, and detecting data types relating to the data within the data file. The detecting includes scanning data rows and data columns of the data file. The method may further include classifying the detected data types into one or more categories, and creating one or more dynamic objects based on the one or more categories.

公开(公告)号：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.

公开(公告)号：US20200285627A1

公开(公告)日：2020-09-10

申请号：US16880222

申请日：2020-05-21

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Mikhail Chainani ,  Varun Jobanputra ,  William Dumaresq

IPC: G06F16/23 ,  G06F21/62 ,  G06F16/27 ,  G06F16/21 ,  G06F16/2455

Abstract: Technology for tracking changes to a database and providing the changes to a subscribing computing device. In an illustrative implementation, a method may involve subscribing a computing device to changes of a portion of a multi-tenant database and accessing a plurality of change events stored in a log of the multi-tenant database in parallel. The method may further involve storing the plurality of change events in a persistent data store separate from the multi-tenant database and processing the plurality of change events to create an ordered set of change events. The ordered set of change events may then be provided to the computing device that subscribed to the changes.

公开(公告)号：US20190065542A1

公开(公告)日：2019-02-28

申请号：US15686640

申请日：2017-08-25

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Mikhail Chainani ,  Varun Jobanputra ,  William Dumaresq

IPC: G06F17/30 ,  G06F21/62

Abstract: Technology for tracking changes to a database and providing the changes to a subscribing computing device. In an illustrative implementation, a method may involve subscribing a computing device to changes of a portion of a multi-tenant database and accessing a plurality of change events stored in a log of the multi-tenant database in parallel. The method may further involve storing the plurality of change events in a persistent data store separate from the multi-tenant database and processing the plurality of change events to create an ordered set of change events. The ordered set of change events may then be provided to the computing device that subscribed to the changes.

公开(公告)号：US20180218031A1

公开(公告)日：2018-08-02

申请号：US15421076

申请日：2017-01-31

Applicant: salesforce.com. Inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing dynamic macros within a multi-tenant aware structured query language operable within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a dynamic macro function call to be executed at runtime and replaced with a string within a new structured query language statement to be executed against the multi-tenant database system; parsing the database query to identify the dynamic macro function call specified; parsing the database query to identify a functional expression to be evaluated at runtime as passed with the dynamic macro function call specified; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement includes the string in place of the dynamic macro function call or a functional call executable by the multi-tenant database system at runtime to be resolved to the string by the multi-tenant database during execution of the new structured query language statement; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：US09465806B2

公开(公告)日：2016-10-11

申请号：US14672314

申请日：2015-03-30

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Sonali Thomas Agrawal ,  James Ferguson ,  Frank Lopez ,  Jamie No

IPC: G06F17/30

CPC classification number: G06F17/30091 ,  G06F8/30 ,  G06F17/30705

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating evaluation of data types for dynamic lightweight objects in an on-demand services environment. In one embodiment and by way of example, a method includes uploading a data file having data at a first computing device in response to a request, and detecting data types relating to the data within the data file. The detecting includes scanning data rows and data columns of the data file. The method may further include classifying the detected data types into one or more categories, and creating one or more dynamic objects based on the one or more categories.

公开(公告)号：US10678773B2

公开(公告)日：2020-06-09

申请号：US15686640

申请日：2017-08-25

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Mikhail Chainani ,  Varun Jobanputra ,  William Dumaresq

IPC: G06F16/27 ,  G06F16/23 ,  G06F21/62 ,  G06F16/21 ,  G06F16/2455

Abstract: Technology for tracking changes to a database and providing the changes to a subscribing computing device. In an illustrative implementation, a method may involve subscribing a computing device to changes of a portion of a multi-tenant database and accessing a plurality of change events stored in a log of the multi-tenant database in parallel. The method may further involve storing the plurality of change events in a persistent data store separate from the multi-tenant database and processing the plurality of change events to create an ordered set of change events. The ordered set of change events may then be provided to the computing device that subscribed to the changes.

公开(公告)号：US20180218032A1

公开(公告)日：2018-08-02

申请号：US15421092

申请日：2017-01-31

Applicant: Salesforce.com, Inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

CPC classification number: G06F16/2425 ,  G06F16/3341

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to conditionally execute a sub-portion of the database query when a Boolean evaluation specified with the database query resolves to true and to negate execution of the sub-portion of the database query when the Boolean evaluation resolves to false; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the sub-portion of the database query to be conditionally executed or negated pursuant to the Boolean evaluation; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement includes a semantic structure to execute the sub-portion of the database query when the Boolean evaluation resolves to true and to omit from execution the sub-portion of the database query when the Boolean evaluation resolves to false; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.