Patents by Inventor Arup Dutta
Arup Dutta has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11232102Abstract: 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.Type: GrantFiled: October 17, 2016Date of Patent: January 25, 2022Assignee: salesforce.com, Inc.Inventors: Awais Tariq, Rohitashva Mathur, Arup Dutta, Prem Veeramani, Jesse Collins
-
Patent number: 10762085Abstract: 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.Type: GrantFiled: October 17, 2016Date of Patent: September 1, 2020Assignee: salesforce.com, inc.Inventors: Awais Tariq, Rohitashva Mathur, Arup Dutta, Prem Veeramani, Jesse Collins
-
Patent number: 10452630Abstract: 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.Type: GrantFiled: October 17, 2016Date of Patent: October 22, 2019Assignee: salesforce.com, inc.Inventors: Awais Tariq, Rohitashva Mathur, Arup Dutta, Prem Veeramani, Jesse Collins
-
Patent number: 10268721Abstract: Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.Type: GrantFiled: October 31, 2014Date of Patent: April 23, 2019Assignee: salesforce.com, incInventors: Arup Dutta, Prem Veeramani, Jesse Yarbro Collins
-
Publication number: 20190108248Abstract: 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.Type: ApplicationFiled: October 22, 2018Publication date: April 11, 2019Inventors: Chirag Rajan, Arup Dutta, John O'Brien, Jaikumar Bathija, Greg Salmon, Dan Soble, RamaLinga R. Penmetsa, Hoon Kim, Yanan Jiang, Karthik Rajan, Jesse Collins
-
Patent number: 10108648Abstract: 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.Type: GrantFiled: July 13, 2012Date of Patent: October 23, 2018Assignee: salesforce.com, inc.Inventors: Chirag Rajan, Arup Dutta, John O'Brien, Jaikumar Bathija, Greg Salmon, Dan Soble, RamaLinga R. Penmetsa, Hoon Kim, Yanan Jiang, Karthik Rajan, Jesse Collins
-
Publication number: 20180107697Abstract: 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.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Awais TARIQ, Rohitashva MATHUR, Arup DUTTA, Prem VEERAMANI, Jesse COLLINS
-
Publication number: 20180107711Abstract: 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.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: AWAIS TARIQ, ROHITASHVA MATHUR, ARUP DUTTA, PREM VEERAMANI, JESSE COLLINS
-
Publication number: 20180107714Abstract: 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.Type: ApplicationFiled: October 17, 2016Publication date: April 19, 2018Inventors: Awais Tariq, Rohitashva MATHUR, Arup DUTTA, Prem VEERAMANI, Jesse COLLINS
-
Patent number: 9558218Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database 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 metadata 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.Type: GrantFiled: May 18, 2015Date of Patent: January 31, 2017Assignee: salesforce.com, inc.Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
-
Publication number: 20150254286Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database 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 metadata 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.Type: ApplicationFiled: May 18, 2015Publication date: September 10, 2015Applicant: salesforce.com, inc.Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
-
Patent number: 9069788Abstract: 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.Type: GrantFiled: November 1, 2011Date of Patent: June 30, 2015Assignee: salesforce.com, inc.Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
-
Publication number: 20150127680Abstract: Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.Type: ApplicationFiled: October 31, 2014Publication date: May 7, 2015Inventors: Arup Dutta, Prem Veeramani, Jesse Yarbro Collins
-
Patent number: 8738970Abstract: 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.Type: GrantFiled: July 23, 2010Date of Patent: May 27, 2014Assignee: salesforce.com, inc.Inventors: Arup Dutta, Jesse Collins
-
Patent number: 8688647Abstract: 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.Type: GrantFiled: November 1, 2011Date of Patent: April 1, 2014Assignee: salesforce.com, inc.Inventors: Arup Dutta, Caroline Modic, Dan Soble
-
Patent number: 8583653Abstract: 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.Type: GrantFiled: December 17, 2010Date of Patent: November 12, 2013Assignee: salesforce.com, inc.Inventors: Jesse Collins, Arup Dutta
-
Publication number: 20130054637Abstract: 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.Type: ApplicationFiled: November 1, 2011Publication date: February 28, 2013Applicant: SALESFORCE.COM, INC.Inventors: Arup Dutta, Caroline Modic, Dan Soble
-
Publication number: 20130018890Abstract: 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.Type: ApplicationFiled: July 13, 2012Publication date: January 17, 2013Applicant: SALESFORCE.COM, INC.Inventors: Chirag Rajan, Arup Dutta, John O'Brien, Jaikumar Bathija, Greg Salmon, Dan Soble, RamaLinga R. Penmetsa, Hoon Kim, Yanan Jiang, Karthik Rajan, Jesse Collins
-
Publication number: 20130007062Abstract: 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.Type: ApplicationFiled: November 1, 2011Publication date: January 3, 2013Applicant: SALESFORCE.COM, INC.Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
-
Publication number: 20120023375Abstract: 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.Type: ApplicationFiled: July 23, 2010Publication date: January 26, 2012Applicant: SALESFORCE.COM, INC.Inventors: Arup Dutta, Jesse Collins