Ide integration with JDBC

• US 20030172076A1
• Filed: 03/07/2002
• Published: 09/11/2003
• Est. Priority Date: 03/07/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Barsness, Eric Lawrence, Dettinger, Richard Dean, Santosuosso, John Matthew, Arnold, Jeremy Alan
• Granted Patent: US 7,110,991 B2
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

The present invention is directed to a method and apparatus of providing programming assistance for an integrated development environment. In one embodiment, a code portion is received. An attempt to retrieve a structured query language (SQL) statement that corresponds with the line code is then made. A recommendation based on the code portion for restructuring the corresponding SQL statement is then generated. The recommendation may include a modified SQL statement, referred to as a recommended SQL statement or a textual spoken language recommendation.

Claims

1. A method of providing programming assistance for an integrated development environment, comprising:

receiving a code portion;

attempting to retrieve a corresponding structured query language (SQL) statement that corresponds with the code portion; and

generating a recommendation based on the code portion for restructuring the corresponding SQL statement.

2. The method of claim 1, wherein the recommendation comprises one of a recommended SQL statement and a textual spoken language recommendation.

3. The method of claim 1, further comprising displaying the recommendation.

4. The method of claim 2, further comprising displaying the corresponding SQL statement and the recommended SQL statement.

5. The method of claim 2, further comprising, prior to retrieving the corresponding SQL statement, determining whether the code portion can be modified to be processed more efficiently by substituting the corresponding SQL statement with the recommended SQL statement.

6. The method of claim 2, wherein the recommended SQL statement performs at least one function performed by the code portion.

7. The method of claim 2, further comprising, prior to generating the recommended SQL statement, retrieving a database type for providing a proper syntax for the recommended SQL statement.

8. The method of claim 1, wherein the code portion is configured to retrieve independent fields from a database.

9. The method of claim 1, wherein the code portion is in Java.

10. The method of claim 1, wherein retrieving the corresponding SQL statement comprises retrieving the corresponding SQL statement from a prior execution of the code portion.

11. The method of claim 1, wherein retrieving the corresponding SQL statement comprises retrieving the corresponding SQL statement from a repository of predefined SQL statements.

12. A computer-readable medium containing a program which, when executed by a processor, performs an operation providing programming assistance for an integrated development environment, the operation comprising:

receiving a code portion;

attempting to retrieve a corresponding structured query language (SQL) statement that corresponds with the code portion; and

generating a recommendation based on the code portion for restructuring the corresponding SQL statement.

13. The computer-readable medium of claim 12, wherein the recommendation comprises one of a recommended SQL statement and a textual spoken language recommendation.

14. The computer-readable medium of claim 12, further comprising displaying the recommendation.

15. The computer-readable medium of claim 13, further comprising displaying the corresponding SQL statement and the recommended SQL statement.

16. The computer-readable medium of claim 13, further comprising, prior to retrieving the corresponding SQL statement, determining whether the code portion can be processed more efficiently by substituting the corresponding SQL statement with the recommended SQL statement.

17. The computer-readable medium of claim 13, wherein the code portion is configured to retrieve independent fields from a database.

18. A computer, comprising:

a memory containing a programming assistance program for an integrated development environment; and

a processor which, when executing the programming assistance program, performs an operation comprising;

receiving a code portion;

attempting to retrieve a corresponding structured query language (SQL) statement that corresponds with the code portion; and

generating a recommendation based on the code portion for restructuring the corresponding SQL statement.

19. The computer of claim 18, further comprising a display device and wherein the operation further comprises displaying the recommendation on the display device.

20. The computer of claim 18, wherein the recommendation comprises one of a recommended SQL statement and a textual spoken language recommendation.

21. The computer of claim 18, further comprising displaying the corresponding SQL statement and the recommended SQL statement.

22. The computer of claim 18, further comprising, prior to retrieving the corresponding SQL statement, determining whether the code portion can be processed more efficiently by substituting the corresponding SQL statement with the recommended SQL statement.

23. The computer of claim 18, wherein the code portion is configured to retrieve independent fields from a database.