Patents by Inventor Dave Moellenhoff
Dave Moellenhoff 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: 10152508Abstract: In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.Type: GrantFiled: April 29, 2013Date of Patent: December 11, 2018Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong
-
Patent number: 9275105Abstract: In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.Type: GrantFiled: September 14, 2012Date of Patent: March 1, 2016Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong
-
Patent number: 8799320Abstract: Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response.Type: GrantFiled: June 20, 2012Date of Patent: August 5, 2014Assignee: salesforce.com, inc.Inventors: Eric Chan, Craig Weissman, Paul Nakada, Dave Moellenhoff, Todd McKinnon
-
Patent number: 8788532Abstract: Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response.Type: GrantFiled: June 20, 2012Date of Patent: July 22, 2014Assignee: salesforce.com, inc.Inventors: Eric Chan, Craig Weissman, Paul Nakada, Dave Moellenhoff, Todd McKinnon
-
Patent number: 8732157Abstract: The present invention provides techniques for managing a multi-tenant database system. In one embodiment the method includes providing access to data stored in a multi-tenant data structure that is implemented by storing data for multiple tenants on a pool of computer servers defining the multi-tenant data structure that having a plurality of data columns and one or more index columns. The one or more index columns define a first data field for a first tenant of the multi-tenant data structure and a second data field for a second tenant of the multi-tenant data structure. The first field indicates a first data type and the second field indicates a second data type, wherein the second data type is different than the first data type. Once created, records having data values in the first and second fields are stored to a single column in the data structure. The single column includes data values having different data types for different tenants in the multi-tenant data structure.Type: GrantFiled: March 31, 2010Date of Patent: May 20, 2014Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8620954Abstract: The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization.Type: GrantFiled: April 16, 2010Date of Patent: December 31, 2013Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8620876Abstract: Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response.Type: GrantFiled: November 1, 2011Date of Patent: December 31, 2013Assignee: salesforce.com, inc.Inventors: Eric Chan, Craig Weissman, Paul Nakada, Dave Moellenhoff, Todd McKinnon
-
Patent number: 8606790Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.Type: GrantFiled: September 14, 2012Date of Patent: December 10, 2013Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8543566Abstract: A query optimizing system and methods employ contextual knowledge about the types and use of data and/or applications in tables underlying a relational database to provide improved queries and/or make recommendations to a query optimizer of a database based upon knowledge of the data and/or application gathered. A multi-tenant database, in which querying is conducted on multiple tenant data stored in a single table, provides for determining tenant-level statistics, data sharing, user/tenant views, user-level access/capacities, custom entities, custom fields and/or other contextual information about users and tenants, and for providing query optimization and/or query optimizer recommendations corresponding to such information.Type: GrantFiled: November 10, 2006Date of Patent: September 24, 2013Assignee: salesforce.com, Inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong
-
Publication number: 20130246472Abstract: The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization.Type: ApplicationFiled: May 2, 2013Publication date: September 19, 2013Applicant: salesforce.com, incInventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Publication number: 20130246450Abstract: In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.Type: ApplicationFiled: April 29, 2013Publication date: September 19, 2013Applicant: salesforce.com, incInventors: Craig Weissman, Dave Moellenhoff, Simon Wong
-
Publication number: 20130246471Abstract: The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization.Type: ApplicationFiled: April 30, 2013Publication date: September 19, 2013Applicant: Salesforce.com, incInventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8423535Abstract: The present invention provides techniques for storing information on a multi-tenant database system to control query latency that includes a method that stores the information on the database among a plurality of tables arranged in columns and rows. For each of a subset of the plurality of tables, sets of the rows are distributed amongst different storage nodes on the database, with the set of rows stored at a common node having a common index value. Data storage and retrieval capabilities to the database are provided to allow access to the information, in response to requests from one of a plurality of remotely disposed computer systems. The retrieval capability includes a query condition that includes a query index value, with the query condition and the query index value being established to control retrieval latency.Type: GrantFiled: April 15, 2010Date of Patent: April 16, 2013Assignee: Salesforce.com, Inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Publication number: 20130060792Abstract: In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.Type: ApplicationFiled: September 14, 2012Publication date: March 7, 2013Applicant: SALESFORCE.COM, INC.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong
-
Publication number: 20130013773Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.Type: ApplicationFiled: September 14, 2012Publication date: January 10, 2013Applicant: SALESFORCE.COM, INC.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8335781Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.Type: GrantFiled: May 7, 2010Date of Patent: December 18, 2012Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8332387Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.Type: GrantFiled: May 7, 2010Date of Patent: December 11, 2012Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Patent number: 8321405Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.Type: GrantFiled: May 7, 2010Date of Patent: November 27, 2012Assignee: salesforce.com, inc.Inventors: Craig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
-
Publication number: 20120259839Abstract: Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response.Type: ApplicationFiled: June 20, 2012Publication date: October 11, 2012Applicant: SALESFORCE.COM, INC.Inventors: Eric Chan, Craig Weissman, Paul Nakada, Dave Moellenhoff, Todd McKinnon
-
Publication number: 20120260341Abstract: Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response.Type: ApplicationFiled: June 20, 2012Publication date: October 11, 2012Applicant: SALESFORCE.COM, INC.Inventors: Eric Chan, Craig Weissman, Paul Nakada, Dave Moellenhoff, Todd McKinnon