Traditional data warehouse architectures feature a multitude of limitations, but the cloud offers ways to transcend them.