Enable database transactions for consistent operations

Currently, the database does not support transactions, leading to potential inconsistencies during complex operations. Implementing transaction support will ensure operations are executed atomically and maintain data integrity.

Identify the database library and connection layer in the codebase, likely in a database module or configuration. Review existing complex operations to understand where atomicity is needed. Implement transaction support using the database library's API, ensuring proper commit/rollback logic. Test changes by simulating failure scenarios to verify data integrity.

索引モデルが issue の本文から書いたものです。