Questions tagged [xml]

Short for 'eXtensible Markup Language.' A textual markup language for transferring structured data.

XML (Extensible Markup Language) is a standard for marking up structured data for messaging or storage. It is descended from earlier standards - SGML and HTML

An XML document can be defined by a schema defining its legal structure, and most languages support libraries or functions for manipulating XML documents. Many database management systems also support storage of XML data, either in an opaque blob or a native data type that allows searches and indexing. However, XML fields in relational databases tend to perform poorly.

Some database management systems use XML based structures natively. and others e.g. (some document databases) can store XML documents.

Another commonly used markup notation is JSON (JavaScript Object Notation). A comparison of the two formats can be found here.

378 questions
2
votes
1 answer

How to create a database from an XML file's DTD

I have a fairly large and complex self-describing XML file (It's an Apple Healthkit export; 183 MB). Are there any utilities available to create a database in MySQL or PostgreSQL with the tables and fields described in the XML file's DTD? (If…
iainH
  • 121
  • 3
0
votes
1 answer

Help with reading xml

I am struggling to extract data from an XML file. The file for all intense and purposes looks like this: Hello bye At the moment I am using the Value function. However the data I get returned is…
0
votes
1 answer

SQL and XML insert new Node

I have an SQL Query to make an XML Document. Everything works except one thing: A short insert of my SQL Query at this time is: select OITM.ItemCode, OITM.ItemName, OITM.Price Output in XML:
Chris
  • 1
0
votes
3 answers

Should I use XML for data storage on client side?

I have to create a supplementary program that runs offline on a client machine (normally windows 7 or higher laptop). Of course, I don't want to create a pre-requisite for this program. Since this runs offline, so I can not use a database server…
jitendragarg
  • 161
  • 1
  • 6