公开(公告)号：US11132354B2

公开(公告)日：2021-09-28

申请号：US16235300

申请日：2018-12-28

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F16/20 ,  G06F16/23 ,  G06F16/11 ,  G06F16/951

Abstract: Embodiments regard maintaining data consistency between transactional and non-transactional data stores. Embodiments may include receiving a request to archive a set of data stored in a first data store, recording a high water mark in the first data store for the set of data, and archiving the set of data. Archiving the set of data may include copying the set of data into a second data store and inserting a high water mark for the set of data in the first data store and the second data store. Embodiments may further include updating a reference high water mark upon successful completion of operations for the archiving of the data, the reference high water mark representing completion of a last successful archive operation, and, upon receiving a query for requested data contained in the first or second data store, determining whether to allow viewing of the requested data based at least in part on a current value of the reference high water mark.

公开(公告)号：US11036731B2

公开(公告)日：2021-06-15

申请号：US16701007

申请日：2019-12-02

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/25 ,  G06F16/242 ,  G06F16/2455

Abstract: Techniques for providing polymorphic query requests. A request is received that has at least a database query. The database query comprises at least an expression using a polymorphic relationship. The request is processed utilizing the polymorphic relationship. A user-readable result is provided for the query where the result is defined by at least the polymorphic relationship.

公开(公告)号：US09396231B2

公开(公告)日：2016-07-19

申请号：US13923230

申请日：2013-06-20

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F17/30

CPC classification number: G06F17/30528 ,  G06F17/30424 ,  G06F17/30483 ,  G06F17/30507 ,  G06F17/30554 ,  G06F17/30587

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamically controlled fetching of data at client computing devices in an on-demand services environment in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a server computing device, a request from a client computing device. The request includes a query for receiving data from a database coupled to the server computing device in an on-demand database system. The method may further include matching the request against a predetermine threshold value, and where the threshold value includes a first predetermined threshold range based on a first column range or a first row range and a second predetermined threshold range based on a second column range or a second row range. The method may further include generating multiple responses to the request based on one or more formulae and the predetermined threshold value if the request fails to satisfy the predetermined threshold value.

Abstract translation: 根据实施例，根据一个实施例，提供了用于在多租户环境中的按需服务环境中促进在客户计算设备处动态控制的数据提取的机制和方法。 在一个实施例中，作为示例，一种方法包括在服务器计算设备处接收来自客户端计算设备的请求。 该请求包括用于从按需数据库系统中耦合到服务器计算设备的数据库接收数据的查询。 该方法还可以包括将该请求与预定阈值进行匹配，并且其中基于第一列范围或基于第二列范围或第二列范围的第一列范围和第二预定阈值范围，阈值包括第一预定阈值范围 第二排范围。 该方法还可以包括：如果请求不满足预定阈值，则基于一个或多个公式和预定阈值来生成针对该请求的多个响应。

公开(公告)号：US20190205296A1

公开(公告)日：2019-07-04

申请号：US16299042

申请日：2019-03-11

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F16/248 ,  G06F16/2455

CPC classification number: G06F16/248 ,  G06F16/2455

Abstract: Techniques for optimizing result presentation for a database query. A database query is received. The database query is performed with a clause indicating one or more offset values to be used in displaying results from the database query. The one or more offset values indicate a subset within the results from the database query to be presented. An order is imposed on the results from the database query. The subset is presented as determined by the one or more offset values.

公开(公告)号：US10169396B2

公开(公告)日：2019-01-01

申请号：US14670363

申请日：2015-03-26

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F17/30

Abstract: Embodiments regard maintaining data consistency between transactional and non-transactional data stores. Embodiments may include receiving a request to archive a set of data stored in a first data store, recording a high water mark in the first data store for the set of data, and archiving the set of data. Archiving the set of data may include copying the set of data into a second data store and inserting a high water mark for the set of data in the first data store and the second data store. Embodiments may further include updating a reference high water mark upon successful completion of operations for the archiving of the data, the reference high water mark representing completion of a last successful archive operation, and, upon receiving a query for requested data contained in the first or second data store, determining whether to allow viewing of the requested data based at least in part on a current value of the reference high water mark.

公开(公告)号：US09569509B2

公开(公告)日：2017-02-14

申请号：US14013687

