Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database. The embodiment continues by modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table, and that cached data associated with the table is invalid while the modification is in progress for the table and performing the table update based, at least, on information received in the update request. The embodiment further continues by updating a value of a commit identification counter, and subsequently a table time stamp associated with the table, to indicate that all cached data associated with the table having a time stamp older than the updated time stamp are invalid. The embodiment further continues by modifying the value of the modification-in-progress counter to indicate the completion of table modification.