What are the considerations for implementing advanced concurrency control mechanisms, such as optimistic concurrency control, snapshot isolation, and Serializable Snapshot Isolation (SSI), to ensure transactional consistency and isolation levels in concurrent database transactions