申请日：2013-08-29

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30554 ,  G06F17/30477

Abstract: Techniques for optimizing result presentation for a database query. A database query is received. The database query is performed with a clause indicating one or more offset values to be used in displaying results from the database query. The one or more offset values indicate a subset within the results from the database query to be presented. An order is imposed on the results from the database query. The subset is presented as determined by the one or more offset values.

Abstract translation: 用于优化数据库查询的结果呈现的技术。 接收到数据库查询。 使用一个子句来执行数据库查询，该子句指示用于显示数据库查询中的结果的一个或多个偏移值。 一个或多个偏移值指示要呈现的数据库查询的结果内的子集。 对数据库查询的结果施加了一个顺序。 所述子集由所述一个或多个偏移值确定。

公开(公告)号：US20150278288A1

公开(公告)日：2015-10-01

申请号：US14670363

申请日：2015-03-26

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F17/30371 ,  G06F17/30073 ,  G06F17/30864

Abstract: Embodiments regard maintaining data consistency between transactional and non-transactional data stores. Embodiments may include receiving a request to archive a set of data stored in a first data store, recording a high water mark in the first data store for the set of data, and archiving the set of data. Archiving the set of data may include copying the set of data into a second data store and inserting a high water mark for the set of data in the first data store and the second data store. Embodiments may further include updating a reference high water mark upon successful completion of operations for the archiving of the data, the reference high water mark representing completion of a last successful archive operation, and, upon receiving a query for requested data contained in the first or second data store, determining whether to allow viewing of the requested data based at least in part on a current value of the reference high water mark.

Abstract translation: 实现在事务和非事务性数据存储之间保持数据一致性。 实施例可以包括接收对存储在第一数据存储器中的一组数据进行存档的请求，在第一数据存储器中记录用于该组数据的高水位标记，以及存储该组数据。 归档该数据集可以包括将该组数据复制到第二数据存储器中，并且在第一数据存储器和第二数据存储器中为该组数据插入高水位标记。 实施例还可以包括在成功完成用于数据存档的操作之后更新参考高水位标记，表示最后成功归档操作的完成的参考高水位标记，以及在接收到对包含在第一或第 第二数据存储器，至少部分地基于所述参考高水位标记的当前值确定是否允许查看所请求的数据。

公开(公告)号：US11232118B2

公开(公告)日：2022-01-25

申请号：US16299042

申请日：2019-03-11

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F7/00 ,  G06F16/248 ,  G06F16/2455

Abstract: Techniques for optimizing result presentation for a database query. A database query is received. The database query is performed with a clause indicating one or more offset values to be used in displaying results from the database query. The one or more offset values indicate a subset within the results from the database query to be presented. An order is imposed on the results from the database query. The subset is presented as determined by the one or more offset values.

公开(公告)号：US10810205B2

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

申请号：US15204808

申请日：2016-07-07

Applicant: salesforce.com, inc.

Inventor： Seth John White

IPC: G06F16/2455 ,  G06F16/2457

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamically controlled fetching of data at client computing devices in an on-demand services environment in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a server computing device, a request from a client computing device. The request includes a query for receiving data from a database coupled to the server computing device in an on-demand database system. The method may further include matching the request against a predetermine threshold value, and where the threshold value includes a first predetermined threshold range based on a first column range or a first row range and a second predetermined threshold range based on a second column range or a second row range. The method may further include generating multiple responses to the request based on one or more formulae and the predetermined threshold value if the request fails to satisfy the predetermined threshold value.

公开(公告)号：US10721323B2

公开(公告)日：2020-07-21

申请号：US16225897

申请日：2018-12-19

Applicant: salesforce.com, inc.

Inventor： Seth John White ,  Guillaume Le Stum ,  Benjamin Shaw

IPC: G06F15/16 ,  H04L29/08 ,  G06F16/182 ,  G06F16/901 ,  H04L29/06

Abstract: High performance data streaming is provided. An intermediate iterator receives a request to process streaming data in a parent request buffer from a parent iterator. The intermediate iterator sends a request to provide a batch of the streaming data in a request child buffer to a child iterator. The intermediate iterator receives the batch of the streaming data in a child response buffer from the child iterator. The intermediate iterator processes the batch of the streaming data. The intermediate iterator sends the processed batch of the streaming data in a response parent buffer to the parent iterator.