Systems and methods for cursored collections

• US 7,447,675 B2
• Filed: 02/13/2003
• Issued: 11/04/2008
• Est. Priority Date: 02/21/2002
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: BEA Systems Incorporated (Oracle Corporation)
• Inventors: White, Seth, Shinn, Matthew
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US10/365,907
• Publication Number:
  US 20040002965A1
• Time in Patent Office: 2,091 Days
• Field of Search: 707/3, 707/10, 707/102, 707/104, 707/1, 707/103.Y, 717/118
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A cursored collection can be used to allow a user to view subsets of a data result set, thereby conserving system resources. A persistence manager can execute SQL statements on a database, receive a result set from the database, and populate a set of EJBs with the result set. This can be a full result set, or a subset of the full result set. A bean manager can allow the user to access all the EJBs or a subset of the EJBs. The bean manager can also provide the user with a list of EJBs and let the client select the EJBs to access. The client can then iterate through the result set, either by viewing different subsets or selecting different EJBs from the list. This iterative process can continue until all the results have been viewed or the client does not wish to access any more results from the set.

Claims

1. A computer-based system for allowing a client to execute a query against a database, comprising:

a persistence manager to receive a query request from a client and generate SQL for the query, the persistence manager further to execute the SQL on a database and receive a result set from the database, the persistence manager populating a set of EJBs with results of the result set wherein multiple EJBs are thus filed with the results of a single query into the database; and

a bean manager to provide the client with access to one of the set of EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result, the bean manager storing the set of EJBs in local cache;

wherein the computer based system includes at least one processor.

2. A system according to claim 1, further comprising a home interface to receive the query request from the client and contact the bean manager.

3. A system according to claim 2, wherein said home interface executes a security check before contacting the bean manager.

4. A system according to claim 1, wherein said persistence manager populates the set of EJBs with a subset of the result set for each of a number of iterations through the result set.

5. A system according to claim 1, further comprising a finder method for execution by the client, the finder method generating the query request.

6. A system according to claim 1, wherein said bean manager provides the client with a list of EJBs in local cache, said bean manager allowing the client to select EJBs from the list to which the user wants access.

7. A method for allowing a client to execute queries against a database, comprising:

executing a finder method to generate a query to be executed against a database;

generating the SQL for the query and executing the query against the database;

receiving a set of results from the database corresponding to the query, and populating a set of EJBs with the results wherein multiple EJBs are thus filed with the results of a single query into the database;

allowing the client to access the set of EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

8. A method according to claim 7, further comprising:

selecting a new subset of results and populating a new set of EJBs with the new subset of results.

9. A method according to claim 7, further comprising:

storing the set of EJBs in local cache.

10. A method for allowing a client to execute queries against a database, comprising:

executing a finder method to generate a query to be executed against a database;

generating the SQL for the query and executing the query against the database;

receiving a set of results from the database corresponding to the query and populating a set of EJBs with the results of a single query into the database;

allowing the client to access a subset of the EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

11. A method according to claim 10, further comprising:

allowing the client to access another subset of the EJBs.

12. A method according to claim 10, further comprising:

storing the set of EJBs in local cache.

13. A computer-readable storage medium, comprising:

means for executing a finder method to generate a query to be executed against a database;

means for generating the SQL for the query and executing the query against the database;

means for receiving a set of results from the database corresponding to the query and populating a set of EJBs with the results of a single query into the database;

means for allowing the client to access the EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

14. A computer program product on a computer-readable storage medium for execution by a server computer for allowing a client to execute queries against a database, comprising:

computer code for executing a finder method to generate a query to be executed against a database;

computer code for generating the SQL for the query and executing the query against the database;

computer code for receiving a set of results from the database corresponding to the query and populating a set of EJBs with the results of a single query into the database;

computer code for allowing the client to access a subset of the EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

15. A computer-based system for allowing a client to execute queries against a database, comprising:

means for executing a finder method to generate a query to be executed against a database;

means for generating the SQL for the query and executing the query against the database;

means for receiving a set of results from the database corresponding to the query and populating a set of EJBs with the results of a single query into the database;

means for allowing the client to access the EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein the computer based system includes at least one processor;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

16. A computer system comprising:

a processor;

object code executed by said processor, said object code configured to;

execute a finder method to generate a query to be executed against a database;

generate the SQL for the query and executing the query against the database;

receive a set of results from the database corresponding to the query and populating a set of EJBs with the results wherein multiple EJBs are thus filed with the results of a single query into the database;

allow clients to access the EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

17. A computer-readable storage medium, comprising:

a code segment including instructions to execute a finder method to generate a query to be executed against a database;

a code segment including instructions to generate the SQL for the query and executing the query against the database;

a code segment including instructions to receive a set of results from the database corresponding to the query and populating a set of EJBs with the results of a single query into the database;

a code segment including instructions to allow the client to access the EJBs;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

18. A computer-based method comprising:

generating SQL for a query and executing the query against a database;

receiving a set of results from the database corresponding to the query and populating a set of EJBs with single results of the set of results, such that each EJB of the set contains a different result wherein multiple EJBs are thus filed with the results of a single query into the database;

wherein the EJBs are stored as a cursored collection that allows a client to execute a “

next result”

method to step through the EJBs, each EJB containing a single result;

wherein a persistence manager is adapted to receive a query request from the client and generate SQL for the query;

wherein the persistence manager executes the SQL on the database; and

wherein the persistence manger populates the set of EJBs.

19. The method of claim 18, further comprising populating another EJB with the set of results.