Abstract: Techniques are provided for processing a workflow. A workflow including one or more data management activities is received. A workflow description is generated from the workflow that includes a description of the one or more data management activities. One or more data management operations are generated from the workflow description. The one or more data management operations are executed against one or more data management systems.

Abstract: A centralized method for defining and enforcing strong-typing among domains in RDBMS or ORDBMS is provided to allow flexible, easy, and quick domain creation, as well as facilitating easy implementation and change control on domains. When an application requests data from the database, one or more domains are first identified in the SQL query. A determination is then made as to whether operators for each domain pair in the SQL query are authorized. A determination is also made as to whether functions in the SQL authorized. If the operators and functions in the SQL are authorized, the initial SQL request is rewritten to include a casting formula for each domain pair operation. The rewritten SQL request is then executed.

Abstract: Activities within a workflow are either data management activities (DMAs) or non-DMAs. A workflow is typically carried out by a system by executing one activity after the other. This can, however, be very time consuming. A method and system are provided for optimizing a group of activities (GOA) comprising a DMA, whereby the GOA is comprised in the workflow to improve the overall performance. The method determines the DMAs, and for each DMA, a data level statement (DLS). The GOA is determined and a process graph model (PGM) is determined from the GOA so that the DLS is comprised in the PGM and the semantics of the PGM are identical to those of the GOA. The PGM is optimized for which an optimized GOA is determined. The semantics of the optimized GOA are identical to those of the GOA. In the workflow, the GOA is replaced by the optimized GOA.

Abstract: A centralized method for defining and enforcing strong-typing among domains in RDBMS or ORDBMS is provided to allow flexible, easy, and quick domain creation, as well as facilitating easy implementation and change control on domains. When an application requests data from the database, one or more domains are first identified in the SQL query. A determination is then made as to whether operators for each domain pair in the SQL query are authorized. A determination is also made as to whether functions in the SQL authorized. If the operators and functions in the SQL are authorized, the initial SQL request is rewritten to include a casting formula for each domain pair operation. The rewritten SQL request is then executed.

Abstract: A method, apparatus and program storage device for mapping data objects, residing in multiple data sources or generated dynamically, into a single or multiple reusable software components, for integrated information access to multiple disparate data sources, residing on or generating the data dynamically on different hardware systems and possibly in different data formats. A user identifies selected data objects from multiple data sources and registers them with an information integration software facility, in order to create at least one virtual data object having at least one attribute from the selected registered data objects, and to wrap access to the at least one virtual data object into a reusable software component, as though it was a single real data object, accessible directly from software applications.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for automatic workflow processing in a workflow processing computer system.

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 implementing the method, transparently archives data. One or more data sources store data. A first data mover moves a first subset of data from the one or more data sources to a first federated archive in accordance with a first set of rules. In another aspect of the invention, a query is processed to retrieve a second subset of data, and a portion of the second subset of data is retrieved from the first federated archive. In yet another aspect of the invention, the processing of the query determines whether any data that would satisfy the query is stored in the first federated archive.

Abstract: A method, apparatus and article of manufacture is provided for mapping data objects residing in multiple data sources, or generated dynamically, into a single, reusable software component, for integrated information access to multiple disparate data sources, residing on or generating the data dynamically on different hardware systems and possibly in different data formats. The method has steps for identifying data objects in multiple data sources, employing an information integration software facility for connecting to the data sources containing the data objects, and registering the data objects with the software facility, creating a single virtual data object consolidating multiple attributes from the registered data objects, and establishing a connection to the software facility for referencing the virtual data object as though it was a single real data object. It also has a step for wrapping this virtual data object as a reusable software component accessible directly from applications.

Abstract: The present invention provides a method, system and program product for automatically generating an invoking mechanism from a web service description, thereby enabling integration of a service external to a database into a database such that the service may be easily invoked from the database. Preferably, the service is a web service available over the internet The service may be invoked from any of a number of invoking mechanisms of the database. In a first specific embodiment, the mechanism comprises a user-defined function within an SQL statement. In a second specific embodiment, the mechanism comprises a virtual table. In a third specific embodiment, the mechanism comprises a stored procedure. In a fourth specific embodiment, the mechanism comprises a trigger. In a fifth specific embodiment, the mechanism comprises a federated table accessed via a nickname and implemented using a wrapper.

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: A method, apparatus and article of manufacture is provided for mapping data objects residing in multiple data sources, or generated dynamically, into a single, reusable software component, for integrated information access to multiple disparate data sources, residing on or generating the data dynamically on different hardware systems and possibly in different data formats. The method has steps for identifying data objects in multiple data sources, employing an information integration software facility for connecting to the data sources containing the data objects, and registering the data objects with the software facility, creating a single virtual data object consolidating multiple attributes from the registered data objects, and establishing a connection to the software facility for referencing the virtual data object as though it was a single real data object. It also has a step for wrapping this virtual data object as a reusable software component accessible directly from applications.

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 mapping persistent data objects residing in multiple data sources into a single, reusable software component accessible to an object-oriented programming language application performed by the computer, for multi-database access to data that may be physically distributed and stored in disparate DBMSs, each stored in an electronic storage device coupled to the computer. The method has steps for identifying data objects in multiple data sources, employing a multi-database software facility for connecting to the data sources containing the data objects, and registering the data objects with the multi-database software facility, creating a single virtual data object consolidating multiple attributes from the registered data objects, and establishing a connection to the multi-database software facility for referencing the virtual data object as though it was a single real data object.

Abstract: Provided are a method, system, and program for generating a program capable of invoking a flow of operations, wherein the program is capable of being initiated from an external call. A definition file defining a flow of operations and mapping information defining input parameters to the flow of operations are received. The received definition file and mapping information are processed to generate program statements within the program that when executed perform: setting input parameters to the flow of operations to values received from an external call to the program; invoking the flow of operations with the input parameters including values from the external call; and receiving output from the flow of operations and extracting at least one value from the received output to return to the external call.

Abstract: An emergency call monitor (110) monitors the progression of a call in a telephone switching system. The sequence of called digits for a call is detected by a line/trunk interface unit (200). A call-type processor (202) determines whether the call is an emergency call by examining the sequence of called digits and examining a call-type associated with the call. If the call is an emergency call, then a call monitor (204) is initiated to monitor the progression of the call through the telephone switch. If errors are encountered during the call, an alarm (206), including a visual and/or audible indicator, is asserted.

Abstract: The present invention provides a method, system and program product for integrating a service external to a database into a database such that the service may be easily invoked from the database. Preferably, the service is a web service available over the internet The service may be invoked from any of a number of invoking mechanisms of the database. In a first specific embodiment, the mechanism comprises a user-defined function within an SQL statement. In a second specific embodiment, the mechanism comprises a virtual table. In a third specific embodiment, the mechanism comprises a stored procedure. In a fourth specific embodiment, the mechanism comprises a trigger. In a fifth specific embodiment, the mechanism comprises a federated table accessed via a nickname and implemented using a wrapper.

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 is provided for mapping persistent data objects residing in multiple data sources into a single, reusable software component accessible to an object-oriented programming language application performed by the computer, for multi-database access to data that may be physically distributed and stored in disparate DBMSs, each stored in an electronic storage device coupled to the computer. The method has steps for identifying data objects in multiple data sources, employing a multi-database software facility for connecting to the data sources containing the data objects, and registering the data objects with the multi-database software facility, creating a single virtual data object consolidating multiple attributes from the registered data objects, and establishing a connection to the multi-database software facility for referencing the virtual data object as though it was a single real data object.