IPC분류정보
국가/구분 |
United States(US) Patent
등록
|
국제특허분류(IPC7판) |
|
출원번호 |
US-0092987
(2002-03-07)
|
발명자
/ 주소 |
- Arnold,Jeremy Alan
- Barsness,Eric Lawrence
- Dettinger,Richard Dean
- Santosuosso,John Matthew
|
출원인 / 주소 |
- International Business Machines Corporation
|
대리인 / 주소 |
|
인용정보 |
피인용 횟수 :
7 인용 특허 :
15 |
초록
▼
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 mad
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.
대표청구항
▼
What is claimed is: 1. A method of providing programming assistance, comprising: providing an integrated development environment configured to recommend optimizations of source code; receiving a selected fragment of source code, wherein the source code fragment includes a source code statement that
What is claimed is: 1. A method of providing programming assistance, comprising: providing an integrated development environment configured to recommend optimizations of source code; receiving a selected fragment of source code, wherein the source code fragment includes a source code statement that references a result of a structured query language statement (SQL); retrieving the SQL statement corresponding to the source code statement; presenting a user interacting with the integrated development environment with a recommendation for optimizing the retrieved SQL statement, relative to the source code statement, wherein the recommendation comprises one of a recommended SQL statement and a textual spoken language recommendation; and prior to retrieving the corresponding SQL statement, determining whether the fragment of source code can be modified to be processed efficiently by substituting the corresponding SQL statement with the recommended SQL statement. 2. The method of claim 1, further comprising displaying the recommendation. 3. The method of claim 1, further comprising displaying the corresponding SQL statement and the recommended SQL statement. 4. The method of claim 1, wherein the recommended SQL statement performs at least one function performed by the fragment of source code. 5. The method of claim 1, further comprising, prior to generating the recommended SQL statement, retrieving a database type for providing a proper syntax for the recommended SQL statement. 6. The method of claim 1, wherein the fragment of source code is configured to retrieve independent fields from a database. 7. The method of claim 1, wherein the fragment of source code is in Java. 8. The method of claim 1, wherein retrieving the corresponding SQL statement comprises retrieving the corresponding SQL statement from a prior execution of the fragment of source code. 9. The method of claim 1, wherein retrieving the corresponding SQL statement comprises retrieving the corresponding SQL statement from a repository of predefined SQL statements. 10. A computer-readable storage medium containing a program which, when executed by a processor, performs an operation for providing programming assistance for an integrated development environment, the operation comprising: receiving a selected fragment of source code, wherein the source code fragment includes a source code statement that references a result of a structured query language statement (SQL); retrieving the SQL statement corresponding to the source code statement; presenting a user interacting with the integrated development environment with a recommendation for optimizing the retrieved SQL statement, relative to the source code statement, wherein the recommendation comprises one of a recommended SQL statement and a textual spoken language recommendation; and prior to retrieving the corresponding SQL statement, determining whether the fragment of source code can be modified to be processed efficiently by substituting the corresponding SQL statement with the recommended SQL statement. 11. The computer-readable storage medium of claim 10, further comprising displaying the recommendation. 12. The computer-readable storage medium of claim 10, further comprising displaying the corresponding SQL statement and the recommended SQL statement. 13. The computer-readable storage medium of claim 10, wherein the fragment of source code is configured to retrieve independent fields from a database. 14. A computer for providing programming assistance, comprising: a memory containing a programming assistance program for an integrated development environment to recommend optimizations of source code; and a processor which, when executing the programming assistance program, performs an operation comprising: receiving a selected fragment of source code, wherein the source code fragment includes a source code statement that references a result of a structured query language statement (SQL); retrieving the SQL statement corresponding to the source code statement; presenting a user interacting with the integrated development environment with a recommendation for optimizing the retrieved SQL statement, relative to the source code statement, wherein the recommendation comprises one of a recommended SQL statement and a textual spoken language recommendation; and prior to retrieving the corresponding SQL statement, determining whether the fragment of source code can be modified to be processed efficiently by substituting the corresponding SQL statement with the recommended SQL statement. 15. The computer of claim 14, further comprising a display device and wherein the operation further comprises displaying the recommendation on the display device. 16. The computer of claim 14, further comprising displaying the corresponding SQL statement and the recommended SQL statement. 17. The computer of claim 14, wherein the fragment of source code is configured to retrieve independent fields from a database.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.