How do you design an optimal database schema for a fast-growing transactional dataset that requires real-time analytical reporting?
