Optimizing result presentation of a database operation

• US 9,569,509 B2
• Filed: 08/29/2013
• Issued: 02/14/2017
• Est. Priority Date: 09/04/2012
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: White, Seth John
• Primary Examiner(s): Uddin, Md. I
• Application Number:
  US14/013,687
• Publication Number:
  US 20140067796A1
• Time in Patent Office: 1,265 Days
• Field of Search: 707/706, 707/713, 707/718, 707/722, 707/999.003, 707/E17.005
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Techniques for optimizing result presentation for a database query. A database query is received. The database query is performed with a clause indicating one or more offset values to be used in displaying results from the database query. The one or more offset values indicate a subset within the results from the database query to be presented. An order is imposed on the results from the database query. The subset is presented as determined by the one or more offset values.

Claims

1. A method comprising:

receiving, with a database query agent provided by a hardware database server, one or more paging queries, wherein the queries comprises salesforce object query language (SOQL) compliant query syntax, where the SOQL implemented in cloud APIs and does not use assertion consumer service (ACS);

detecting whether any of the one or more paging queries have not been specified with an explicit total order;

enhancing automatically and with the database query agent, for the one or more paging queries without an explicit total order with a total ordering, wherein the total ordering comprises at least a offset clause and a limit clause to support paging of query results;

causing, with the database query agent, the database query to be performed within a multitenant database environment with the clauses indicating one or more offset and limit values to be used in displaying results from the database query in a paged format on a user electronic device, wherein the one or more offset values indicate a subset within the results from the database query to be presented, wherein offset calculation is performed by a database server;

imposing, with the database query agent, an order by clause on the results from the database query with the database server to ensure the query result set ordering is consistent; and

returning, with the database query agent, the subset as determined by the one or more offset values to the user electronic device.

2. The method of claim 1 wherein the one or more offset values indicate a subset of rows within the results from the database query to return.

3. The method of claim 2 wherein the one or more offset values operate to impose a limit on the number of rows to return.

4. The method of claim 1 wherein the order is based on a query shape.

5. The method of claim 1 wherein the order is based on a query size.

6. An article comprising a non-transitory computer-readable medium having stored thereon instructions that, when executed by one or more processors, are configurable to cause the one or more processors to:

receive, with a database query agent provided by a hardware database server, one or more paging queries, wherein the queries comprises salesforce object query language (SOQL) compliant query syntax, where the SOQL implemented in cloud APIs and does not use assertion consumer service (ACS);

detect whether any of the one or more paging queries have not been specified with an explicit total order;

enhance automatically and with the database query agent, for the one or more paging queries without an explicit total order with a total ordering, wherein the total ordering comprises at least a offset clause and a limit clause to support paging of query results;

cause, with the database query agent, the database query to be performed within a multitenant database environment with the clauses indicating one or more offset and limit values to be used in displaying results from the database query in a paged format on a user electronic device, wherein the one or more offset values indicate a subset within the results from the database query to be presented, wherein offset calculation is performed by a database server;

impose, with the database query agent, an order by clause on the results from the database query with the database server to ensure the query result set ordering is consistent; and

return, with the database query agent, the subset as determined by the one or more offset values to the user electronic device.

7. The article of claim 6 wherein the one or more offset values indicate a subset of rows within the results from the database query to return.

8. The article of claim 7 wherein the one or more offset values operate to impose a limit on the number of rows to return.

9. The article of claim 6 wherein the order is based on a query shape.

10. The article of claim 6 wherein the order is based on a query size.

11. An apparatus comprising:

means for receiving, with a database query agent provided by a hardware database server, one or more paging queries, wherein the queries comprises salesforce object query language (SOQL) compliant query syntax, where the SOQL implemented in cloud APIs and does not use assertion consumer service (ACS);

means for detecting whether any of the one or more paging queries have not been specified with an explicit total order;

means for enhancing automatically and with the database query agent, for the one or more paging queries without an explicit total order with a total ordering, wherein the total ordering comprises at least a offset clause and a limit clause to support paging of query results;

means for causing, with the database query agent, the database query to be performed within a multitenant database environment with the clauses indicating one or more offset and limit values to be used in displaying results from the database query in a paged format on a user electronic device, wherein the one or more offset values indicate a subset within the results from the database query to be presented, wherein offset calculation is performed by a database server;

means for imposing, with the database query agent, an order by clause on the results from the database query with the database server to ensure the query result set ordering is consistent; and

means for returning, with the database query agent, the subset as determined by the one or more offset values to the user electronic device.

12. The apparatus of claim 11 wherein the order is based on a query shape.

13. The apparatus of claim 11 wherein the order is based on a query size.

14. A system comprising:

a 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 server system further configurable to receive, with a database query agent provided by a hardware database server, one or more paging queries, wherein the queries comprises salesforce object query language (SOQL) compliant query syntax, where the SOQL implemented in cloud APIs and does not use assertion consumer service (ACS), to detect whether any of the one or more paging queries have not been specified with an explicit total order, to enhance automatically and with the database query agent, for the one or more paging queries without an explicit total order with a total ordering, wherein the total ordering comprises at least a offset clause and a limit clause to support paging of query results, to cause the database query to be performed with the clauses indicating one or more offset and limit values to be used in displaying results from the database query in a paged format on a user electronic device, wherein the one or more offset values indicate a subset within the results from the database query to be presented, wherein offset calculation is performed by a database server, to impose an order by clause on the results from the database query with the database server to ensure the query result set ordering is consistent, and to return the subset as determined by the one or more offset values to the user electronic device.

15. The system of claim 14 wherein the one or more offset values indicate a subset of rows within the results from the database query to return.

16. The system of claim 15 wherein the one or more offset values operate to impose a limit on the number of rows to return.

17. The system of claim 14 wherein the order is based on a query shape.

18. The system of claim 14 wherein the order is based on a query size.