International Business Machines Corporation

Rebecca Braun Nin

Stephen Andrew Brodsky

Sonali Surange

Azadeh Ahadian

Brian Gerrit Payton

Zeus Orion Courtois

Michael Leon Pauser

Michael George Burke

Igor Peshansky

Ardeshir Jamshidi

Daniel Edward House

Constance Jane Nelin

Tony Leung

Todd Robert Bender

Clifford D Chu

Hongdi Zhang

Maryela Evelin Weihrauch

Howard Justin Glaser

Anshul Dawra

Mukund Raghavachari

Brian Joseph Owings

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.

Processing database queries embedded in application source code from within integrated development environment tool

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

A method, apparatus, article of manufacture, and memory for programmatically switching arbitrary HTML pages is disclosed. The method includes the steps of receiving control information in an application server from a client computer, and executing a script in the application server to generate a map relating HTML files with commands to show pages related to the HTML files. When a control event is received from the client computer, the mapping provides a basis for commanding the client computer's browser to switch to a second HTML page. In one embodiment, the invention also includes a program storage device, tangibly embodying instructions for performing the above method steps. The invention also includes an apparatus for remotely scripting local objects. The apparatus includes an application server having device such as a computer for receiving control information from a client computer, and a device for executing a script using the control information to generate a map relating a second HTML file with a command to show the HTML file.

Programmatic switching of arbitrary HTML forms

A method, apparatus, and article of manufacture for remotely scripting local objects. An applet is executed in a browser in a remote client computer, thereby generating control information. The control information is transmitted from the client computer to a network server. A script stored on the network server is executed using the control information. The execution of the script generates script output data. The script output data is transmitted from the network server to the browser. The output data can be thereafter used to execute another applet in the client browser. The output data need not comprise an entire HTML page, but may comprise only a portion of the page as required to display the required information.

Remote scripting of local objects

Growing community of inventors

Morgan Hill, CA, United States of America

Rebecca Braun Nin