Abstract: Transaction change data replication includes identifying changes being made to a source database as part of an ongoing transaction at a source. The identifying is performed as the changes are made to the source database and as the transaction remains ongoing prior to commit or rollback thereof at the source. The source and a target are in a replication relationship in which data of the source database at the source is replicated to destinations in a target database at the target. The indications of the changes being made to the source are forwarded, to the target, as the transaction remains ongoing prior to commit or rollback thereof, and based on ending the transaction at the source, an indication of the transaction end is sent to the target.

Abstract: The present invention provides an improved process for preparation of L-threo-(2S,3R)-3-(3,4-dihydroxyphenyl)serine (I) (Droxidopa) and its salts; comprising (a) reaction of the aldehyde compound (III) (as described herein) with Metal complex (II) (as described herein), and (h) hydrolysis of the compound (IV) obtained from step (a) in presence of acid. The present invention also relates to a novel intermediates metal chiral complex (IV) for the preparation of Droxidopa.

Abstract: An approach for inter-table parallel refresh in a database management system (DBMS). An inter-table refresher receives DBMS source and target databases comprising source parent and related source child datasets. The inter-table refresher determines a collection of the source parent and the related source child datasets and creates a collection of parent and child refresh segments based on the collection of the source parent and child datasets. The inter-table refresher creates a collection of parent and child refresh batches based on the collection of parent and child refresh segments respectively and outputs an inter-table refresh batch schedule based on the collection of the parent refresh batches and the collection of the child refresh batches where the collection of the parent refresh batches and the collection of the child refresh batches operate concurrently and a current child refresh batch follows the completion of a respective current parent refresh batch.

Abstract: Techniques are described for supporting Fibre Channel over Ethernet (FCoE) link aggregation groups (LAGs) between a server and a data center switch in a data center. The techniques enable an access switch in the data center switch to assign class identifiers to each member link in an FCoE LAG between an FCoE node (Enode) of the server and the access switch. In this way, the access switch is able to redirect FCoE traffic from a Fibre Channel forwarder (FCF) of a storage area network (SAN) toward the Enode on the correct member link of the FCoE LAG. The techniques also enable scaling of FCoE initialization protocol (FIP) and FCoE sessions by installing FIP snooping filters that use on a source media access control (MAC) address hit determination in ingress filter processors (IFPs) of the access switch to avoid session limitations of virtual local area network (VLAN) filter processors (VFPs).

Abstract: An approach for inter-table parallel refresh in a database management system (DBMS). An inter-table refresher receives DBMS source and target databases comprising source parent and related source child datasets. The inter-table refresher determines a collection of the source parent and the related source child datasets and creates a collection of parent and child refresh segments based on the collection of the source parent and child datasets. The inter-table refresher creates a collection of parent and child refresh batches based on the collection of parent and child refresh segments respectively and outputs an inter-table refresh batch schedule based on the collection of the parent refresh batches and the collection of the child refresh batches where the collection of the parent refresh batches and the collection of the child refresh batches operate concurrently and a current child refresh batch follows the completion of a respective current parent refresh batch.

Abstract: Log reader and parser sharing determination in a change data capture environment includes obtaining log record identifiers for a group of data consumers of transaction log file data in transaction log files, identifying a respective restart log position and current log position for each data consumer of the group of data consumers, determining transaction log file distances between the restart log positions and the current log positions of each of one or more pairs of data consumers, calculating resource costs for data consumers of each pair to share a log reader and log parser, determining whether to share a log reader and log parser between any two or more data consumers of the group, and performing processing based on the determining whether to share.

Abstract: The invention relates to a commercially viable, cost effective and energy efficient process for the preparation of 2-(1H-Imidazol-4-yl)ethanamine or pharmaceutically acceptable salts thereof in high purity and yield via application of continuous flow technology.

Abstract: A method, computer program product, and computer system for handling open transactions in a data replication environment is provided. The method includes determining a database user that initiated an earliest open transaction in a transaction log. The method further includes, upon determining that the database user does not have access privileges for one or more tables of a target database corresponding to one or more tables of a source database associated with the earliest open transaction, skipping replication of the earliest open transaction to the target database, such that the data replication system no longer waits for the earliest open transaction to complete. The skipping includes discarding, from the transaction log, one or more entries related to the earliest open transaction, and identifying, in the transaction log, a next earliest open transaction.

Abstract: A processor-implemented method for selective data replication recovery in a heterogeneous environment is provided, including a source agent, a target agent, and data replication recoverer (DRR) agent. The method includes receiving, by a DRR agent, one or more committed transaction records from a source agent, which is configured to receive the one or more committed transaction records from a source database. The DRR agent creates data and metadata records from the received one or more committed transaction records, and saves the data and the metadata records in a data replication repository. In response to receiving a request to recover a target database, the DRR agent selectively recovers target database using either one or more individual transactions or a bookmark.

Abstract: A method for handling of open transactions in a data replication environment. The method includes querying one or more tables of a source database to determine a first open transaction associated with the one or more tables of the source database. The method further includes determining a database user that initiated the first open transaction. The method further includes querying one or more tables of the target database corresponding to the one or more tables of the source database associated with the first open transaction, to determine whether the database user has access privileges for the one or more tables of the target database and dynamically skipping replication of the first open transaction to the target database, such that the data replication system no longer waits for the first open transaction to complete.

