Abstract: Embodiments herein present a method, computer program product, etc. for masking data failures. The method comprises storing a single master copy of data and a replica copy of the data. Next, the method performs writes to the master using a middleware component. Reads are then performed from either the master or the replica using the middleware component. When the master is unavailable, the writes are stored in a table located in the middleware component as stored write requests, wherein the stored write requests comprise UDI's to be made to the master. The reads are also performed from the table and the replica when the master is unavailable. When the master becomes available, the stored write requests are propagated to the master. Thus, by storing the write requests in the table, the middleware allows the writes to run during times when the master is unavailable.

Abstract: In order to obtain a novel binding protein against a chosen target, DNA molecules, each encoding a protein comprising one of a family of similar potential binding domains and a structural signal calling for the display of the protein on the outer surface of a chosen bacterial cell, bacterial spore or phage (genetic package) are introduced into a genetic package. The protein is expressed and the potential binding domain is displayed on the outer surface of the package. The cells or viruses bearing the binding domains which recognize the target molecule are isolated and amplified. The successful binding domains are then characterized. One or more of these successful binding domains is used as a model for the design of a new family of potential binding domains, and the process is repeated until a novel binding domain having a desired affinity for the target molecule is obtained.

Abstract: A globally unique transaction identifier for each transaction is recorded in log entries pursuant to a two-phase commit protocol, wherein multiple log entries in multiple database recovery logs that correspond to one transaction have a same globally unique transaction identifier. A causally ordered, ascending timestamp value is maintained in the log entries pursuant to the two-phase commit protocol. For each of the multiple database recovery logs, all the log entries related to a single transaction are marked identically with a mark unique to the single transaction in a given one of the database recovery logs. Global changes are identified for the single transaction from the log entries in the multiple database recovery logs based on the marking and the globally unique transaction identifier for each transaction by reading log entries based on the causally ordered, ascending timestamp value.

Abstract: Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. The data processing system implemented method directs the data processing system to process a query against data objects. The data objects are operatively coupled to the data processing system. The query includes a parent operator. The parent operator references a union operator. The union operator references sub-queries. The sub-queries reference the data objects. The data processing system implemented method includes noting a set of partitionings for the union operator, the noted set of partitionings being based on the sub-queries and being based on the data objects reference by the sub-queries, and executing the query having the union operator, the execution of the query being based on the noted set of partitionings and the parent operator.

Abstract: Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. A data processing system implemented method direct the data processing system to execute a query against a database having data objects. The query has sub-queries and having a union operator. The union operator is operable on sub-queries associated with the query. The database is operatively coupled to the data processing system.

Abstract: Disclosed is a data processing system, a data processing system-implemented method and an article of manufacture for providing general user availability while integrity processing of rolled-in data is deferred and performed incrementally. The data processing system includes a data warehouse administration module for administering a data warehouse to include a table dividable into portions for containing rows of rolled-in data, a first and a second delimiter delimiting the start and the end respectively of each portion, a metadata element having an entry corresponding to the start and end delimiters delimiting each portion, a third delimiter for delimiting, between the first delimiter and the third delimiter, a sub-portion of the portion, and an operations management module having operation mechanisms for performing operations on the data warehouse responsive to the delimiters.

Abstract: In order to obtain a novel binding protein against a chosen target, DNA molecules, each encoding a protein comprising one of a family of similar potential binding domains and a structural signal calling for the display of the protein on the outer surface of a chosen bacterial cell, bacterial spore or phage (genetic package) are introduced into a genetic package. The protein is expressed and the potential binding domain is displayed on the outer surface of the package. The cells or viruses bearing the binding domains which recognize the target molecule are isolated and amplified. The successful binding domains are then characterized. One or more of these successful binding domains is used as a model for the design of a new family of potential binding domains, and the process is repeated until a novel binding domain having a desired affinity for the target molecule is obtained.

Abstract: A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows of a plurality of table copies with a monotonic number, a copy identification, and propagation controls; asynchronously capturing at least one labeled change to any row of any of the plurality of table copies from a database recovery log; determining that the captured change is to be communicated to others of the plurality of table copies; communicating the captured change to the others of the plurality of table copies; and applying the communicated change to the others of the plurality of table copies, where the plurality of table copies converge to a same state. In applying the communicated changes, conflicting changes are identified and resolved. In this manner, convergence of data copies in asynchronous data replication is provided, and processing and storage costs are significantly reduced.

Abstract: An improved method and system for preserving data constraints during parallel apply in asynchronous transaction replication in a database system have been disclosed. The method and system preserves secondary unique constraints and referential integrity constraints, while also allowing a high degree of parallelism in the application of asynchronous replication transactions. The method and system also detects and resolves ordering problems introduced by referential integrity cascade deletes, and allows the parallel initial loading of parent and child tables of a referential integrity constraint.

Abstract: An improved method for providing parallel apply in asynchronous data replication in a database system is disclosed. The improved method and system provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The method and system detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the method and system requires significantly less overhead than conventional approaches.

Abstract: A method and system for member initialization to and deactivation from an asynchronous data replication group in a database system is disclosed. The method and system allows new members to be added to the replication group or existing members to be removed from the replication group, without requiring the halting of the asynchronous replication of data. The performance advantages of asynchronous replication are still realized during member initialization or deactivation.

