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: 10268721
    Abstract: 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: Grant
    Filed: October 31, 2014
    Date of Patent: April 23, 2019
    Assignee: salesforce.com, inc
    Inventors: Arup Dutta, Prem Veeramani, Jesse Yarbro Collins
  • Publication number: 20190108248
    Abstract: 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: Application
    Filed: October 22, 2018
    Publication date: April 11, 2019
    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
  • Patent number: 10108648
    Abstract: 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: Grant
    Filed: July 13, 2012
    Date of Patent: October 23, 2018
    Assignee: 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: 20180107697
    Abstract: 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: Application
    Filed: October 17, 2016
    Publication date: April 19, 2018
    Inventors: Awais TARIQ, Rohitashva MATHUR, Arup DUTTA, Prem VEERAMANI, Jesse COLLINS
  • Publication number: 20180107711
    Abstract: 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: Application
    Filed: October 17, 2016
    Publication date: April 19, 2018
    Inventors: AWAIS TARIQ, ROHITASHVA MATHUR, ARUP DUTTA, PREM VEERAMANI, JESSE COLLINS
  • Publication number: 20180107714
    Abstract: 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: Application
    Filed: October 17, 2016
    Publication date: April 19, 2018
    Inventors: Awais Tariq, Rohitashva MATHUR, Arup DUTTA, Prem VEERAMANI, Jesse COLLINS
  • Patent number: 9558218
    Abstract: 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: Grant
    Filed: May 18, 2015
    Date of Patent: January 31, 2017
    Assignee: salesforce.com, inc.
    Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
  • Publication number: 20150254286
    Abstract: 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: Application
    Filed: May 18, 2015
    Publication date: September 10, 2015
    Applicant: salesforce.com, inc.
    Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
  • Patent number: 9069788
    Abstract: 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: Grant
    Filed: November 1, 2011
    Date of Patent: June 30, 2015
    Assignee: salesforce.com, inc.
    Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
  • Publication number: 20150127680
    Abstract: 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: Application
    Filed: October 31, 2014
    Publication date: May 7, 2015
    Inventors: Arup Dutta, Prem Veeramani, Jesse Yarbro Collins
  • Patent number: 8738970
    Abstract: 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: Grant
    Filed: July 23, 2010
    Date of Patent: May 27, 2014
    Assignee: salesforce.com, inc.
    Inventors: Arup Dutta, Jesse Collins
  • Patent number: 8688647
    Abstract: 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: Grant
    Filed: November 1, 2011
    Date of Patent: April 1, 2014
    Assignee: salesforce.com, inc.
    Inventors: Arup Dutta, Caroline Modic, Dan Soble
  • Patent number: 8583653
    Abstract: 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: Grant
    Filed: December 17, 2010
    Date of Patent: November 12, 2013
    Assignee: salesforce.com, inc.
    Inventors: Jesse Collins, Arup Dutta
  • Publication number: 20130054637
    Abstract: 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: Application
    Filed: November 1, 2011
    Publication date: February 28, 2013
    Applicant: SALESFORCE.COM, INC.
    Inventors: Arup Dutta, Caroline Modic, Dan Soble
  • Publication number: 20130018890
    Abstract: 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: Application
    Filed: July 13, 2012
    Publication date: January 17, 2013
    Applicant: 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: 20130007062
    Abstract: 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: Application
    Filed: November 1, 2011
    Publication date: January 3, 2013
    Applicant: SALESFORCE.COM, INC.
    Inventors: Arup Dutta, Simon Wong, Dan Soble, Nathanael Black, Walter Macklem
  • Publication number: 20120023375
    Abstract: 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: Application
    Filed: July 23, 2010
    Publication date: January 26, 2012
    Applicant: SALESFORCE.COM, INC.
    Inventors: Arup Dutta, Jesse Collins
  • Publication number: 20110282881
    Abstract: 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: Application
    Filed: December 17, 2010
    Publication date: November 17, 2011
    Applicant: salesforce.com, inc.
    Inventors: Jesse Collins, Arup Dutta