Patents by Inventor Jesse Collins

Jesse Collins 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).

  • Publication number: 20120151062
    Abstract: Methods and systems for making effective use of system resources. A plurality of requests for access to a resource are received. Each request has an associated group of features. The group of features for each request is analyzed to collect observations about the plurality of requests. A function to predict an outcome of a subsequent request is generated based on the observations. Resources are allocated to service the subsequent request based on the function.
    Type: Application
    Filed: October 19, 2011
    Publication date: June 14, 2012
    Applicant: SALESFORCE.COM, INC.
    Inventors: Andrey Gusev, Ronald Yang, Scott Hansma, Jesse Collins, Alan Arbizu
  • Publication number: 20120131068
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.
    Type: Application
    Filed: January 31, 2012
    Publication date: May 24, 2012
    Applicant: salesforce.com, inc.
    Inventors: Mary Scotton, Walter Macklem, Eric Bezar, Jesse Collins
  • Patent number: 8150833
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.
    Type: Grant
    Filed: May 6, 2009
    Date of Patent: April 3, 2012
    Assignee: salesforce.com, inc.
    Inventors: Mary Scotton, Walter Macklem, Eric Bezar, Jesse Collins
  • 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: 20110320435
    Abstract: In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.
    Type: Application
    Filed: June 23, 2011
    Publication date: December 29, 2011
    Applicant: Salesforce.com, Inc.
    Inventors: Jesse Collins, Jaikumar Bathija, John F. O'Brien
  • Publication number: 20110295838
    Abstract: In a method, system, and computer-readable medium having instructions for optimizing a query in a database system, a query request is received with a query predicate to filter data returned in response to the query request and the query predicate has a formula, the query request is transformed to a transformed query request by preprocessing the formula in the query predicate, and the query request is optimized using the transformed query request.
    Type: Application
    Filed: December 22, 2010
    Publication date: December 1, 2011
    Applicant: SALESFORCE.COM, INC.
    Inventors: Jesse Collins, Jaikumar Bathija
  • Publication number: 20110295839
    Abstract: In a method, system, and computer-readable medium having instructions for optimizing a query in a database system, a database statistic is generated for a number of related records for one or more entities for at least one tenant and a related record is a record with a relationship to a shared record in a database table for an entity from the one or more entities, a first cost is calculated for accessing the number of related records for at least one tenant, a second cost is calculated for accessing a number of related records accessible to a user, a comparison of the first cost to the second cost is performed to determine a data access path for retrieving accessible related records, and the data access path for retrieving accessible related records is determined based upon the comparison.
    Type: Application
    Filed: September 17, 2010
    Publication date: December 1, 2011
    Applicant: SALESFORCE.COM, INC.
    Inventors: Jesse Collins, Jaikumar Bathija
  • Publication number: 20110289091
    Abstract: In accordance with embodiments, there are provided methods and systems for providing multiple column custom indexes in a multi-tenant database environment. A method embodiment provides defining a multi-tenant data structure having a plurality of data columns data fields and a plurality of rows for each of multiple tenants, each row including a data column for a tenant identifier, defining a first data field for a tenant, the first data field having a first data type, defining a second data field for the tenant, the second field having a second data type, and defining an index table including a tenant identifier for the tenant, a copy of data from the first data field and the second data field, and a key to the corresponding rows of the multi-tenant data structure.
    Type: Application
    Filed: October 4, 2010
    Publication date: November 24, 2011
    Applicant: Salesforce.com, inc.
    Inventors: Jesse Collins, Simon Y. Wong, Jaikumar Bathija, John F. O'Brien
  • Publication number: 20110282864
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for query optimization in a database system. These mechanisms and methods for query optimization in a database system can enable embodiments to optimize OR expression filters referencing different logical tables. The ability of embodiments to optimize OR expression filters referencing different logical tables can enable optimization that is dynamic and specific to the particular tenant for whom the query is run and improve the performance and efficiency of the database system in response to query requests.
    Type: Application
    Filed: January 26, 2011
    Publication date: November 17, 2011
    Applicant: Salesforce.com Inc.
    Inventors: Jesse Collins, Jaikumar Bathija
  • 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
  • Publication number: 20110282847
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for validating queries. These mechanisms and methods for validating queries can enable embodiments to provide more reliable and faster execution of queries both in development and in production. In an embodiment and by way of example, a method for validating queries is provided. The method embodiment includes capturing a query that is directed to a multi-tenant database. A plan is determined by which the query will be applied to the database. The plan is statically analyzed for performance. Then a performance measure is applied to the query.
    Type: Application
    Filed: October 4, 2010
    Publication date: November 17, 2011
    Applicant: salesforce.com, inc.
    Inventors: Jesse Collins, Matthew Peterson, John F. O'Brien
  • Publication number: 20110246449
    Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving, at a network interface of a server computer in a multi-tenant database system, an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant.
    Type: Application
    Filed: October 4, 2010
    Publication date: October 6, 2011
    Applicant: salesforce.com, Inc.
    Inventors: Jesse Collins, Craig Weissman
  • Publication number: 20110082854
    Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving at a network interface of a server in a multi-tenant database system an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes at least a first index and a second index. Metadata associated with the data is retrieved, wherein at least a portion of the data is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined by analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant.
    Type: Application
    Filed: September 21, 2010
    Publication date: April 7, 2011
    Applicant: salesforce.com, Inc.
    Inventors: William Charles Eidson, Jesse Collins
  • Publication number: 20110004668
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service.
    Type: Application
    Filed: September 15, 2010
    Publication date: January 6, 2011
    Applicant: SALESFORCE.COM, INC.
    Inventors: Greg Salmon, Chris Hopkins, Anant Verma, Jesse Collins, Craig Weissman
  • Patent number: 7827138
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service.
    Type: Grant
    Filed: August 31, 2007
    Date of Patent: November 2, 2010
    Assignee: salesforce.com, inc.
    Inventors: Greg Salmon, Chris Hopkins, Anant Verma, Jesse Collins, Craig Weissman
  • Publication number: 20100070528
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for providing apportioning of opportunity among campaigns in an on-demand service in a database system. These mechanisms and methods for providing apportioning of opportunity among campaigns can enable embodiments to automatically determine which campaigns are related to an opportunity and provide a filtered set of campaigns that are related to at least one opportunity. The ability of embodiments to apportion opportunity among campaigns can provide marketing information that accurately reflects the true relationship between an opportunity and a plurality of campaigns.
    Type: Application
    Filed: September 14, 2009
    Publication date: March 18, 2010
    Applicant: Salesforce.com Inc.
    Inventors: Jesse Collins, Andrea Wildt, Philippe Debaty, Simon Y. Wong, Bing Yang
  • Publication number: 20080082555
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service.
    Type: Application
    Filed: August 31, 2007
    Publication date: April 3, 2008
    Applicant: Salesforce.com, inc.
    Inventors: Greg Salmon, Chris Hopkins, Anant Verma, Jesse Collins, Craig Weissman