Health Data Clinic - Book 12: Views: Reusable Reports & Security

Write the query once, then reuse it by name. That is what a view does, and this book covers both reasons to use one. On the reuse side you learn CREATE VIEW, how to query a view exactly as you would a table, how a view shortens a long report down to a single line, and why the data it returns is always current rather than a saved copy. A frank chapter sets out what a view is and, just as usefully, what it is not. On the protection side a view becomes a window: you build column-level security so staff see only the columns their role needs, create a view per role, and write de-identification views that strip identifying detail out of a result set. Simple and complex views are compared, dropping and rebuilding is covered for when a definition has to change, and the book closes with everyday uses and naming practices worth adopting before your view list grows past a handful.

Twenty-five A4 pages, in full color. Written in short sentences and plain English, for readers whose first language is not English and clearer for everyone else because of it.

Every query in this book was run against a live database before the page was printed, so the result you read is the result you get. Instant PDF download. By M.R. Sterling.