Abstract: An automatic initial data load to a new table copy concurrently with active replication to existing table copies in an asynchronous replication group includes: initiating a data load of the new table copy; creating spill queue(s) at the new table copy; loading the data from a source table copy to the new table copy, where changes for the active table copies are applied during the loading, but changes to the new table copy are stored in a spill storage area; applying the changes in the spill storage area to the new table copy after the loading of the data is done; and removing the spill storage area after the changes have been applied to the new table copy. Thus, a new table copy is initialized into the replication group without requiring that replication be suspended at the source or any of the existing table copies during the initializing process.

Abstract: A method and system for asynchronously replicating data changes in a database system captures update information for a data update in a source table from a database log, where the data value from the data update is not in the database log. A query is built to obtain the data value from the source table using the update information, including a key column value that identifies the row of the source table in which the data resides. When the key column is also updated in the same or different transaction, the data update information is stored, and the updated key column value is replaced with a later captured key column update value. The query is built and executed, and the data update is replicated at a target table. In this manner, data objects whose values are not recorded in a database log can be asynchronously replicated in a database system.

Abstract: In a method, apparatus, and article of manufacture implementing the method for log-capture based replication, a mainline log reader publishes messages to a plurality of queues. The messages comprise changes for transactions extracted from a log. When one of the queues becomes unavailable, a catch-up log reader is launched to read from the log and to publish messages comprising changes for the transactions extracted from the log by the catch-up log reader, to the unavailable queue. When the unavailable queue becomes available and the catch-up log reader reaches the end of the log, the publishing of the messages for that queue is transferred from the catch-up log reader to the mainline log reader. In another aspect of the invention, the catch-up log reader is terminated.

Abstract: A system and method of lightweight asynchronous data replication that avoids the need for any persistent store at the replication source or communication channel, and is independent of the underlying data formats, wherein the method of data replication comprises replicating deltas from a source, embedding replication tracking information in the replicated deltas, wherein the tracking information comprises a timestamp and a sequence number, and applying deltas at a target. The tracking information is used to ensure that each delta is applied exactly once. In the event of a crash in the system, the target analyzes the tracking information to determine which deltas have been applied, and requests retransmission of replicated data from the source starting from the earliest unapplied delta. The source and target are treated as only delta producers and consumers, and as such the invention is applicable to replication between arbitrary data source formats.

Abstract: In order to obtain a novel binding protein against a chosen target, DNA molecules, each encoding a protein comprising one of a family of similar potential binding domains and a structural signal calling for the display of the protein on the outer surface of a chosen bacterial cell, bacterial spore or phage (genetic package) are introduced into a genetic package. The protein is expressed and the potential binding domain is displayed on the outer surface of the package. The cells or viruses bearing the binding domains which recognize the target molecule are isolated and amplified. The successful binding domains are then characterized. One or more of these successful binding domains is used as a model for the design of a new family of potential binding domains, and the process is repeated until a novel binding domain having a desired affinity for the target molecule is obtained.

Abstract: In order to obtain a novel binding protein against a chosen target, DNA molecules, each encoding a protein comprising one of a family of similar potential binding domains and a structural signal calling for the display of the protein on the outer surface of a chosen bacterial cell, bacterial spore or phage (genetic package) are introduced into a genetic package. The protein is expressed and the potential binding domain is displayed on the outer surface of the package. The cells or viruses bearing the binding domains which recognize the target molecule are isolated and amplified. The successful binding domains are then characterized. One or more of these successful binding domains is used as a model for the design of a new family of potential binding domains, and the process is repeated until a novel binding domain having a desired affinity for the target molecule is obtained.

Abstract: Novel small proteins which bind cathepsin G have been identified. These are useful as inhibitors of excessive cathepsin G activity in patients.

Abstract: In order to obtain a novel binding protein against a chosen target, DNA molecules, each encoding a protein comprising one of a family of similar potential binding domains and a structural signal calling for the display of the protein on the outer surface of a chosen bacterial cell, bacterial spore or phage (genetic package) are introduced into a genetic package. The protein is expressed and the potential binding domain is displayed on the outer surface of the package. The cells or viruses bearing the binding domains which recognize the target molecule are isolated and amplified. The successful binding domains are then characterized. One or more of these successful binding domains is used as a model for the design of a new family of potential binding domains, and the process is repeated until a novel binding domain having a desired affinity for the target molecule is obtained.

Abstract: In order to obtain a novel binding protein against a chosen target, DNA molecules, each encoding a protein comprising one of a family of similar potential binding domains and a structural signal calling for the display of the protein on the outer surface of a chosen bacterial cell, bacterial spore or phage (genetic package) are introduced into a genetic package. The protein is expressed and the potential binding domain is displayed on the outer surface of the package. The cells or viruses bearing the binding domains which recognize the target molecule are isolated and amplified. The successful binding domains are then characterized. One or more of these successful binding domains is used as a model for the design of a new family of potential binding domains, and the process is repeated until a novel binding domain having a desired affinity for the target molecule is obtained.