Arup Kumar Dutta, 56Danville, CA

2011028, Nov 17, 2011

Dec 17, 2010

12/971978

Jesse Collins - San Francisco CA, US
Arup Dutta - San Ramon CA, US

salesforce.com, inc. - San Francisco CA

G06F 17/30

707741, 707E17002

Methods and systems are described for determining candidates for a custom index in a multi-tenant database environment. In one embodiment, a method includes, capturing a query that is directed to a multi-tenant database, determining whether the captured query is a candidate for an additional filter, determining operators used by the captured query if the query is a candidate, determining data types of the database used by the captured query if the query is a candidate, determining whether there is a current filter for the operator and data types used by the captured query if the query is a candidate, selecting the captured query based on the determined operators, data types, and the determined current filters, and generating a custom index for the selected query.

2012002, Jan 26, 2012

Jul 23, 2010

12/842954

Arup Dutta - San Ramon CA, US
Jesse Collins - San Francisco CA, US

SALESFORCE.COM, INC. - San Francisco CA

G06F 11/30

714 472, 714E11179

A method for generating performance alerts in a database system. The method includes collecting a predefined set of performance data, and comparing the performance data to one or more predefined thresholds. The method also includes determining if any of the performance data exceeds the one or more predefined thresholds, and generating an alert if any of the data exceeds one of the predefined thresholds.

2013000, Jan 3, 2013

Nov 1, 2011

13/287022

Arup Dutta - San Ramon CA, US
Simon Wong - San Carlos CA, US
Dan Soble - Pleasanton CA, US
Nathanael Black - San Francisco CA, US
Walter Macklem - San Francisco CA, US

SALESFORCE.COM, INC. - San Francisco CA

G06F 17/30

707792, 707E17055

An embodiment of a multi-tenant database system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

2013001, Jan 17, 2013

Jul 13, 2012

13/549306

Chirag Rajan - San Francisco CA, US
Arup Dutta - San Ramon CA, US
John O'Brien - San Francisco CA, US
Jaikumar Bathija - Fremont CA, US
Greg Salmon - Walnut Creek CA, US
Dan Soble - Pleasanton CA, US
RamaLinga R. Penmetsa - Fremont CA, US
Hoon Kim - Redwood City CA, US
Yanan Jiang - Daly City CA, US
Karthik Rajan - Foster City CA, US
Jesse Collins - San Francisco CA, US

SALESFORCE.COM, INC. - San Francisco CA

G06F 17/30

707741, 707748, 707E17066, 707E17049

Methods and systems are described for creating a custom index in a multi-tenant database environment. In one embodiment, a method includes obtaining query for a multi-tenant database that is recommended as a candidate for creating an additional filter, evaluating the query against criteria to determine whether to select the query for creating the additional filter, and creating the additional filter for the query, if the query is selected.

2013005, Feb 28, 2013

Nov 1, 2011

13/287067

Arup Dutta - San Ramon CA, US
Caroline Modic - Berkeley CA, US
Dan Soble - Pleasanton CA, US

SALESFORCE.COM, INC. - San Francisco CA

G06F 17/30

707769, 707705, 707E17002, 707E17014

In accordance with embodiments, there are provided mechanisms and methods for calculating a size of an entity. These mechanisms and methods for calculating a size of an entity can enable optimized data analysis, improved system resource knowledge, increased efficiency, etc.

2018010, Apr 19, 2018

Oct 17, 2016

15/295305

- San Francisco CA, US
Rohitashva MATHUR - Walnut Creek CA, US
Arup DUTTA - San Ramon CA, US
Prem VEERAMANI - Hayward CA, US
Jesse COLLINS - Oakland CA, US

G06F 17/30

Reverse database query mapping. A database query to be executed on a computing platform against a database managed by the computing platform is received. Query mapping information is stored in a memory system accessible to the one or more processors. A source query corresponding to a query identifier is retrieved in response to statistical analysis. One or more potential indexes are generated for use with the source query, wherein at least one of the one or more potential indexes can function to improve performance of the source query.

2018010, Apr 19, 2018

Oct 17, 2016

15/295319

- San Francisco CA, US
ROHITASHVA MATHUR - WALNUT CREEK CA, US
ARUP DUTTA - SAN RAMON CA, US
PREM VEERAMANI - HAYWARD CA, US
JESSE COLLINS - OAKLAND CA, US

G06F 17/30

A database query is received at a first time when a database is in a first state. The database query is analyzed to determine whether it has one or more characteristics that fall within a historical top range of database queries. If the database query falls within the historical top range of database queries the query is stored for later query tuning activity. The query is executed against the database in the first state. Query tuning recommendations are generated for stored database queries that fall within the historical top range of database queries. A subsequent request is received at a second time when a database is in a second state. The subsequent database query is executed with at least one of the query tuning recommendations against the database in the second state.

2018010, Apr 19, 2018

Oct 17, 2016

15/295256

- San Francisco CA, US
Rohitashva MATHUR - Walnut Creek CA, US
Arup DUTTA - San Ramon CA, US
Prem VEERAMANI - Hayward CA, US
Jesse COLLINS - Oakland CA, US

G06F 17/30

Automated query tuning. A database query to be executed against a database is received. The database query is analyzed to determine one or more potential indexes to be evaluated. The one or more potential indexes are evaluated to determine if an optimization utilizing a selected potential index provides improved performance over performing the database query without the selected potential index. The one or more potential indexes are scored based on results of the evaluating. A recommendation of one or more of the potential indexes is provided to a source of the database query.