公开(公告)号：US20160266876A1

公开(公告)日：2016-09-15

申请号：US15164461

申请日：2016-05-25

Applicant: salesforce.com, inc.

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

IPC: G06F9/44

CPC classification number: G06F16/13 ,  G06F8/30 ,  G06F16/35

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.

公开(公告)号：US09031956B2

公开(公告)日：2015-05-12

申请号：US13691488

申请日：2012-11-30

Applicant: salesforce.com, inc.

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

IPC: G06F17/00 ,  G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30386 ,  G06F17/30598 ,  G06F17/30607

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating conversion and correction of data types for dynamic lightweight objects via a user interface in an on-demand services environment. In one embodiment and by way of example, a method includes receiving a first data file at a first computing device, identifying data types in the first data file that correspond to dynamic custom objects associated with the first data file, and linking the data types to their corresponding dynamic custom objects.

Abstract translation: 根据实施例，提供了用于在按需服务环境中经由用户界面促进动态轻量级对象的数据类型的转换和校正的机制和方法。 在一个实施例中，作为示例，一种方法包括在第一计算设备处接收第一数据文件，识别与第一数据文件相关联的动态自定义对象对应的第一数据文件中的数据类型，以及将数据类型链接到 他们对应的动态自定义对象。

公开(公告)号：US08996569B2

公开(公告)日：2015-03-31

申请号：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.

Abstract translation: 根据实施例，提供了用于便于在点播服务环境中评估动态轻量级对象的数据类型的机制和方法。 在一个实施例中，作为示例，一种方法包括响应于请求在第一计算设备上上传具有数据的数据文件，并且检测与数据文件内的数据相关的数据类型。 该检测包括扫描数据文件的数据行和数据列。 该方法还可以包括将检测到的数据类型分类成一个或多个类别，以及基于一个或多个类别创建一个或多个动态对象。

公开(公告)号：US11669510B2

公开(公告)日：2023-06-06

申请号：US16880222

申请日：2020-05-21

Applicant: salesforce.com, inc.

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

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

CPC classification number: G06F16/2358 ,  G06F16/214 ,  G06F16/24568 ,  G06F16/27 ,  G06F16/273 ,  G06F21/6218

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.

公开(公告)号：US10585852B2

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

申请号：US15164461

申请日：2016-05-25

Applicant: salesforce.com, inc.

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

IPC: G06F16/13 ,  G06F16/35 ,  G06F8/30

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.

公开(公告)号：US08996553B2

公开(公告)日：2015-03-31

申请号：US13691417

申请日：2012-11-30

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Sonali Agrawal

IPC: G06F17/30

CPC classification number: G06F17/30569 ,  G06F17/30076

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating management and customization of lightweight objects in an on-demand services environment. In one embodiment and by way of example, a method includes receiving, at a first computing device, a request a file having data and associated metadata in a format that is not supported by default objects of a software application. The method may further include generating one or more dynamic objects to support the requested format, generating the requested format using the one or more dynamic objects, and providing the file in the requested format via the software application.

Abstract translation: 根据实施例，提供了用于在按需服务环境中轻量化对象的管理和定制的机制和方法。 在一个实施例中并且作为示例，一种方法包括在第一计算设备处接收具有以软件应用的默认对象不支持的格式的具有数据和相关元数据的文件的请求。 该方法还可以包括生成一个或多个动态对象以支持所请求的格式，使用一个或多个动态对象生成所请求的格式，以及经由软件应用提供所请求格式的文件。

公开(公告)号：US20130283096A1

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

申请号：US13691488

申请日：2012-11-30

Applicant: SALESFORCE.COM, INC.

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

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30386 ,  G06F17/30598 ,  G06F17/30607

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating conversion and correction of data types for dynamic lightweight objects via a user interface in an on-demand services environment. In one embodiment and by way of example, a method includes receiving a first data file at a first computing device, identifying data types in the first data file that correspond to dynamic custom objects associated with the first data file, and linking the data types to their corresponding dynamic custom objects.

Abstract translation: 根据实施例，提供了用于在按需服务环境中经由用户界面促进动态轻量级对象的数据类型的转换和校正的机制和方法。 在一个实施例中，作为示例，一种方法包括在第一计算设备处接收第一数据文件，识别与第一数据文件相关联的动态自定义对象对应的第一数据文件中的数据类型，以及将数据类型链接到 他们对应的动态自定义对象。

公开(公告)号：US10803062B2

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

申请号：US15421063

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F16/00 ,  G06F16/2455 ,  G06F16/28 ,  G06F16/22

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY PARTITION 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; maintaining a plurality of tables within the multi-tenant database system to store the customer data, in which one or more of the tables is partitioned into a plurality of table partitions; receiving a database query specifying a command term to restrict a specified table accessed pursuant to execution of the database query by a partition_id parameter; 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 specified table within the multi-tenant database system to be restricted by the partition_id parameter; 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 accesses only a sub-portion of the specified table corresponding to exactly one table partition of the specified table having a partition ID matching the partition_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：US10776349B2

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

申请号：US15421076

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F16/00 ,  G06F16/242

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.

公开(公告)号：US10649987B2

公开(公告)日：2020-05-12

申请号：US15421092

申请日：2017-01-31

Applicant: salesforce.com, Inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F16/00 ,  G06F16/242 ,  G06F16/33

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.