Patent ID: 8296271

Claim:
A method, performed by a computer-implemented system, for data recovery in a parallel database, the method comprising: determining whether data stored in the parallel database has been corrupted by a previously performed transaction; receiving, at a user interface of the computer-implemented system, a plurality of scanning parameters input by a user corresponding to the previously performed transaction, the plurality of scanning parameters including a user identification, a location, a time and an operation; scanning transaction log files stored in a plurality of memory devices corresponding to each node of the parallel database based on the plurality of scanning parameters to retrieve the previously performed transaction defined by the plurality of scanning parameters and determining at least one operation corresponding to the previously performed transaction that caused the corruption, the transaction log files including information on at least one previously performed transaction that modified a state of the parallel database; generating, based on the scanned transaction log files, information corresponding to original data based on the corrupted data before the at least one operation, and generating a file indicating additions, deletions or modifications of the corrupted data based on the at least one operation; comparing the corrupted data to the information corresponding to the original data; modifying the corrupted data with the information so that any modifications related to the at least one operation are corresponding to the original data based on the comparison modified to correspond to the original data; displaying operations performed on the corrupted data based on the scanning parameters input by a user; selecting one of the displayed results as the at least one operation responsible for corrupting the data; and generating information corresponding to the original data before the data was corrupted by the at least one operation specified by the selection.