Abstract: A method for handling of open transactions in a data replication environment. The method includes querying one or more tables of a source database to determine a first open transaction associated with the one or more tables of the source database. The method further includes determining a database user that initiated the first open transaction. The method further includes querying one or more tables of the target database corresponding to the one or more tables of the source database associated with the first open transaction, to determine whether the database user has access privileges for the one or more tables of the target database and dynamically skipping replication of the first open transaction to the target database, such that the data replication system no longer waits for the first open transaction to complete.

Abstract: A support housing for a flexible bioprocess bag, the housing comprising at least one side wall having a first segment and a second segment, the first segment movable in relation to the second segment between an open and a closed position, wherein at least a supporting part of the housing is translatable from an operating position to a bag loading position, wherein the supporting part comprises one or more retainers for holding the flexible bioprocess bag upon re-translation of the supporting part to the operating position and movement of the first segment to the closed position, and wherein the first segment comprises a first drive unit for connecting and driving a first mixing unit in the flexible bioprocess bag.

Abstract: A system and method for performing a dynamic rollover of source and target latency in a replication environment. One or more tables of a source data store being replicated to a target data store are parked, wherein any subsequent changes for the parked tables are not replicated to the target data store. Open transactions are identified where the parked tables affect the source and target latency, wherein the open transactions are in-progress and not completed. The source and target latency are then calculated for the identified open transactions.

Abstract: In optimizing net change data replication across a plurality of transactions in a replication environment, a source replication engine at a source database system: obtains a window in a source database log for the net change data replication; for a given row identifier found in the source database log, identifies an initial operation and a latest operation across the plurality of transactions within the window; compares the initial operation and the latest operation for the given row identifier to determine a net change to a row associated with the given row identifier; and stores the net change as a final operation on the given row identifier in an optimization repository for replication to a target database. The operations stored in the optimization repository are then sent to a target database system for replication to the target database.

Abstract: Embodiments generally relate data replication in databases. In some embodiments, a method includes accessing transaction information from a staging store at a first database. The method further includes determining one or more records to be prefetched from a hard disk of a second database based on the transaction information. The method further includes prefetching the one or more records to be prefetched from the hard disk. The method further includes storing the one or more prefetched records in a memory of the second database. The method further includes updating the one or more records stored in the second database based on the transaction information.

Abstract: The present invention relates to a complete process for preparation of high flux and salt rejection thin film composite (TFC) reverse osmosis (RO) membrane including process for preparation of support membrane for thin film, process for thin film coating of support membrane by in-situ interfacial polymerization between diamines and trimesoyl chloride, machine design, chemistry and details of process (engineering+chemistry+ambient) parameter at 1×100 sqm scale upgradeable to a scale even 10-20 times higher. The produced membrane is characterized by 96% salt rejection and 48 LM-2H 1 flux with 2000 ppm sodium chloride solution at 250 psi pressure and 95% salt rejection and 46 LM2H 1 flux with 35000 ppm sodium chloride solution at 900 psi pressure. The present invention also relates to complete machine design for PSF ultrafiltration membrane casting and coating for TFC membrane production at commercial level.

Abstract: An approach for inter-table parallel refresh in a database management system (DBMS). An inter-table refresher receives DBMS source and target databases comprising source parent and related source child datasets. The inter-table refresher determines a collection of the source parent and the related source child datasets and creates a collection of parent and child refresh segments based on the collection of the source parent and child datasets. The inter-table refresher creates a collection of parent and child refresh batches based on the collection of parent and child refresh segments respectively and outputs an inter-table refresh batch schedule based on the collection of the parent refresh batches and the collection of the child refresh batches where the collection of the parent refresh batches and the collection of the child refresh batches operate concurrently and a current child refresh batch follows the completion of a respective current parent refresh batch.

Abstract: An approach for inter-table parallel refresh in a database management system (DBMS). An inter-table refresher receives DBMS source and target databases comprising source parent and related source child datasets. The inter-table refresher determines a collection of the source parent and the related source child datasets and creates a collection of parent and child refresh segments based on the collection of the source parent and child datasets. The inter-table refresher creates a collection of parent and child refresh batches based on the collection of parent and child refresh segments respectively and outputs an inter-table refresh batch schedule based on the collection of the parent refresh batches and the collection of the child refresh batches where the collection of the parent refresh batches and the collection of the child refresh batches operate concurrently and a current child refresh batch follows the completion of a respective current parent refresh batch.

Abstract: The present invention relates to an improved process for preparation of carmustine (I). The present invention also relates to preparation of 1,3-bis(2-chloroethyl)urea (II) an intermediate used in preparation of carmustine.

Abstract: Embodiments generally relate data replication in databases. In some embodiments, a method includes accessing transaction information from a staging store at a first database. The method further includes determining one or more records to be prefetched from a hard disk of a second database based on the transaction information. The method further includes prefetching the one or more records to be prefetched from the hard disk. The method further includes storing the one or more prefetched records in a memory of the second database. The method further includes updating the one or more records stored in the second database based on the transaction information.