International Business Machines Corporation

Ken Maycock

Pedro Miguel Barbas

David M Tilson

Joseph Duffy

Niambh Scullion

Santhosh K Balasa Ramnath

Joseph M McAndrew

Gary Murtagh

Shay Roe

Rizaldy G Ignacio

A processor tracks a frequency of access requests of a first index corresponding to a first data page of a plurality of data pages stored in a database. The processor determines the first index corresponding to the first data page having a frequency of access requests that exceeds a configurable target, and the processor retains, with preference, the first data page that corresponds to the first index, within the cache memory.

Pre-caching of relational database management system based on data retrieval patterns

As disclosed herein a computer system for secure database backup and recovery in a secure database network has N distributed data nodes. The computer system includes program instructions that include instructions to receive a database backup file, fragment the file using a fragment engine, and associate each fragment with one node, where the fragment is not stored on the associated node. The program instructions further include instructions to encrypt each fragment using a first encryption key, and store, randomly, encrypted fragments on the distributed data nodes. The program instructions further include instructions to retrieve the encrypted fragments, decrypt the encrypted fragments using the first encryption key, re-encrypt the decrypted fragments using a different encryption key, and store, randomly, the re-encrypted fragments on the distributed data nodes. A computer program product and method corresponding to the above computer system are also disclosed herein.

Secure database backup and recovery

According to an aspect, a computer implemented method for managing a database in real-time is provided. The method includes scanning for predetermined data in a predetermined workload stream during real-time operation of the database, and determining a workload priority for located predetermined data according to one or more workload rules. A storage priority of located predetermined data is determined according to a physical location of the located predetermined data. The located predetermined data are moved during the real-time operation of the database to a different physical location if the storage priority and the workload priority do not match.

Increased database performance via migration of data to faster storage

Growing community of inventors

Dublin, Ireland

Ken Maycock