公开(公告)号：US10761829B2

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

申请号：US16006193

申请日：2018-06-12

Applicant: salesforce.com, inc.

Inventor： Saptarshi Roy ,  Daniel C. Silver ,  Donovan A. Schneider ,  Medha Pradhan ,  Ryan Lamore ,  Naveen Purushothama Rao ,  Nicholas Geh ,  Srirama Koneru

IPC: G06F9/44 ,  G06F8/65 ,  H04L29/08 ,  G06F9/50

Abstract: Methods are disclosed for dynamic node allocation for a server system that can automatically heal on failure—minimizing the need for static configuration—dynamically adjusting server resources to match load, and minimize end user wait times. The disclosed methods dynamically allocate nodes to increase capacity for a platform that accepts data queries. Additionally disclosed is a system for rolling version update deployment: workers maintain org lists of org-task-queues that they service; org-affinities between the workers and the org-task-queues require the workers to have access to local copies of immutable data sets to service org-tasks from the org-task-queues of the orgs that they service. A leader running on a worker implements a healing and balancing service that maintains worker redundancy, manages the workers' org-affinities to accumulate orgs on their respective org-lists. The leader implements messaging to the workers to update to a new software version and monitors completion of updates.

公开(公告)号：US09600548B2

公开(公告)日：2017-03-21

申请号：US14512230

申请日：2014-10-10

Applicant: salesforce.com, inc.

Inventor： Donovan A. Schneider ,  Daniel C. Silver ,  Fred Im ,  Vijayasarathy Chakravarthy

IPC: G06F21/62 ,  G06F17/30 ,  H04L29/06

CPC classification number: G06F21/6227 ,  G06F17/30227 ,  G06F17/30563 ,  H04L63/08 ,  H04L63/102

Abstract: A predicate-based row level security system is used when workers build or split an analytical data store. According to one implementation, predicate-based means that security requirements of source transactional systems can be used as predicates to a rule base that generates one or more security tokens, which are associated with each row as attributes of a dimension. Similarly, when an analytic data store is to be split, build job, user and session attributes can be used to generate complementary security tokens that are compared to security tokens of selected rows. Efficient indexing of a security tokens dimension makes it efficient to qualify row retrieval based on security criteria.

公开(公告)号：US10001983B2

公开(公告)日：2018-06-19

申请号：US15221496

申请日：2016-07-27

Applicant: salesforce.com, inc.

Inventor： Saptarshi Roy ,  Daniel C. Silver ,  Donovan Schneider ,  Medha Pradhan ,  Ryan Lamore ,  Naveen Purushothama Rao ,  Nicholas Geh ,  Srirama Koneru

IPC: G06F9/44 ,  G06F9/445 ,  H04L29/08

CPC classification number: G06F8/65 ,  G06F9/50 ,  H04L67/34

Abstract: Methods are disclosed for dynamic node allocation for a server system that can automatically heal on failure—minimizing the need for static configuration—dynamically adjusting server resources to match load, and minimize end user wait times. The disclosed methods dynamically allocate nodes to increase capacity for a platform that accepts data queries. Additionally disclosed is a system for rolling version update deployment: workers maintain org lists of org-task-queues that they service; org-affinities between the workers and the org-task-queues require the workers to have access to local copies of immutable data sets to service org-tasks from the org-task-queues of the orgs that they service. A leader running on a worker implements a healing and balancing service that maintains worker redundancy, manages the workers' org-affinities to accumulate orgs on their respective org-lists. The leader implements messaging to the workers to update to a new software version and monitors completion of updates.

公开(公告)号：US20160103914A1

公开(公告)日：2016-04-14

申请号：US14512274

申请日：2014-10-10

Applicant: salesforce.com, inc.

Inventor： Fred Im ,  Daniel C. Silver ,  Didier Prophete ,  Donovan Schneider ,  Vijayasarathy Chakravarthy

IPC: G06F17/30 ,  H04L29/08

CPC classification number: G06F16/951 ,  G06F16/24539 ,  G06F16/2455 ,  H04L63/20 ,  H04L67/1002

