数据库视图的优势是什么 [英] what is advantage of view in database

问题描述

数据库视图的优点是什么

what is advantage of view in database

推荐答案

在此处清楚地解释了这点:
http://en.wikipedia.org/wiki/View_%28database%29 [ ^ ].

—SA

[还请注意有关数据库规范化的文章: http://en.wikipedia.org/wiki/Database_normalization [^ ]

如果数据库设计良好，则表将被规范化(由于性能问题而存在例外).通过视图，您可以拥有规范化的数据库，并且能够以更易于阅读的形式查看数据. —克利福德·纳尔逊]

P.S.:
感谢Clifford所做的有趣的添加，以及有关数据库规范化和视图使用相关方面的有用链接.

This is clearly explained here:
http://en.wikipedia.org/wiki/View_%28database%29[^].

—SA

[Also note the article for Database normalization: http://en.wikipedia.org/wiki/Database_normalization[^]

If a database is well designed, the tables will be normalized (there are exceptions due to performance issues). Views let you have a normalized database, and yet be able to see the data in a much easier to read form. — Clifford Nelson]

P.S.:
Thanks to Clifford for an interesting addition and a useful link on the database normalization and related aspect of the use of the views.

这篇关于数据库视图的优势是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！