Data warehouse design and implementation for commerce and government optimized for large data and parallel database environments