How do you handle database transactions to ensure data consistency and integrity under high concurrent write loads?