Discuss how XML can be transferred into a database.

What will be an ideal response?


There are four general approaches to storing an XML document in a relational database:
? store the XML as the value of some attribute within a tuple;
? store the XML in a shredded form across a number of attributes and relations;
? store the XML in a schema independent form;
? store the XML in a parsed form; that is, convert the XML to internal format, such as an
Infoset or PSVI representation, and store this representation.
These approaches are not necessarily mutually exclusive. For example, it would be possible to
store some of the shredded XML as attributes in one relation while leaving some nodes intact
and stored as the value of some attribute in either the same or separate relation.

Computer Science & Information Technology

You might also like to view...

Web queries cannot accurately import data from Web sites that are password protected

Indicate whether the statement is true or false

Computer Science & Information Technology

Which of the following aspects of cloud computing allows a service provider to limit a customer’s use of a particular resource based on a service agreement between the provider and the customer?

A. Rapid elasticity B. On-demand C. Metered service D. Measured service

Computer Science & Information Technology

Which image type compresses in a lossy format?

a. GIF b. PNG c. JPEG d. SVC

Computer Science & Information Technology

A coworker asks your opinion about how to minimize ActiveX attacks while she browses the Internet using Internet Explorer. The coworker recalls there is a setting in the Internet Options dialog box to prompt the user before downloading ActiveX controls, but can’t remember which tab to use.   Which of the following tabs will you suggest to the coworker?

A. Security tab B. Privacy tab C. General tab D. Programs tab

Computer Science & Information Technology