Sign In
Not register? Register Now!
Essay Available:
Pages:
1 page/β‰ˆ275 words
Sources:
Check Instructions
Style:
APA
Subject:
Creative Writing
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 4.32
Topic:

Evaluating and Implementing Storage, Indexing, and Views on Database Management

Coursework Instructions:

Start the VM for assignment four. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then select the AdventureWorks2017 database for this assignment.
In this assignment, students will use the AdventureWorks CTP3 database and practice indexing appropriately.
The ability to evaluate and implement various storage structures, index selections, and views is an important aspect of database management.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.
Create a Microsoft Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to provide a screenshot for each.
You notice when running queries that the database is returning results very slowly. Make sure to address the following:
Discuss likely causes for the slow returns.
Propose solutions for speeding up the process.
Explain why implementing the index will speed queries.
Discuss two indexing issues that can negatively affect databases. Provide specific examples in your discussion.
The sales manager has received a customer request that all products be searchable according to color specifications. In this particular case, the customer is seeking red products. Build a view consisting of ProductID, Product, and Color, and query the new view.
The sales manager presented the customer with the view you created in question three. The customer is still unhappy with the product list because many of the items were not available for bulk purchase or were not yet in storage, which resulted in delays. To address the problem, rebuild the view with multiple joins and filter your query to only look up items from the "Finished Goods Storage" located within the “Name” column from the Location table utilizing LocationID (primary key). Bring in the "Quantity" field from the Inventory table. Rerun the query in the view.
Submit the Word document (with screenshots).
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
need resources and APA
Also I just need the first Two (2) questions answered I'll complete 3 and 4
I will supply an example

Coursework Sample Content Preview:

Assignment
Storage, Indexing, and Views
Student Name
University Name
August 29, 2021
You notice when running queries that the database is returning results very slowly. Make sure to address the following:
Part 1:
Discuss likely causes for the slow returns.
There can be many reasons for slow returns. Some of these are the following:
* Poor indexing design
* Missing indexes
* Poorly designed database
* Slow network … etc.
But in our particular case, the most likely reason can be poor indexing or missing indexes. When poor indexing is implemented in the database and the data size is large and consists of multiple tables, finding the particular row through query takes a long time because it has to search from the whole database CITATION Kar19 \l 1033 (Karthiik, 2019).
The other reason that can be the reason for slow return is the slow network. When there is a large database, it means it contains a large number of data. This data can bring up more security layers, even those that are unnecessary, so this can also be the reason for slow return.
Propose solutions for speeding up the process.
There can be many solutions to speed up the process by analyzing the issues. Some of the solutions that can be implemented are as follows;
* Implement indexing
* Do not re-use the same code
* Remove unnecessary nested views to reduce the lags
* Use the “CASE” statement instead of the “UPDATE.”
* Do not use unnecessary join statements CITATION Kar19 \l 1033 (Karthiik, 2019)
It is not necessary that implementing one of the above solutions speeds up the process. To do it efficiently, a query “store analysis” should be run. It will show the resources that are utilized on a primary basis. This query also involves the Database Engine Tuning Tool, optimizing the database for search queries.
After running this query, if indexing is applied, it will show great results regarding the speedy outcome.
Explain why implementing the index will speed queries.
Indexing is basically a method to increase the performance of search queries. When indexing is implemented, the search query under processing doesn’t need to access all database entries. Instead, results are fetched based on the indexes. Since processed query doesn’t need to go through each entry using the indexing method takes less time, and results are fetched faster CITATION Ric21 \l 1033 (Peterson, 2021).
Part 2:
Discuss two indexing issues that can negatively affect databases. Provide specific examples in your discussion.
The first issue is storage since indexing is a data structure. Storing the index va...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Coursework Samples: