Systems and methods for dynamic querying

• US 7,587,417 B2
• Filed: 03/30/2006
• Issued: 09/08/2009
• Est. Priority Date: 01/18/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: BEA Systems Incorporated (Oracle Corporation)
• Inventors: White, Seth, Shinn, Matthew, Woollen, Robert
• Primary Examiner(s): LeRoux; Etienne P
• Assistant Examiner(s): CHEN, TE Y
• Application Number:
  US11/393,044
• Publication Number:
  US 20060173832A1
• Time in Patent Office: 1,258 Days
• Field of Search: 707/103.R, 707/104.1, 717/108, 719/310
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A user can generate queries dynamically at runtime without having to redeploy the appropriate EJB or hard-code the query into the user application. A properties object can be generated to accept the query settings from the user. These settings can be extracted at runtime when the appropriate finder method is invoked, such that the desired query statement, such as a SQL statement, can be generated and executed against the database.

This description is not intended to be a complete description of, or limit the scope of, the invention. Other features, aspects, and objects of the invention can be obtained from a review of the specification, the figures, and the claims.

Claims

1. A system for dynamically generating a query to be executed on a database, comprising:

a properties object that contains settings for a query as specified by a user, wherein the properties object is generated at runtime and receives the settings from dynamic user input received at runtime;

a finder method for initiating the query;

a descriptor that contains an enable dynamic queries element, wherein the enable dynamic queries element has a value of either true or false for enabling the query, such that invoking queries when the enable dynamic queries element has a value of false results in a remote or local exception being thrown depending on whether the queries submitted after setting the enable dynamic queries element were invoked from a local interface or a remote interface and wherein the dynamic queries element is specifiable by an enable-dynamic-queries parsed character data (PCDATA) tag, wherein said tag signifies that the dynamic queries element contains character data parsed by an extensible markup language (XML) parser;

a server computer that queries the database, the server computer receiving a call from the finder method and reading the settings from the properties object in order to generate the appropriate SQL query statements to be sent to the database, wherein the SQL query statements are generated by parsing the finder method and wherein options that are set for the SQL query statements are specified in the settings contained in the properties object;

a database connected to the server computer for executing the dynamically generated SQL query statements; and

a collection of results that is returned from the database in response to the finder method, said finder method being invoked on a query home interface used to execute dynamic queries, wherein the collection of results is stored on the server computer.

2. A system according to claim 1, further comprising:

a user interface that allows a user to specify the settings in the property object.

3. A system according to claim 1, further comprising:

a client containing the properties object and the finder method.

4. A system according to claim 1, further comprising:

a bean associated with the database upon which the finder method is invoked.

5. The system of claim 1, wherein the dynamic queries element is a sub-element of said descriptor.

6. The system of claim 1, wherein the settings are used to determine a use of the collection of results that is returned from the database.

7. The system of claim 1, wherein the finder method accepts an instance of a primary key and returns an instance of an entity type.

8. The system of claim 1, wherein the query is programmatically defined and functions slower than a statically defined query for at least one type of application.

9. A system for generating dynamic queries, comprising:

a client computer that provides a properties object which contains settings for a query specified by a user, wherein the properties object is generated at runtime and receives the settings from dynamic user input at runtime;

a server computer that communicates with the client computer and a database, the server computer providing a bean associated with the database; and

a finder method that specifies the query to be executed against the database, the finder method invoked on the bean provided by the server computer;

a descriptor that contains an enable dynamic queries element, wherein the enable dynamic queries element has a value of either true or false for enabling the query, such that invoking queries when the enable dynamic queries element has a value of false results in a remote or local exception being thrown depending on whether the queries submitted after setting the enable dynamic queries element were invoked from a local interface or a remote interface, wherein the dynamic queries element is specifiable by an enable-dynamic-queries parsed character data (PCDATA) tag, wherein said tag signifies that the dynamic queries element contains character data parsed by an extensible markup language (XML) parser;

wherein upon invocation of the finder method, the server computer extracts the settings contained in the properties object and parses the finder method in order to dynamically generate the query to be sent to the database; and

a collection of results that is returned from the database in response to the finder method, said finder method being invoked on a query home interface used to execute dynamic queries.

10. A system according to claim 9 wherein the finder method is declared in a query home interface on the client and server computers.

11. A system according to claim 9, further comprising:

a user interface on the client computer for allowing the user to specify the settings contained in the properties object.

12. A system according to claim 9 wherein the bean is an Enterprise Java Bean (EJB) and the size of the EJB deployment descriptor is reduced by dynamically generating the query.

13. A system according to claim 9 wherein the settings specify at least one of:

the resulting set of objects returned by the query, the maximum number of elements that should be returned by the query, the return type of the finder method, whether updates made during the current transaction must be reflected in the result of the query and whether a new transaction should be started for the execution of the query.

14. A system according to claim 9 further comprising:

a properties key containing entries wherein each entry specifies a setting for the query.