Dynamic Query Optimization under Access Limitations and Dependencies