How would you structure a database to support both rapid transactional writes and complex analytical queries by researchers?