International Business Machines Corporation

Dirk Alexander Seelemann, Ii

Michael Jory

Michael Starkey

Vladimir Klicnik

Sunil Sarin

Lok Tin Loi

Christopher Lawrence Brealey

Glenn P Steffler

Jeffrey Grant Johnston

David Martin Lauzon

Dzmitry Lepniakou

Thomas P Boldt

Kevin Chan

Gaetan Nadon

Crystal J Su

Mohammad Wasif Khan

Srinivas Chari

Wassim Melhem

Milorad Stefanovic

Vito Spatafora

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.

Database management system data replication

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.

Declarative configuration for database replication

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.

Virtual transaction queues for database replication

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.

Automated data translation

Consistency of replicated data copies with statement-based replication is provided without requiring transaction serializability. At a subordinate replication node, a transaction start message, replicated data modification statements, and a transaction commit message are received for a next committed transaction from a master replication node, wherein the transaction start message carries a master transaction identifier, an invisibility list consisting of identifiers of other master transactions that had started and not yet committed when this master transaction started, and an earliest invisible master transaction identifier. The master transaction identifier, invisibility list, and earliest invisible transaction identifier are mapped to subordinate transaction identifiers to preserve an order of transaction identifiers from the master replication node. A subordinate transaction is started with the mapped subordinate transaction identifier and with an invisibility list consisting of the mapped subordinate transaction identifiers for the master invisibility list for execution of the received data modification statements.

Relaxing transaction serializability with statement-based data replication

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.

Integrated visual and language-based method for reusable data transformations

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.

Ensuring referential integrity when using WebDAV for distributed development of a complex software application

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.

Interactive tutorial

A metadata repository for use in an integrated development environment is provided. The metadata repository is layered to define levels of common behaviour useful to different types of application development tools. The most general use tools have access to metadata at the level of simple constructed types; more specialised tools have access to components that contain properties of a target language; highly specialised tools have access to composed partitionable part metadata that can be used for constructing distributed applications.

Hierarchical metadata store for an integrated development environment

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.

Growing community of inventors

Thornhill, Canada

Dirk Alexander Seelemann, Ii