Abstract: A dynamically self-indexing database-management system selects database indexes associated with table columns that are most frequently accessed by user queries, deleting all other indexes. The system periodically reviews database-performance figures and data-usage patterns for each table of its database and revises its selection of indexes in order to ensure that only the most frequently accessed columns continue to be indexed and that the omission of other indexes does not degrade performance. The total number of selected indexes, the overall percent of selected indexes, or the selection itself is optimized over time through continued monitoring of database transaction logs. Optimization may comprise cognitive analytics or other methods of artificial intelligence by which the system learns over time how to best determine whether its current selection of indexes is likely to provide the best overall performance.

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: The present invention discloses the device for a urinary catheter employing electromagnetic radiation and/or vibration transducer. The device comprises a clip-on (4) including a source of electromagnetic radiation (5) and/or a vibration transducer and a coupler (3) that allows electromagnetic radiation access from clip-on to the inside of the coupler. The combination of electromagnetic radiation and photo catalyst material may increase effectiveness for antimicrobial activity. The device aims at preventing the catheter-associated urinary tract infection caused by both intraluminal and extraluminal routes.

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: In an approach for database log management and log access performance improvement, a processor receives an access request for an optimal control file to minimize a database access performance impact. A processor determines the optimal control file based on usage of a plurality of control files for a database. A processor outputs the optimal control file to a user to access the database. A processor provides an incremental sub-control file of the optimal control file to the user. The incremental sub-control file is an incremental view of the optimal control file to query the incremental log data in the database.

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: In an approach for database log management and log access performance improvement, a processor receives an access request for an optimal control file to minimize a database access performance impact. A processor determines the optimal control file based on usage of a plurality of control files for a database. A processor outputs the optimal control file to a user to access the database. A processor provides an incremental sub-control file of the optimal control file to the user. The incremental sub-control file is an incremental view of the optimal control file to query the incremental log data in the database.

Abstract: The invention provides systems, methods and computer program products for monitoring vascular perfusion in replanted tissue flaps. Specifically, the invention provides a non-invasive solution for monitoring of vascular perfusion at a site of tissue replantation, and that is capable of detecting problems in vascular perfusion and raising alarms in real times. The invention achieves the above function objectives by means of non-invasive sensors that continuously monitor selected parameters related to tissue condition. The monitored data parameters are used to determine a real time condition of replanted tissue.

Abstract: The present invention provides an improved process for preparation of the L-threo-(2S,3R)-3-(3 4-dihydroxyphenyl)serine (I) or a salt thereof, which is known as Droxidopa; comprising (a) recovery of the by-product compound (V) (as described herein) from the crude compound (I), and (b) recycling and re-use it for the preparation of droxidopa. Accordingly, the present invention relates to an improved economical process for the preparation of L-threo-(2S,3R)-3-(3.4-dihydroxyphenyl)serine (I) or its pharmaceutically acceptable salts; wherein the process relates to recovery and recycling of the by-product compound (V) and also to re-use it for the preparation of droxidopa.

Abstract: The present invention relates to stable pharmaceutical compositions of sulfur colloid, which advantageously provide a high radiochemical purity to 99mTc-pertechnetate without causing the gel formation. The compositions include pre-lyophilized and lyophilized compositions of sulfur colloid. It also relates to a non-radioactive kit which upon reconstitution with 99mTc-pertechnetate solution gives stabilized 99mmTc-Sulfur colloid radiopharmaceutical composition. Further, the process for preparation of said compositions and their use for diagnostic purposes are also disclosed.

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: 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: Disclosed herein are techniques to enable a device in a network to activate a remote user interface in a network during a financial transaction over a computer network. The device receives a first set of one or more packets from the user interface indicative of a particular card type received via the user interface. In response, the device accesses data stored in a BIN table and a rate table, to calculate a fee based on the received data. The device also calculates a convenience fee or incentive based on the received data and the accessed data from the BIN and rate tables. The device further sends a second set of one or more packets to the remote user interface via the network that activates the user interface to open a window displaying the calculated convenience fee or calculated incentive to a user.

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: Aspects described herein may relate to methods, systems, and apparatuses that determine one or more categories associated with a dataset, or a portion thereof. The determination may be performed based on one or more tags associated with the dataset and/or a description associated with the dataset. Further, the determination may be performed by searching an ontology based on the one or more tags and/or the description. The determination may be performed by using a machine-learning model based on the one or more tags and/or the description. Once the one or more categories associated with the dataset are determined, the one or more categories may be used as a basis for modifying the dataset and/or validating the dataset.

Abstract: A dynamically self-indexing database-management system selects database indexes associated with table columns that are most frequently accessed by user queries, deleting all other indexes. The system periodically reviews database-performance figures and data-usage patterns for each table of its database and revises its selection of indexes in order to ensure that only the most frequently accessed columns continue to be indexed and that the omission of other indexes does not degrade performance. The total number of selected indexes, the overall percent of selected indexes, or the selection itself is optimized over time through continued monitoring of database transaction logs. Optimization may comprise cognitive analytics or other methods of artificial intelligence by which the system learns over time how to best determine whether its current selection of indexes is likely to provide the best overall performance.

Abstract: A computer-implemented method includes writing a plurality of change records to a first set of redo records in a first transaction log file. The computer-implemented method further includes determining, while writing a change record to a redo record, that the change record includes changes made to data associated with an in-scope table. The computer-implemented method further includes updating the first transaction log file with information indicating that the redo record includes changes made to data associated with the in-scope table. The computer-implemented method further includes accessing the first transaction log file from storage in response to receiving a request for replicating changes made to data associated with in-scope tables. The computer-implemented method further includes scraping a first redo record in the first transaction log file in response to determining that the first redo record includes at least one change record associated with the in-scope table.

Abstract: The present invention provides an improved process for preparation of the L-threo-(2S,3R)-3-(3,4-dihydroxyphenyl)serine (I) or a salt thereof, which is known as Droxidopa; comprising (a) recovery of the by-product compound (V) (as described herein) from the crude compound (I), and (b) recycling and re-use it for the preparation of droxidopa. Accordingly, the present invention relates to an improved economical process for the preparation of L-threo-(2S,3R)-3-(3.4-dihydroxyphenyl)serine (I) or its pharmaceutically acceptable salts; wherein the process relates to recovery and recycling of the by-product compound (V) and also to re-use it for the preparation of droxidopa.

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.