How do you approach database schema design for a system that requires both high-write throughput and complex read queries?
