Sign In
Not register? Register Now!
Essay Available:
Pages:
2 pages/≈550 words
Sources:
2 Sources
Style:
APA
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 12.96
Topic:

XML Concepts and Use

Coursework Instructions:

Assessment Description
The purpose of this assignment is to explain XML concepts and the appropriate use of XML.
The IT department is rolling out a new product application for the marketing department and has requested your expertise in addressing some questions related to an upcoming project. IT is exploring inputting data from SQL Server through XML
For this assignment, refer to the "SYM-408 Import Test" document to complete the assignment.
Part 1:
For this part, start the VM, and inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then right-click on the AdventureWorks2017 database and select New Query.
Execute the following steps:
1. Select * from Person.Person Where FirstName = 'John' For XML path.
2. Click on the XML link in the results area to open the XML view.
3. Right-click on the SSMS query tab above the view, and save the file as "xmlTest.xml."
4. Construct a SQL transaction to import the "xmlTest.xml" results file back into SQL Server. Hint: Use the Commands OPENROWSET and OPENXML and the two stored procedures "sp_xml_preparedocument" and "sp_xml_removedocument."
4. Copy the SQL transaction code from SMSS. You will paste this code at the bottom of the IT project proposal document that you create in Part 2.
Part 2:
Address the questions below in a 550-word document so they can be included in the IT project proposal:
1. Explain what makes an eXtensible markup language (XML) document different from a regular text file.
2. Discuss factors that should be considered when deciding whether it is worth indexing an XML column in a SQL Server database.
3. Discuss the pros and cons of storing XML data in a SQL Server database rather than storing the XML as documents in a file system.
Submit the Microsoft Word document containing the SQL transaction code from SMSS and the answers to the questions as directed by your instructor.

Coursework Sample Content Preview:

Xml Basics
Student’s Name:
Institutional Affiliation:
Course Name and Number:
Instructor’s Name:
Due:
Xml Basics
Part 1
Fig. 1. Image showing the results of querying table person for records containing John as the first name.
Fig. 2. Image showing the results of an SQL transaction to import a file back to SQL. The image shows an error because the XML file does not have the closing and opening “root” tags.
Fig. 3. An image showing a successful query after adding the required “root” tags.
Fig. 4. An image showing the SQL transaction used to import the xml file.
Part 2
Question 1
A major difference between an XML document and a regular text file is that an XML document is self-describing. In this regard, an XML file contains the structure of data as well as information about the data (Carter, 2018). Such a quality enables a software application such as SQL to parse through the data and understand its contents. In contrast, a text file can contain data but they are no well-structured, which makes it difficult for a program to parse. According to Carter (2018), the structure of XML documents makes them predictable for a program to be able to read the contents. For instance, when writing XML files, every opening tag must have an accompanying closing tag and all the contents, must be enclosed in a single root element. A text file does not have a similar structure, which creates challenges, when trying to parse it. Finally, an XML file can include other documents such as a stylesheet, which helps to further enhance it structure. A text file cannot accommodate additional files, which creates limits in terms of data and text presentation.
Question 2
There are several factors that can be used to determine whether an XML column should be indexed in a SQL Server database such as the available resources, query performance, data modification and the data size (Strate, Fritchey, & Landrum, 2015). Indexing takes additional storage, which means that it is important to consider the a...
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: