Development environment for managing database aware software projects

Inactive Publication Date: 2010-11-18
IBM CORP
View PDF1 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0008]Embodiments of the invention provide an integrated development environment (IDE) tool configured to connect the artifacts generated by tools from one perspective to another, effectively making all tools available to each other. One embodiment of the invention includes a method for an IDE tool to manage software development artifacts. The method may generally include executing the IDE tool on a computing system having at least a processor, a memory, and a storage device. The IDE tool, when executed, may perform an operation which includes receiving a request to access a project file, displaying contents of the project file in an editing pane of the IDE tool and presenting, in a second pane of the IDE tool, a design canvas for composing a database object. The operation may further include generating from a database object composed on the design canvas, a representation of the database object to include in the project file, inserting the representation of the database object in the project file, and storing an indication of the relationship between the database object and the project file.

Problems solved by technology

However, application programs have long since ceased to be developed as a single application built from a group of source code files.
More generally, database applications such as these typically have to create / consume numerous artifacts based on the business needs, inter-component interactions and best practices.
However, while many of the results of a development effort overlap significantly and interact with one another, the development tools themselves do not include mechanisms for connecting different aspects of the development process with one another.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Development environment for managing database aware software projects
  • Development environment for managing database aware software projects
  • Development environment for managing database aware software projects

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023]As noted above, software applications include many heterogeneous artifacts—each of which may be created by different individuals having different skill sets. And developers often share such artifacts with one another in an iterative process as application development evolves. Doing so frequently requires artifacts to be moved between different project files manually. For example, the text of an SQL statement composed by a database administrator (having expertise in a particular database) has to be manually cut / paste from SQL scripts into application source code (being composed by a developer). More simply, at least from a developer's perspective, IDE tools having a common underlying understanding of the components needed to build a database application are missing.

[0024]Embodiments of the invention introduce development tools that connect these various artifacts in a database aware fashion. For example, embodiments of the invention integrate SQL query builders across multiple ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

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.

Description

BACKGROUND OF THE INVENTION[0001]1. Field of the Invention[0002]Embodiments of the invention relate to tools used to develop application software. More specifically, embodiments of the invention provide an enhanced integrated development environment (IDE) for managing application source code, database systems, and related artifacts.[0003]2. Description of the Related Art[0004]Developing software applications is a complex task, and IDE tools are available to assist computer programmers with the development process. Currently, IDE tools are available to assist programmers developing applications in a variety of programming languages (e.g., Java® .net, C, C++, C#, etc.). These tools are typically configured with features such as auto-indenting, syntax highlighting, type checking, and a variety of other features that assist the development process. An IDE tool usually includes a text editor that visually displays errors as source code is typed, allowing a developer to correct errors bef...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F9/44G06F7/00
CPCG06F8/10G06F8/60G06F8/30
InventorAHADIAN, AZADEHBENDER, TODD R.BRODSKY, STEPHEN A.CHU, CLIFFORD D.COURTOIS, ZEUS O.NIN, REBECCA B.PAUSER, MICHAEL L.PAYTON, BRIAN G.SURANGE, SONALIZHANG, HONGDI
OwnerIBM CORP