Patents by Inventor Prem Veeramani

Prem Veeramani 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: 20180218040
    Abstract: Systems, methods, and computer-readable media for pinning query execution plans are described. A database system may obtain a query, and determine a organization identifier and/or user identifier associated with the query. The database system may identify an optimized plan among a set of query plans that correspond with the query, and may generate a query execution plan based on the query and the optimized plan. The database system may determine a pinned plan that is associated with the optimized plan, and may generate a query execution plan based on the pinned plan when the pinned plan is associated with the optimized plan and corresponds with the organization identifier and/or the user identifier. The database system may generate a query execution plan using optimization functions when the pinned plan is not associated with the pinned plan, or the organization identifier and/or the user identifier. Other embodiments may be described and/or claimed.
    Type: Application
    Filed: January 30, 2017
    Publication date: August 2, 2018
    Applicant: salesforce.com, inc.
    Inventors: RamaLinga Raju PENMETSA, Prem VEERAMANI, Jeffrey Lallana FRESCHL, Jesse COLLINS, Ganesh MAGANTI
  • 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: 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
  • 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: 20180025174
    Abstract: In an example, a processing device of a datastore system may be configured to identify one or more grants of permission corresponding to one or more first objects, respectively, wherein the one or more first objects comprise only a subset of objects of a datastore, wherein the one or more grants of permission are by a user of the datastore; generate an access control entry for a second object of the objects using at least one of the identified grants of permission, wherein the second object is not exposed to the user; and in responsive to receipt of a query for data corresponding to the objects, determine whether to grant access to the data based on the generated access control entry.
    Type: Application
    Filed: October 17, 2016
    Publication date: January 25, 2018
    Applicant: salesforce.com, inc.
    Inventors: Rohitashva MATHUR, Prem Veeramani, Jesse Collins
  • 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