International Business Machines Corporation

Pravin Kailashnath Kedia

Nirmal Kumar

James D Spyker

Elaine Pang

Dev K Sarkar

Sudhir Bhaurao Titirmare

Sajesh Sreedharan Kakkara

Gaurav Mehrotra

Shailesh Chandra Jamloki

Jagadisha Bhat

In an approach for detecting and processing multiple audio signals simultaneously, an audiometric receiver system comprises a transmitter, wherein the transmitter comprises a digital signal processor, and wherein the digital signal processor comprises a quality check component, an amplifier or attenuator component, mixer component, a modulator component, and an encrypter component; and a receiver, wherein the receiver comprises a decrypter component, a demodulator component, a splitter component, and a second amplifier or attenuator component.

Audiometric receiver system to detect and process audio signals

Obtaining insights on how database system tables are evolving. In some instances, risk aware database system triggers that have read only access to the columns of interest are utilized, thereby allowing a user to fully study the changes made to the database system tables while maintaining the security and integrity of these database system tables. Additionally, these database system triggers can be used to audit changes that are happening on the database system tables using views.

Gaining insights on database system table changes

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.

Net change mirroring optimization across transactions in replication environment

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.

Dynamic roll-over of source and target latency in a replication environment

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.

Database access performance improvement

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.

ACL based open transactions in replication environment

The present specification describes a system. The system includes a code generator to 1) generate a Morse code message from an intended message and 2) decode a received Morse code message. The system also includes a high-frequency transceiver to 1) transmit Morse code messages in the high frequency electromagnetic range and 2) receive Morse code messages in the high frequency electromagnetic range.

High frequency Morse code transmission

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.

Inter-table parallel refresh maximizer

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.

Smart data replication recoverer

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.

Growing community of inventors

Mumbai, India

Pravin Kailashnath Kedia