公开(公告)号：US11663205B2

公开(公告)日：2023-05-30

申请号：US15586714

申请日：2017-05-04

Applicant: salesforce.com, Inc.

Inventor： Eli Levine ,  Samarpan Jain ,  James Ferguson ,  Jan Asita Fernando ,  Bharadwaj Tanikella ,  Saikiran Perumala ,  Cody Marcel

IPC: G06F16/242 ,  G06F16/25 ,  G06F16/2458

CPC classification number: G06F16/2448 ,  G06F16/2471 ,  G06F16/252 ,  G06F16/256

Abstract: Systems, methods, and computer-readable media for asynchronous (async) querying are described. In embodiments, a system may convert a user-issued query into a distributed execution instruction set (DEIS), and issue the DEIS to data stores that may have various database structures. The system may obtain database objects from the data stores, and store a result set indicating the obtained database objects in a location specified by the user-issued query. The system may also provide mechanisms to allow users to view progress of their async query jobs and/or cancel ongoing async query jobs. Other embodiments may be described and/or claimed.

公开(公告)号：US10783044B2

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

申请号：US16222925

申请日：2018-12-17

Applicant: salesforce.com, inc.

Inventor： Yingwu Zhao ,  Samarpan Jain ,  Hal Scott Hildebrand ,  Alexey Syomichev ,  Emin Eliot Gerba ,  Igor Pesenson ,  David William Spragg ,  Jay Hurst ,  Soumen Bandyopadhyay

IPC: G06F11/14

Abstract: A method and apparatus for a mechanism of disaster recovery and instance refresh in an event recordation system are described. A first request for events associated with a first topic is received. A first set of events associated with the first topic are retrieved from a primary event recordation system. Each event from the first set of events includes a first commit identifier indicating the order with which each event is stored in the primary event recordation system. For each event from the first set of events a first replay identifier is determined based on the first commit identifier and a first value of a low commit identifier. The first replay identifier is exposed to event consumers for identifying the event. In response to the first request each event from the first set of events is transmitted with the replay identifier.

公开(公告)号：US20190325039A1

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

申请号：US15959607

申请日：2018-04-23

Applicant: salesforce.com, inc.

Inventor： Jan Asita Fernando ,  Cody Marcel ,  Sahil Ramrakhyani ,  Samarpan Jain ,  Brian Esserlieu ,  James Ferguson ,  Saikiran Perumala ,  Charles Fineman ,  Jay Hurst ,  Seshank Kalvala

IPC: G06F17/30 ,  G06F9/54

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for deleting data of an object within a multi-tenant database. Described is a mechanism for performing operations such as an efficient delete operation by introducing a new delete operation (or method) that is configured to allow a data structure such as an object to identify one or more records to be deleted. In order to ensure that the operation is efficient, the mechanism may determine characteristics of a data store and determine whether the information provided within the data structure provides an efficient identification of the data to be deleted. Upon a successful validation, an initial delete request may be translated to an appropriate delete operation for the underlying database.

公开(公告)号：US10339126B2

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

申请号：US14717848

申请日：2015-05-20

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Adam Torman ,  Alex Warshavsky ,  Derrill Dabkoski ,  Samarpan Jain ,  Soumen Bandyopadhyay ,  Thomas William D'Silva

IPC: G06F16/00 ,  G06F16/23 ,  G06Q30/02

Abstract: Disclosed are some examples of database systems, methods, and computer program products for processing log files. In some implementations, a server of a database system accesses a log file having a release version. The log file includes data entries identifying system events corresponding to user activity. The server generates or updates, based on the release version of the log file, a metadata file indicating approved entry types and approved data. The server also generates or updates, based on the log file and the metadata file, customer-facing log files. Each customer-facing log file is associated with a corresponding customer entity capable of being serviced by the database system. Each customer-facing log file includes a subset of the entries and a subset of the data items of at least one of the entries.

公开(公告)号：US20190042573A1

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

申请号：US15665529

申请日：2017-08-01

Applicant: salesforce.com, inc.

Inventor： Cody Marcel ,  Eli Levine ,  Jan Asita Fernando ,  Brian Esserlieu ,  Samarpan Jain

IPC: G06F17/30 ,  G06F9/50

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating rules-based synchronous query processing for large datasets in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method comprises detecting, by a rules-management server computing device, at least one of efficient classes and inefficient classes associated with a query, and designating a set of rules to the query, where one or more of the set of rules are designated to the query to prevent the inefficient classes from being processed or allow the query to fail fast. The method may further include executing the query without processing the inefficient classes such that results are generated within a predictable amount of time, where executing includes accessing contents of one or more portions of a database as identified by the set of rules, and transmitting the results in response to the query.

公开(公告)号：US09767040B2

公开(公告)日：2017-09-19

申请号：US14841503

申请日：2015-08-31

Applicant: SALESFORCE.COM, INC.

Inventor： Aakash Pradeep ,  Adam Torman ,  Samarpan Jain ,  Alex Warshavsky

IPC: G06F12/12 ,  G06F12/02

CPC classification number: G06F12/12 ,  G06F9/5077 ,  G06F9/5088 ,  G06F12/023 ,  G06F2212/1044

Abstract: In an example, a processing system of a database system may categorize event data taken from logged interactions of users with a multi-tenant information system to provide a metric. Event roll-up aggregate metrics used to provide the metric may be generated in connection with event capture. The processing system of the database system may periodically calculate the metric for a particular one of the tenants, and electronically store the periodically calculated metrics for accessing responsive to a query of the particular tenant.

