Abstract: A method and system for migrating data between databases is provided. Metadata is obtained from a source database and used to determine the manner in which the data within the source database should be migrated to a target database. The metadata provides a mechanism for structuring queries to retrieve the data within the source database in a generic manner, thereby providing a generic determination of the structure of the data to be migrated. The dependencies among tables in the source database are discovered, thereby providing an order to the migration operations to be performed when migrating the data. This order ensures that the data can be migrated correctly in the presence of referential integrity (foreign key) constraints. In addition, custom mapping operations may be performed during the migration operations so that the data from the source database is modified before writing the data to the target database.

Abstract: A method for updating operational parameters of a monitoring agent on a client in a distributed data processing system is presented. The monitoring agent filters the outgoing network data traffic from the client to a server and determines whether an outgoing transaction is addressed such that an application on the server receives the outgoing transaction as a request to change the operational parameters of the monitoring agent. The outgoing transaction is parsed for a destination address and matched with a destination address stored as an operational parameter of the monitoring agent on the client. The destination address may be a Uniform Resource Locator (URL) embedded within a Hypertext Transport Protocol (HTTP) request. In response to a positive determination, the monitoring agent then sends a request to the server to send to the monitoring agent an update of the operational parameters of the monitoring agent.

Abstract: An apparatus and method for deleting objects from an object-relational system in a customizable and database independent manner. The apparatus and method provide a customizable and database independent mechanism for the deletion of object data from a relational database. The method implemented by the apparatus determines the dependency structure of a relational database using database metadata. The dependency structure is then utilized to determine the type of deletion to be performed on data representations of the object and its related objects, i.e., parent or child objects. The deletion actions include cascade deletion and nullify columns deletion. Appropriate SQL statements are then automatically generated at run-time to perform the deletion of the object data from the relational database.

Abstract: Metadata is obtained from a database and provided to an object model that uses the database for persisting the state of its objects. The metadata provides the object model with constraints, size limits, or other limiting information about a database so that the object model can anticipate and handle potential errors that could occur at the database level. Rather than keeping the metadata embedded within the database, the object model obtains access to the metadata and can adopt policies for dealing with those constraints and limits. In addition, the object model is also provided with heuristics that can be applied to storage processing of attributes. In this manner, the object model becomes metadata-aware and can handle database operations more intelligently and thus propagate fewer errors to the client.