Explains views in physical design
Virtual tables that simplify queries, restrict access or present data without storing it again.
Can AI do this?
Not tested yet
No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.
What it looks like in practice
Expected result: Virtual tables that simplify queries, restrict access or present data without storing it again
How it is assessed: Chooses where a view replaces a stored table or denormalisation in a sample design
All knobits of Data modelling.
Source: DAMA-DMBOK2 chapter 5, section 1.3.5.5, 2.2.1.3