Non-key column
3NF essentially is a normal form that drastically helps reduce the amount of duplicated columns in tables. When queries are performed, less data is processed because there it is not being duplicated across multiple tables; this makes performance faster, but requires detailed planning to implement correctly.
SQL View
SQL view is a feature in SQL that allows visualization of data in a unique way. Most of the time when performing queries users are combining different data from different tables to get a better picture of the stored data. SQL view like traditional tables, also allows to populate data, however, with a view, the user is able to, in a sense, "save" commonly used columns for future refers. Essentially, views are similar in that they help visualize data, but they differ in that that it's data that can be referenced in the same way, multiple times in the future.
No comments:
Post a Comment