International Business Machines Corporation

Constance Jane Nelin

Daniel Edward House

Howard Justin Glaser

Frederick Thomas Sharp

Abdul Al-Azzawe

Tanya Couch

Charles Daniel Wolfson

Rebecca Braun Nin

Tom Robert Christopher

Stephen James Todd

Brian Joseph Owings

James Louis Keesey

Marc-Thomas Schmidt

Timothy Nicholas Holloway

Jean C Ho

Shu-Huar Joseph Yeh

Gerald Herman Roth

Thomas E Conrad

Bruce A Benfield

Gerold Johann Wilmot

Debbani Kundu

A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

Testing environment for database server side logic

A method for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The method eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

Aspects for integrating encryption functionality into a database system are described. The aspects include providing at least two functions to support data encryption in a database system. The at least two functions are utilized within structured query language statements to preserve confidentiality of user-specified data in the database system.

Method and system for integrating encryption functionality into a database system

A method, apparatus and article of manufacture is provided for debugging within a computer system network. The method uses XML dataflows from/to a console for debugging of instructions located in a server, which has a database management system for retrieving data from a database stored in an electronic storage device coupled to the server. The method uses a debugger manager at the console for commanding and monitoring debugging operations of the server-side instructions, performed by a debugger engine, and uses XML command and status report dataflows for providing a database communication interface between the debugger manager and the debugger engine. Some preferred embodiments use stored procedures in addition to the XML dataflows, and the debugger manager executes in a multi-threaded environment.

SQL debugging using XML dataflows

A method and system for tracking a plurality of actions against at least one object by a computer system is disclosed. The method and system comprises providing an output view, wherein the output view includes a first output area and a second output area. An action list containing each of the plurality of actions is displayed in one of the first and second output areas. A user is allowed to select one action from the action list, and information associated with the selected action is displayed in the other of the first and second output areas.

Method and system for displaying actions and historical content in an output view

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

Provided is a method, system, and program for processing a data flow. A message is received at an input node. The message is transferred to a plurality of nodes according to a defined data flow. At one stored procedure node, the message is processed to generate input parameters for a stored procedure call. The stored procedure node transfers the stored procedure call to a stored procedure at a server computer, wherein the server executes the stored procedure to process data and generate output.

Method, system, and program for accessing stored procedures in a message broker

A method, apparatus, and article of manufacture and memory for providing a programming development environment that supports the development of Internet and Intranet applications. More specially, the present invention discloses an efficient, versatile dynamic debugger that allows platform-independent debugging of applications written in a wide variety of languages.

Dynamically debugging user-defined functions and stored procedures

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of Internet and Intranet applications. More specially, the present invention discloses a multi-tier debugger that allows the debugging of applications executing on multiple tiers at the same time, when the tiers are on separate machines or when the tiers are on a single machine. The debugger is split into a window module and a runtime module.

Multi-tier debugging

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

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of Internet and Intranet applications. In particular, an extender user interface for creating a relational database extender is provided. A window is displayed on the monitor. The window illustrates a relational database extender, which comprises multiple objects.

Extender user interface

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of Internet and Intranet applications. More specifically, a visual representation of an application file is displayed in a project window on a monitor connected to a computer. The visual representation comprises a hierarchical view of a project and its components stored in the application file, and includes one or more visual elements indicating a component is shared.

Shared modules graphical user interface

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of Internet and Intranet applications. More specifically, a visual representation of an application file is displayed in a project window on a monitor connected to a computer. The visual representation comprises a hierarchical view of a project and its components stored in the application file.

Multi-tier view project window

A method, apparatus, and article of manufacture for simulating a multi-tiered environment on a single computer. An application file is generated comprising second tier instructions invoking first tier instructions and third tier instructions. The application file is provided to the second and third tier runtime engines. The second tier instructions are executed in the second tier runtime engine. The third tier instructions are executed in the third tier runtime engine. A debugger on the first tier debugs the executed instructions.

Growing community of inventors

Austin, TX, United States of America

Constance Jane Nelin