International Business Machines Corporation

Jeffrey William Josten

David Harold Surman

Inderpal Singh Narang

David Arlen Elko

James Zu-Chia Teng

James Willis Pickel

James Z Teng

Chandrasekaran Mohan

Georgette L Kurdt

Jeffrey Mark Nick

Tina L Masatani

Curt Lee Cotner

Peter Dana Driever

Donna N Dillenberger

Kelly B Pushong

Tina Louise Mukai

Steven Bruce Jones

Brian Keith Howell

Xiaohong Fu

Yao Ching Stephen Chen

Shengxi Suo

Thomas Majithia

Michael C Cox

Scott F Schiffer

Nina Bronnikova

Riaz Ahmad

Sarbinder S Kallar

Shuo Li

Xiaobo Wang

Ping Wang

Namik Hrle

Min Li

You-Chin Gene Fuh

Ping Liang

Wendell W Wilkinson

John Joseph Campbell

Sauraj Goswami

Laura Michiko Kunioka-Weis

Haakon Roberts

RamanaKumari M Croisettier

Haakon Philip Roberts

A database-management system provides sargable evaluation for query predicates that compare an 'LHS' encrypted database-column operand to an 'RHS' expression operand. The system directly compares the two operands if all their attributes match. If the operands are encrypted string-type values differing only in length, the system truncates the RHS or pads it with encrypted blanks and, if a truncation loses meaningful data, evaluates the predicate as never satisfying an equality condition. In all other cases, if all attributes of a plaintext RHS don't match those of the plaintext data encoded into the LHS column, the system attempts to cast the RHS to match the plaintext LHS data. An error condition or data loss at this step allows the system to sargably evaluate the predicate without further analysis, but if the casting is successful and error-free, the system encrypts the resulting RHS and performs a sargable predicate evaluation.

Sargable evaluation of queries submitted to an encrypted database

A computing system includes an application configured to request execution of at least one translation including at least one command. A first coupling facility is configured to perform a first modification process to modify a first structure based on a received command associated with an ongoing transaction. A second coupling facility includes a secondary circular queue loaded with first data blocks indicating the first modification process, and is configured to output a message response block (MRB). The application determines a most recent modification process performed by the secondary coupling facility based on the MRB.

Computing system including enhanced application performance based on last completed operation sequence value

Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: examining data of breaches of a geofence by client computer devices to determine respective positions of the breaches; receiving by a database system transaction data from client computer devices, the transaction data defined by insert query data; changing a structure of an index of a certain table of the database system in response to the receiving; generating logging data in response to the receiving of the transaction data; providing using the logging data prediction specifying data, the prediction specifying data specifying one or more change predicted to occur with respect to the index; and modifying the index in dependence on the prediction specifying data.

Predictive database index modification

Sargable query-predicate evaluation for encrypted databases

A business application may provide a secure ledger update while maintaining anonymity and security from unauthorized third parties. One example may include receiving a new entry transaction to save data in a database/ledger. The example may also include receiving a request to add a record stored in a database with a new entry, adding the record by inserting the new entry, and enabling the new entry to be unchangeable from subsequent modification attempts based on an immutable attribute.

Database management system shared ledger support

A method for managing a cache structure of a coupling facility includes receiving a conditional write command from a computing system and determining whether data associated with the conditional write command is part of a working set of data of the cache structure. If the data associated with the conditional write command is part of the working set of data of the cache structure the conditional write command is processed as an unconditional write command. If the data associated with the conditional write command is not part of the working set of data of the cache structure a conditional write failure notification is transmitted to the computing system.

Conditional write processing for a cache structure of a coupling facility

A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.

High performance support for XA protocols in a clustered shared database

A partial index availability system places, in a restricted state, all pages in the index associated with a structure modification, when an error occurs in processing a log of the said structure modification. This maintains traversability of the rest of the index that is not in restricted state. The system locates and marks a left sentinel and a right sentinel associated with a non-leaf page that is in a restricted state preventing an undo of a transaction. The sentinels prevent a transaction from accessing an uncommitted change associated with the non-leaf page. After a recovery procedure is run the entire index is made available. During the period between the placement of the index pages in LPL or rebuild pending to the time of final removal of these pages from their restrictive states as a result of a recovery procedure being run, the users are given access to the non-restricted portion of the index.

System and method for increasing availability of an index

A system, method a computer usable storage medium tangibly embodying a program of instructions executable by the computer to perform a computer-based method for restoration of a database from a failed data recovery. For each failed data recovery the method generates a log error data set having log records of a faulty transaction unapplied to data due to inconsistency. Log error data set is directly useable by a log analysis tool to regenerate and redo the unapplied faulty transaction to recover the data and by a print log tool to diagnose the faulty transaction. Log records mimic format of records of an archive log data set and identify data objects, faulty transactions on the data objects and a range of the unapplied data objects' updates.

System and method for minimizing data outage time and data loss while handling errors detected during recovery

A method for performing a system level backup of a log-ahead database management system (DBMS) without suspending updates by application programs is described. The DBMS comprises a database mainline system, a backup utility and a restore utility. The data and log records are stored on separate storage volumes. Log records are written to identify objects that require special handling during the point-in-time recovery. The database engine operates normally during a backup except for suspending actions that would alter the file system catalog or write updates across a storage volume boundary; and by freezing the REDO log point in its checkpoint information. The backup utility copies the data volumes first and optionally the log volumes second while updates are allowed. The resulting inconsistencies are resolved either during a DBMS restart or during a point-in-time (PIT) recovery performed by the restore utility.

DBMS backup without suspending updates and corresponding recovery using separately stored log and data files

Disclosed is a system, method, and program for transferring data. When a transaction commits, multiple data objects that have been changed by the transaction are identified. The multiple data objects are written from local storage to a cache structure using a batch write command. When changed data objects at a first system that are not cached in the shared external storage are written to disk, a batch cross invalidation command is used to invalidate the data objects at a second system. Additionally, multiple data objects are read from the cache structure into a processor storage using a batch castout command.

Technique for data transfer

Growing community of inventors

San Jose, CA, United States of America

Jeffrey William Josten