Systems, methods and techniques for polymorphic queries

• US 9,442,974 B2
• Filed: 08/29/2013
• Issued: 09/13/2016
• Est. Priority Date: 09/05/2012
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: White, Seth John
• Primary Examiner(s): To, Baoquoc N
• Application Number:
  US14/014,010
• Publication Number:
  US 20140108399A1
• Time in Patent Office: 1,111 Days
• Field of Search: 707/736, 707/770, 707/E17.014, 707/769
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/2448 for particular applications; for extensibility, e.g. user defined types
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Techniques for providing polymorphic query requests. A request is received that has at least a database query. The database query comprises at least an expression using a polymorphic relationship. The request is processed utilizing the polymorphic relationship. A user-readable result is provided for the query where the result is defined by at least the polymorphic relationship.

Claims

1. A method for polymorphic selection of data, the method comprising:

receiving a request, via a graphical user interface and with hardware computing device to provide database search functionality, wherein a database object having a target object type has been selected via the graphical user interface and the request comprises at least a database query, wherein the database query comprises at least an expression using a polymorphic relationship corresponding to the target object type, wherein the database query is for a multitenant database;

processing, with the hardware computing device, the request utilizing the polymorphic relationship by at least, automatically and without user interaction, selecting relevant set of one or more fields corresponding to the polymorphic reference based on a runtime type of the polymorphic reference, wherein the polymorphic relationship is specified by the expression that within a clause that allows the request to specify fields of a related parent object that are to be selected based on the type of the parent object; and

providing, with the hardware computing device, a user-readable result on the graphical user interface for the query where the result is defined by at least the polymorphic relationship.

2. The method of claim 1 wherein the request comprises a salesforce object query language (SOQL)-compliant request.

3. The method of claim 1 wherein the expression selects different fields from a target of a polymorphic reference based on target type.

4. The method of claim 1 wherein the query is processed as a plurality of batches.

5. An article comprising a non-transitory computer-readable medium having instructions for polymorphic selection of data that, when executed by one or more processors, are configurable to cause the one or more processors to:

receive a request, via a graphical user interface and with a hardware computing device to provide database search functionality, wherein a database object having a target object type has been selected via the graphical user interface and the request comprises at least a database query, wherein the database query comprises at least an expression using a polymorphic relationship corresponding to the target object type, wherein the database query is for a multitenant database;

process, with the hardware computing device, the request utilizing the polymorphic relationship by at least, automatically and without user interaction, selecting relevant set of one or more fields corresponding to the polymorphic reference based on a runtime type of the polymorphic reference, wherein the polymorphic relationship is specified by the expression that within a clause that allows the request to specify fields of a related parent object that are to be selected based on the type of the parent object; and

provide, with the hardware computing device, a user-readable result on the graphical user interface for the query where the result is defined by at least the polymorphic relationship.

6. The article of claim 5 wherein the request comprises a salesforce object query language (SOQL)-compliant request.

7. The article of claim 5 wherein the expression selects different fields from a target of a polymorphic reference based on target type.

8. The article of claim 5 wherein the query is processed as a plurality of batches.

9. An apparatus for polymorphic selection of data that, the apparatus comprising:

means for receiving a request, via a graphical user interface and with a hardware computing device to provide database search functionality, wherein a database object having a target object type has been selected via the graphical user interface and the request comprises at least a database query, wherein the database query comprises at least an expression using a polymorphic relationship corresponding to the target object type, wherein the database query is for a multitenant database;

means for processing, with hardware computing device, the request utilizing the polymorphic relationship by at least, automatically and without user interaction, selecting relevant set of one or more fields corresponding to the polymorphic reference based on a runtime type of the polymorphic reference, wherein the polymorphic relationship is specified by the expression that within a clause that allows the request to specify fields of a related parent object that are to be selected based on the type of the parent object; and

means for providing, with the hardware computing device, a user-readable result on the graphical user interface for the query where the result is defined by at least the polymorphic relationship.

10. A system comprising:

one or more user systems;

one or more server systems communicatively coupled with the one or more user systems, the server system to provide a multitenant environment, wherein the multitenant environment includes data for multiple client entities, each identified by a tenant identifier (ID) having one or more users associated with the tenant ID, users of each of multiple client identities can only access data identified by a tenant ID associated with the respective client entity, and the multitenant environment is at least a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities, the one or more server systems to receive a request, via a graphical user interface and with a hardware computing device to provide database search functionality, wherein a database object having a target object type has been selected via the graphical user interface and the request comprises at least a database query, wherein the database query comprises at least an expression using a polymorphic relationship corresponding to the target object type to process, with the hardware computing device, the request utilizing the polymorphic relationship by at least, automatically and without user interaction, selecting relevant set of one or more fields corresponding to the polymorphic reference based on a runtime type of the polymorphic reference, to provide, with the hardware computing device, a user-readable result on the graphical user interface for the query where the result is defined by at least the polymorphic relationship, wherein the polymorphic relationship is specified by the expression that within a clause that allows the request to specify fields of a related parent object that are to be selected based on the type of the parent object.

11. The system of claim 10 wherein the request comprises a salesforce object query language (SOQL)-compliant request.

12. The system of claim 10 wherein the expression selects different fields form a target of a polymorphic reference based on target type.

13. The system of claim 10 wherein the query is processed as a plurality of batches.