International Business Machines Corporation

Azadeh Ahadian

Stephen Andrew Brodsky

Sonali Surange

Rebecca Braun Nin

Brian Gerrit Payton

Zeus Orion Courtois

Michael Leon Pauser

Michael George Burke

Igor Peshansky

Tony Leung

Todd Robert Bender

Ardeshir Jamshidi

Clifford D Chu

Hongdi Zhang

Maryela Evelin Weihrauch

Anshul Dawra

Mukund Raghavachari

Daya Vivek

Michael Schenker

Vasantha Jayakumar

Embodiments of the invention provide database integration within an integrated development environment (IDE) tool for displaying database structure and other database information, query editing and execution, and error detection for database statements embedded in program source code. Embodiments of the invention integrate database connectivity and error detection into the IDE tool, thereby potentially reducing the time required for database-aware application development.

Database connectivity and database model integration within integrated development environment tool

Development tools are disclosed that connect various artifacts in a database aware fashion. For example, the development environment may integrate SQL query builders across multiple application development interfaces (e.g., a source code editor, XML editor, database scripting tools, etc.), significantly improving developer productivity, reducing development cost and time. Thus, the process of consuming heterogeneous artifacts in an application (or creating them for consumption) becomes a very productive experience, eliminating the need to manually cut/paste information in multiple project files in many cases.

Development environment configured to generate application source code from database objects

Embodiments of the invention introduce development tools that connect various artifacts in a database aware fashion. For example, embodiments of the invention integrate SQL query builders across multiple application development interfaces (e.g., a source code editor, XML editor, database scripting tools, etc.), significantly improving developer productivity, reducing development cost and time. Thus, the process of consuming heterogeneous artifacts in an application (or creating them for consumption) becomes a very productive experience, eliminating the need to manually cut/paste information in multiple project files in many cases.

Development environment for managing database aware software projects

Detecting and displaying errors in database statements within integrated development environment tool

A technique is disclosed for identifying impact of database changes on an application. Given a proposed database change, affected source code is identified that is affected by the proposed database change. References to the affected source code are created and organized into a hierarchy. A user can ascertain the extent of the impact by viewing the hierarchy and by using the hierarchy to access and view the affected source code in a visually distinct manner.

Identifying impact of database changes on an application

Embodiments of the invention provide application development tools that allow developers to rapidly build database-aware applications and database unit tests. Embodiments of the invention support multiple scenarios for database-aware application development, including beginning from a database table and automatically creating application code to access the table, beginning from an existing database query, beginning from existing application code that accesses a database, and hybrids or variations of these approaches.

Rapid application development for database-aware applications

Embodiments of the invention provide an IDE tool that provides rapid application development features for a variety of disparate data sources. Further, developers may customize and extend the rapid application development features to suit their development needs in a particular case. In a particular embodiment, the rapid application development template may be configured to generate a set of configuration files localized used to deploy a 'lightweight' application, such as a web-service, to a particular application server.

Extensible rapid application development for disparate data sources

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.

Displaying and refactoring programs that include database statements

Growing community of inventors

San Jose, CA, United States of America

Azadeh Ahadian