Abstract: Aggressive exploration can involve multiple, successive queries and visualizations. This creates difficulty scaling the resources needed to deliver fast responses. It is particularly complicated by regular rebuilding of analytic data stores, whether daily or on demand. Migrating queries using the technology described involves migrating indexed fields, known as dimensions, and quantity fields, known as measures, in the background during a query session. A session that starts in server query processing mode may switch to client query processing as enough data fields have been copied from the server to the client. When the client determines that it has enough data fields to process an incoming query, it can locally process the new query without passing it to the server. Since both the server and client are working from copies of the same read only analytic data structure, a user receives the same results from either client or the server.

Abstract translation: 积极的探索可以涉及多个连续的查询和可视化。 这就难以扩展提供快速响应所需的资源。 无论是日常还是按需，定期重建分析数据存储区尤其复杂。 使用所描述的技术迁移查询涉及在查询会话期间在后台迁移称为维度的索引字段和称为度量的数量字段。 从服务器查询处理模式开始的会话可以切换到客户端查询处理，因为足够的数据字段已从服务器复制到客户端。 当客户端确定它具有足够的数据字段来处理传入查询时，它可以本地处理新查询而不将其传递到服务器。 由于服务器和客户端都是从相同的只读分析数据结构的副本进行工作，所以用户从客户端或服务器接收到相同的结果。

公开(公告)号：US10671751B2

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

申请号：US15439637

申请日：2017-02-22

Applicant: salesforce.com, inc.

Inventor： Donovan A. Schneider ,  Daniel C. Silver ,  Fred Im ,  Vijayasarathy Chakravarthy

IPC: G06F21/62 ,  G06F16/25 ,  G06F16/18 ,  H04L29/06

Abstract: A predicate-based row level security system is used when workers build or split an analytical data store. According to one implementation, predicate-based means that security requirements of source transactional systems can be used as predicates to a rule base that generates one or more security tokens, which are associated with each row as attributes of a dimension. Similarly, when an analytic data store is to be split, build job, user and session attributes can be used to generate complementary security tokens that are compared to security tokens of selected rows. Efficient indexing of a security tokens dimension makes it efficient to qualify row retrieval based on security criteria.

公开(公告)号：US10412158B2

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

申请号：US15221486

申请日：2016-07-27

Applicant: salesforce.com, inc.

Inventor： Saptarshi Roy ,  Daniel C. Silver ,  Donovan Schneider ,  Medha Pradhan ,  Ryan Lamore ,  Naveen Purushothama Rao ,  Nicholas Geh ,  Srirama Koneru

IPC: H04L29/08 ,  H04L12/24 ,  G06F11/20

Abstract: Methods are disclosed for dynamic node allocation for a server system that can automatically heal on failure—minimizing the need for static configuration—dynamically adjusting server resources to match load, and minimize end user wait times. The disclosed methods dynamically allocate nodes to increase capacity for a platform that accepts data queries. Additionally disclosed is a system for rolling version update deployment: workers maintain org lists of org-task-queues that they service; org-affinities between the workers and the org-task-queues require the workers to have access to local copies of immutable data sets to service org-tasks from the org-task-queues of the orgs that they service. A leader running on a worker implements a healing and balancing service that maintains worker redundancy, manages the workers' org-affinities to accumulate orgs on their respective org-lists. The leader implements messaging to the workers to update to a new software version and monitors completion of updates.

公开(公告)号：US20180293063A1

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

申请号：US16006193

申请日：2018-06-12

Applicant: salesforce.com, inc.

Inventor： Saptarshi Roy ,  Daniel C. Silver ,  Donovan A. Schneider ,  Medha Pradhan ,  Ryan Lamore ,  Naveen Purushothama Rao ,  Nicholas Geh ,  Srirama Koneru

IPC: G06F8/65 ,  H04L29/08

