Abstract: In response to identifying an update operation for a system table of a DBMS, a row that corresponds to the update operation is identified using a partial image of the update operation. A before image that corresponds to the row is gathered and a new before image of the row that reflects the update operation is generated by overlaying the before image with the partial image. In response to identifying a delete operation that relates to the system table, a row of the system table that corresponds to the delete operation is identified using an identifier of the delete operation. A before image that corresponds to this row is gathered. A new before image of the row of the system table that reflects the delete operation is generated by applying the delete operation to this before image.

Abstract: An embodiment generates, responsive to receiving a declarative replication specification, a logical map comprising a plurality of paths to completing a data replication process identified by the replication specification. The embodiment determines, responsive to generating the logical map, an optimal path to completing the data replication process by searching the plurality of paths of the logical map using a cost-directed search algorithm to find the optimal path from among the plurality of paths. The embodiment also performs, responsive to finding the optimal path, a series of data replication operations for replicating source data on a target database. The embodiment also detects, during a runtime of the data replication process, a predetermined change to a runtime environment of the data replication process. The embodiment also determines, responsive to detecting the predetermined change, a revised optimal path for performing the data replication process in the changed runtime environment.

Abstract: In response to identifying an update operation for a system table of a DBMS, a row that corresponds to the update operation is identified using a partial image of the update operation. A before image that corresponds to the row is gathered and a new before image of the row that reflects the update operation is generated by overlaying the before image with the partial image. In response to identifying a delete operation that relates to the system table, a row of the system table that corresponds to the delete operation is identified using an identifier of the delete operation. A before image that corresponds to this row is gathered. A new before image of the row of the system table that reflects the delete operation is generated by applying the delete operation to this before image.

Abstract: An embodiment includes extracting, after a first specified time interval, recovery data from a recovery log for a data table corresponding to a set of database operations on the data table that occurred during the first specified time interval. The embodiment also generates index data for a progress record associated with the first time interval. The progress record includes a first data field for storing data representative of a first net change to the data table resulting from a first subset of the set of database operations. The first subset of database operations are associated with a first transaction. The embodiment also detects a commit operation in the first subset of database operations that committed the first transaction. The embodiment also recovers the first transaction in a target data table using the recovery log and the first net change data associated with the first transaction in the progress record.

Abstract: An embodiment includes locating source data associated with a data replication request, and identifying a property of a data value of the source data using a reflection process. The embodiment determines a meta-type for the data value using an automaton that identifies a matching extent class from among an indexed set of extent classes that define respective accessors that are invoked to locate an extent class that corresponds with the property of the data value. The embodiment generates target data having the data value and a data type that corresponds with the matching extent class. The embodiment generates a changes feed that includes the generated target data, evaluates data in the changes feed to determine whether a specified condition has been satisfied and, if so, generates a trigger signal that initiates an event, where the trigger signal comprising information that satisfied the specified condition.

Abstract: An embodiment includes extracting, after a first specified time interval, recovery data from a recovery log for a data table corresponding to a set of database operations on the data table that occurred during the first specified time interval. The embodiment also generates index data for a progress record associated with the first time interval. The progress record includes a first data field for storing data representative of a first net change to the data table resulting from a first subset of the set of database operations. The first subset of database operations are associated with a first transaction. The embodiment also detects a commit operation in the first subset of database operations that committed the first transaction. The embodiment also recovers the first transaction in a target data table using the recovery log and the first net change data associated with the first transaction in the progress record.

Abstract: An embodiment generates, responsive to receiving a declarative replication specification, a logical map comprising a plurality of paths to completing a data replication process identified by the replication specification. The embodiment determines, responsive to generating the logical map, an optimal path to completing the data replication process by searching the plurality of paths of the logical map using a cost-directed search algorithm to find the optimal path from among the plurality of paths. The embodiment also performs, responsive to finding the optimal path, a series of data replication operations for replicating source data on a target database. The embodiment also detects, during a runtime of the data replication process, a predetermined change to a runtime environment of the data replication process. The embodiment also determines, responsive to detecting the predetermined change, a revised optimal path for performing the data replication process in the changed runtime environment.

Abstract: An embodiment includes locating source data associated with a data replication request, and identifying a property of a data value of the source data using a reflection process. The embodiment determines a meta-type for the data value using an automaton that identifies a matching extent class from among an indexed set of extent classes that define respective accessors that are invoked to locate an extent class that corresponds with the property of the data value. The embodiment generates target data having the data value and a data type that corresponds with the matching extent class. The embodiment generates a changes feed that includes the generated target data, evaluates data in the changes feed to determine whether a specified condition has been satisfied and, if so, generates a trigger signal that initiates an event, where the trigger signal comprising information that satisfied the specified condition.

Abstract: A method deploys a set of coupled data transformation modules describing a data transformation, the data transformation for transforming a data structure from a first format to a second format. The method includes receiving an instruction for selecting the set of transformation modules from a memory; converting each of the set of transformation modules to a common model format, the set of modules having at least one transformation module being of a module type of a type set including language constructed modules and visually constructed modules; and generating an executable version of the converted transformation modules suitable for execution by a data transformation engine. The executable version, when executed, transforms the data structure from the first format to the second format.

Abstract: A method of performing distributed development of a computer software application by using a WebDAV (Web Distributed Authoring and Versioning) client, to access a WebDAV server, ensures that referential integrity is maintained when checking in documents from the client top the server.

Abstract: The invention pertains to a computer tutorial system wherein software product training is provided interactively by guiding the user, for example, through one or more examples or applications that can be created in and/or using the product. More particularly, the invention involves a computer implemented, interactive tutorial system providing online instruction in conjunction with a contemporaneously operating software product to, for example, create such examples or applications and the tutorial system further providing for the creation of such examples or applications in and/or using the product.

Abstract: The invention pertains to a computer tutorial system wherein software product training is provided interactively by guiding the user, for example, through one or more examples or applications that can be created in and/or using the product. More particularly, the invention involves a computer implemented, interactive tutorial system providing online instruction in conjunction with a contemporaneously operating software product to, for example, create such examples or applications and the tutorial system further providing for the creation of such examples or applications in and/or using the product.

Abstract: When data, such as tool data, is commonly accessible, there is a danger that concurrent user processes will make overlapping modifications and leave the data in an incomplete or incomprehensible state. The invention provides a locking mechanism to guard against this. The lock objects are maintained in pool or repository. Two types of lock objects are provided; shareable locks that may be shared by many user processes and permit only read access to the locked data, and exclusive locks, useable by only one user process at a time, that permit the owning process to modify the locked data.