Here we report a model data mart developed upon a warehousing system focusing on oncology data to explore optimized system architecture to support enhanced data integration and application capacity.