System, method, and computer program for maintaining consistency between a NoSQL database and non-transactional content associated with one or more files

摘要

A system, method, and computer program product are provided for maintaining consistency between a NoSQL database and non-transactional content associated with one or more files. In operation, the system identifies one or more files including non-transactional data for maintaining consistency between the non-transactional data and a NoSQL database associated with the system. The system stores the non-transactional data associated with the one or more files in a transaction file. The system stores artifacts associated with the non-transactional data in a file with an ending marker and stores the non-transactional data with a corresponding transaction ID. The system stores data of the transaction file in the NoSQL database associated with the system. The system stores the transactional data with the corresponding transaction ID. The system scans the transaction file utilizing an asynchronous process to locate successful transactions. Moreover, the system distributes the artifacts associated with the successful transactions to their corresponding final locations.