1. Reply to discussion (150 words)
1. Summarize the purpose of views and indexes. Why are indexes and views important to an organization?
Views are a type of virtual table that is stored in a database by a specific name as an SQL statement. Views are considered to by dynamic, which means that if any information is changed it is updated automatically and can be view almost instantly.
(Begg, 2015) Views have several functions that allow users to determine who has access ensuring that only appropriate information can be seen. Data can be set up to provide ease of access, restrict certain permissions for a group of users so baseline data cannot be altered, and generate reports from several tables of data. (SQL-Using Views , 2017)
Views are important to organizations because they allow the administrator to ensure the security of the information stored in a database.
This prevents unauthorized access to certain portions while allowing access to others. It also allows multiple users to view and modify the information they have access to without crashing the program.
An index is a group of files or entries stored in the tables and rows of a database. (Christensson, 2017). Indexes enable a user to search, sort, and access information quickly, preventing the need to read every portion to retrieve the necessary data.
Indexes are important to an organization because they basically save personnel time. This is especially helpful when large databases have been created and only certain records need to be retrieved and viewed for accuracy or updates. Techterms.com recommends that the entries be saved in plain text and the use keywords to aid in quicker searches. (Christensson, 2017)
Works Cited
Begg, T. C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management . Pearson.
Christensson, P. (2017). Index.
SQL-Using Views . (2017).
2. Reply to discussion (150 words)
2. A view is simply any SELECT query that has been given a name and saved in the database. For this reason, a view is sometimes called a named query or a stored query.
The important views have on and in an organizations is due to the fact that they make it possible to control the access to data for different types of users, this is truly ideal for large multi-user systems. When using views, once stored, the view can be used again and again, rather than re-writing the same query many times this maxims time efficiency and increases productivity.
Addressing indexes, indexes are important to an organization since they have the ability to organize the tables within a database. An index is a data structure that the database uses to find records within a table more quickly. Indexes are built on one or more columns of a table; each index maintains a list of values within that field that are sorted in ascending or descending order (jewett.com).
The design and implementation of indexes are important to the databases do to the fact that all information housed within the database must have a unique location as well as set values within the indexed columns that must be unique and have a primary key.
This allows database to run with optimal efficiency, if not; the database will not perform as well or as expected. However, when build/ set up correctly, indexes allows for information to be queried and selected from a database in a timely manner that it most beneficial to the operations of any enterprise enabling organizations to thrive.
Citation:
Unknown, SQL technique: views and indexes,
3. Respond to question (150 words)
Besides views, there is a another object, Saved Procedure. Why does SQL have both objects?