final review
add comments
database transaction time range considered