公开(公告)号：US09767022B2

公开(公告)日：2017-09-19

申请号：US15236195

申请日：2016-08-12

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Adam Torman ,  Alex Warshavsky ,  Samarpan Jain ,  Soumen Bandyopadhyay ,  Thomas William D'Silva ,  Abhishek Bangalore Sreenivasa

IPC: G06F12/08 ,  G06F5/14 ,  G06F12/0804 ,  H04L29/08 ,  G06F9/54

CPC classification number: G06F12/0804 ,  G06F5/14 ,  G06F9/542 ,  G06F9/544 ,  G06F2205/126 ,  G06F2212/1041 ,  G06F2212/281 ,  G06F2212/311 ,  H04L67/28

Abstract: A capture service running on an application server receives events from a client application running on an application server to be stored in a data store and stores the events in an in-memory bounded buffer on the application server, the in-memory bounded buffer comprising a plurality of single-threaded segments, the capture service to write events to each segment in parallel. The in-memory bounded buffer provides a notification to a buffer flush regulator when a number of events stored in the in-memory bounded buffer reaches a predefined limit. The in-memory bounded buffer receive a request to flush the events in the in-memory bounded buffer from a consumer executor service. The consumer executor service consumes the events in the in-memory bounded buffer using a dynamically sized thread pool of consumer threads to read the segments of the bounded buffer in parallel, wherein consuming the events comprises writing the events directly to the data store.

公开(公告)号：US20160078120A1

公开(公告)日：2016-03-17

申请号：US14688989

申请日：2015-04-16

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Adam Torman ,  Alex Warshavsky ,  Samarpan Jain ,  Soumen Bandyopadhyay ,  Thomas William D'Silva

IPC: G06F17/30

CPC classification number: H04L67/10 ,  G06F11/00 ,  G06F11/3006 ,  G06F11/3438 ,  G06F11/3452 ,  G06F11/3476 ,  G06F16/173 ,  G06F16/2428 ,  G06F2201/80 ,  G06F2201/86 ,  H04L67/02

Abstract: In an example, a processing system of a database system may categorize event data taken from logged interactions of users with a multi-tenant information system to provide a metric. The processing system of the database system may periodically calculate the metric for a particular one of the tenants, and electronically store the periodically calculated metrics for accessing responsive to a query of the particular tenant.

Abstract translation: 在一个示例中，数据库系统的处理系统可以将从用户的记录交互获取的事件数据与多租户信息系统分类以提供度量。 数据库系统的处理系统可以周期性地计算特定租户的度量，并且电子地存储响应于特定租户的查询的周期性计算的用于访问的度量。

公开(公告)号：US20160048377A1

公开(公告)日：2016-02-18

申请号：US14924442

申请日：2015-10-27

Applicant: salesforce.com, inc.

Inventor： Samarpan Jain ,  Reuben Comel

IPC: G06F9/45 ,  G06F9/44

CPC classification number: G06F21/604 ,  G06F8/20 ,  G06F8/41 ,  G06F8/70 ,  G06F21/62 ,  G06F21/6209 ,  G06F21/629

Abstract: Methods and systems are provided for controlling the execution of business logic that allows features to be turned on or off at run time for each particular user entity of a plurality of user entities. Prior to run time a library is configured based on an administrator's interaction with an interactive control panel at a computer of the system. For each particular user entity and for each particular code block of an object that comprises a plurality of code blocks each corresponding to a particular feature and having an enabling predicate associated with that particular code block, the library can be configured by defining an on/off state for each feature of that particular code block via an enabling predicate associated with that particular feature. The library can then be cached in a custom settings cache of the system for use at run time.

Abstract translation: 提供了用于控制业务逻辑的执行的方法和系统，其允许在运行时为多个用户实体的每个特定用户实体打开或关闭特征。 在运行时间之前，基于管理员与系统计算机上的交互式控制面板的交互来配置库。 对于每个特定用户实体和对于包括多个代码块的对象的每个特定代码块，每个代码块对应于特定特征并具有与特定代码块相关联的启用谓词，可以通过定义开/关来配置库 通过与该特定特征相关联的启用谓词，该特定代码块的每个特征的状态。 然后，库可以缓存在系统的自定义设置缓存中，以便在运行时使用。

公开(公告)号：US10908947B2

公开(公告)日：2021-02-02

申请号：US15374787

申请日：2016-12-09

Applicant: salesforce.com, inc.

Inventor： Brian Jaffery Tajuddin ,  Samarpan Jain ,  Reuben Cornel ,  Siddhi Mehta ,  Brian Esserlieu ,  Jan Asita Fernando ,  Jonathan Mark Bruce ,  Jay Hurst

IPC: G06F16/23 ,  G06F9/48 ,  G06F9/50 ,  H04L29/08

Abstract: Techniques and architectures for data ingestion in an environment having a distributed data storage system. A request to import data into the environment. The data to be imported from an external source through an application programming interface (API). The request is analyzed to determine if the request corresponds to a request to import a large data load. The data is staged if the request is for the large data load. Data management jobs are created to cause the data to be stored in one or more nodes of the distributed data storage system. The data management jobs are transmitted to corresponding nodes in the distributed data storage system. The jobs are executed asynchronously to cause the data to be stored in the nodes.