Dissertation: Design and Optimization of Scientific Workflows