Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Methods, apparatus and articles of manufacture are described that eliminate the administrative complexities, latency and scalability restrictions associated with conventional methods for providing asynchronous access to database operations. An asynchronous messaging engine is integrated with and executed within a database system and provides access to database system capabilities and resources, such as shared memory, buffer pools, and process controls. The need for external asynchronous message data exchange processes is eliminated, thereby eliminating the latency associated with the extra hop conventionally required to move data from an external process to the database and eliminating the complexities associated with starting, stopping and monitoring such processes.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of controls that may be executed in a computer connected to an Internet or Intranet, without the requirement that the controls be installed on the server. This is accomplished by encapsulating the data needed to execute the control without installing the control as objects in an application file storing the entire software project. The application file is copied to a data storage device of the server, which in turn retrieves the application file, accesses the objects containing the data needed to execute the control without installing the control, and then processes the data to execute the control.