6.9. Outdated Uses for VIEWs
Over the years, VIEWs have been used for other purposes that made sense at the time, but have been rendered obsolete with the advent of new DBMS functionality. You no longer need to program this way, but you might run into it in some old schémas. Each SQL product’s programmers tended to use some of these tricks more than other products, so finding them is more of a local dialect problem than an exact science.
Two of these VIEW usages are to simulate domain support and to implement queries that access both summary and detail information in a single row. Let me elaborate on both and tell you why these usages are outdated.
6.9.1. Domain Support
It is a sad fact of life that most relational database management systems ...
Get Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
