Patent ID: 8301609
Filing Date: 2012-10-30
Classification: G06F

Abstract:
1. A method comprising: identifying a set of records in a database for relocation during an on-line database reorganization (ODBR) process, each record associated with a unique record reorganization lock (RRL); relocating, by a computer, the set of records from a current location to a new location, the relocating including for each record in the set of records: receiving a request to update a target record in the set of records with updated data, the receiving a request to update a target record overlapping in time with at least a portion of the relocating and the receiving a request to update a target record received from an application; requesting a RRL associated with the target record, the RRL associated with the target record configured to prevent access to both the current location and the new location of the target record, the requesting independent of the application; receiving the RRL associated with the target record; updating the target record, the updating comprising writing target data to the target record in the current location and writing the target data to the target record in the new location; and releasing the RRL associated with the target record.