Geek Answers Handbook

XML and its use in Databases

What is XML and how is it used in databases? If it looks like homework, it is.

+5
source share
6 answers

Databases are often used to store XML blocks for applications that do not want to serialize them into a real database schema. But generally speaking, XML is not used in databases.

This implies that databases store data, where XML does pass it agnostically.

(Simplified) It usually happens that application A converts data from database A to an XML stream that is passed to application B. Then application B converts XML into a series of SQL statements that create records in database B.

, .

+2

Xml (Extensible Markup Language) - , .

- - xml, , . xml (, ).

xml , xml:

  • RSS, , .
  • XHTML, HTML
  • SOAP (Simple Object Access Protocol), , -

, xml ( ), xml , (, ).

, xml , , xml xml. "Blobs" xml , , xml.

+1

Derek, Sane Kragen , .

XML ( , ), XML , .

XML (XSD), XML.

, XML SQL, XML , , . , -, , CSV.

, XML, , ( XSD) , , , XML- (XSD).

, , , XML , , , " "?

SQL- ? , , " " ? , , XML ?

, , , " ".

XQUERY, , "" XML . XML Oracle SQL Server , Microsoft Oracle , XML.

+1

, .

, XML .

. . , ( , CTE SQL-, , ).

, - n , , , , XML. , , , .

, , XML, T-SQL / ..

Re: XML -

0

, " ", , , Oracle, SQL Server ..

, , , XML . . , , , XML / . XML , .

0

More articles:


All Articles