Integrated optimizing data-warehouse architect holistic e-services