Displaying and refactoring programs that include database statements
AssigneeInternational Business Machines Corporation
InventorsAzadeh Ahadian, Stephen Andrew Brodsky, Michael George Burke, Rebecca B. Nin, Igor Peshansky, Mukund Raghavachari, Sonali Surange
Life of this patent
Estimating the term…
Abstract
Embodiments of the invention provide techniques for displaying and refactoring of programs, including database statements. In one embodiment, database statements embedded in the program source are evaluated to identify statements of the source code affected by, or affecting, the changed element of the database. An indication of the statements of source code affected by or affecting the changed element of the database may be presented to a user.
Claims24
A computer-implemented method for refactoring source code of an application in response to changes to a database accessed by the application, comprising:
- detecting, by operation of one or more processors, a change to an element of the database;
- identifying one or more database statements embedded in the source code of the application;
- examining each of the one or more database statements embedded in the source code of the application using a mapping data structure to at least one of:
- identify statements of the source code affected by the changed element of the database, and identify statements of the source code affecting the changed element of the database, wherein the mapping data structure is configured to store relationships between elements of the database, the one or more database statements and the statements of the source code;
- and
- presenting an indication of the identified statements of the source code.
A computer-readable storage medium containing a program, which, when executed performs an operation for refactoring source code of an application in response to changes to a database accessed by the application, the operation comprising:
- detecting a change to an element of the database;
- identifying one or more database statements embedded in the source code of the application;
- evaluating each of the one or more database statements embedded in the source code of the application using a mapping data structure to at least one of:
- identify statements of the source code affected by the changed element of the database and identify statements of the source code affecting the changed element of the database, wherein the mapping data structure is configured to store relationships between elements of the database, the one or more database statements and the statements of the source code;
- and
- presenting an indication of the identified statements of the source code.
A system, comprising:
- a processor;
- and
- a memory containing a program, which when executed on the processor, is configured to perform an operation for refactoring source code of an application in response to changes to a database accessed by the application, by performing steps of:
- detecting a change to an element of the database;
- identifying one or more database statements embedded in the source code of the application;
- evaluating each of the one or more database statements embedded in the source code of the application using a mapping data structure to at least one of:
- identify statements of the source code affected by the changed element of the database, and identify statements of the source code affecting the changed element of the database, wherein the mapping data structure is configured to store relationships between elements of the database, the one or more database statements and the statements of the source code;
- and
- presenting an indication of the identified statements of the source code.
Dependencies are inferred from the claim text.