Abstract: Methods are disclosed for dynamic node allocation for a server system that can automatically heal on failure—minimizing the need for static configuration—dynamically adjusting server resources to match load, and minimize end user wait times. The disclosed methods dynamically allocate nodes to increase capacity for a platform that accepts data queries. Additionally disclosed is a system for rolling version update deployment: workers maintain org lists of org-task-queues that they service; org-affinities between the workers and the org-task-queues require the workers to have access to local copies of immutable data sets to service org-tasks from the org-task-queues of the orgs that they service. A leader running on a worker implements a healing and balancing service that maintains worker redundancy, manages the workers' org-affinities to accumulate orgs on their respective org-lists. The leader implements messaging to the workers to update to a new software version and monitors completion of updates.

公开(公告)号：US20170161515A1

公开(公告)日：2017-06-08

申请号：US15439637

申请日：2017-02-22

Applicant: salesforce.com, inc.

Inventor： Donovan A. Schneider ,  Daniel C. Silver ,  Fred Im ,  Vijayasarathy Chakravarthy

IPC: G06F21/62 ,  G06F17/30 ,  H04L29/06

Abstract: A predicate-based row level security system is used when workers build or split an analytical data store. According to one implementation, predicate-based means that security requirements of source transactional systems can be used as predicates to a rule base that generates one or more security tokens, which are associated with each row as attributes of a dimension. Similarly, when an analytic data store is to be split, build job, user and session attributes can be used to generate complementary security tokens that are compared to security tokens of selected rows. Efficient indexing of a security tokens dimension makes it efficient to qualify row retrieval based on security criteria.

公开(公告)号：US09396018B2

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

申请号：US14512240

申请日：2014-10-10

Applicant: salesforce.com, inc.

Inventor： Donovan Schneider ,  Fred Im ,  Daniel C. Silver ,  Vijayasarathy Chakravarthy

IPC: G06F9/46 ,  G06F9/48

CPC classification number: G06F17/30557

Abstract: Low latency communication between a transactional system and analytic data store resources can be accomplished through a low latency key-value store with purpose-designed queues and status reporting channels. Posting by the transactional system to input queues and complementary posting by analytic system workers to output queues is described. On-demand production and splitting of analytic data stores requires significant elapsed processing time, so a separate process status reporting channel is described to which workers can periodically post their progress, thereby avoiding progress inquiries and interruptions of processing to generate report status. This arrangement produces low latency and reduced overhead for interactions between the transactional system and the analytic data store system.

Abstract translation: 可以通过具有目的设计的队列和状态报告通道的低延迟密钥值存储来实现事务系统和分析数据存储资源之间的低延迟通信。 描述事务处理系统将分析系统工作人员输入队列和补充发布到输出队列。 分析数据存储的按需生产和拆分需要大量经过的处理时间，因此描述了单独的进程状态报告通道，工作人员可以定期向其发布进度，从而避免进度查询和中断处理以生成报告状态。 这种安排为交易系统和分析数据存储系统之间的交互产生低延迟并减少开销。

公开(公告)号：US20180034904A1

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

申请号：US15221486

申请日：2016-07-27

Applicant: salesforce.com, inc.

Inventor： Saptarshi Roy ,  Daniel C. Silver ,  Donovan Schneider ,  Medha Pradhan ,  Ryan Lamore ,  Naveen Purushothama Rao ,  Nicholas Geh ,  Srirama Koneru

IPC: H04L29/08 ,  H04L12/24 ,  G06F11/20

CPC classification number: H04L67/1034 ,  G06F11/2025 ,  G06F11/2041 ,  G06F11/2048 ,  G06F11/3442 ,  H04L41/046 ,  H04L41/082 ,  H04L67/1031 ,  H04L67/1095

Abstract: Methods are disclosed for dynamic node allocation for a server system that can automatically heal on failure—minimizing the need for static configuration—dynamically adjusting server resources to match load, and minimize end user wait times. The disclosed methods dynamically allocate nodes to increase capacity for a platform that accepts data queries. Additionally disclosed is a system for rolling version update deployment: workers maintain org lists of org-task-queues that they service; org-affinities between the workers and the org-task-queues require the workers to have access to local copies of immutable data sets to service org-tasks from the org-task-queues of the orgs that they service. A leader running on a worker implements a healing and balancing service that maintains worker redundancy, manages the workers' org-affinities to accumulate orgs on their respective org-lists. The leader implements messaging to the workers to update to a new software version and monitors completion of updates.