Patent ID: 9665431
Date: 2017-05-30
CPC Classifications: G06F

Claim:
1. A computer-implemented method for providing interrupted write protection to a stand-alone commodity storage array utilized within a database system, the method comprising the steps of: identifying, by processing means within said database system, a write of data from said database system to said storage array requiring interrupt protection; generating, by said processing means, an entry for an intent log maintained within said database system, said entry representing the write and containing a write identifier and an active status indication; completing, by said processing means, the write of data to said storage array; once the data write completes, generating, by said processing means, an entry to said intent log, said entry representing the write and containing a write identifier and an inactive status indication; following a database system failure, examining, by said processing means, said intent log entries to determine the status of the write; identifying, by said processing means, said write as an interrupted write when the most current intent log entry corresponding to said write has an active status indication; and reissuing, by said processing means, said write of data to said storage array when said write is identified as an interrupted write; and wherein said write identifiers include: a device identifier of a storage device within said storage array, a block offset on the storage device of the write, a length of the write, a checksum of the data to be written, and an identifying stamp used to determine the order of the entries when reading the intent logs following a crash.