I submit that maintenance doesn’t have anything to do with it either.
Contexts have a purpose. Aliases have a purpose. In every case I can think of, which one you select is based on the problem you are trying to solve, not really what you think will be the best maintenance option. If you need a context, then you need a context.
The only real alternative to creating contexts is to create more than one universe. That’s essentially what a context is, really, by identifying a set of joins that work together you are essentially subdividing a single universe into smaller sub-universes of tables that work together. You could separate them into different universes.
Aliases are not substitutes for contexts, and vice versa. Once you have identified the problem, the solution choice is made for you.
Dave Rathbun (BOB member since 2002-06-06)