Content deleted Content added
Fix broken link Tags: Mobile edit Mobile web edit |
No edit summary |
||
Line 9:
* Views can hide the complexity of data. For example, a view could appear as Sales2000 or Sales2001, transparently [[Partition (database)|partitioning]] the actual underlying table.
* Views take very little space to store; the database contains only the definition of a view, not a copy of all the data that it presents.
* Structures data in a way that classes of users find
Just as a [[function (computing)|function]] (in programming) can provide [[Abstraction (computer science)|abstraction]], so can a database view. In another parallel with functions, database users can manipulate nested views, thus one view can aggregate data from other views. Without the use of views, the [[Database normalization|normalization]] of databases above [[second normal form]] would become much more difficult. Views can make it easier to create lossless join decomposition.
| |||