what is the difference between SQL Database and XML Database

Hi

xml is Extensible mark up Language


as name suggest it is a markup language
it suport user define tag
you can write you own tag in xml


Sql is Structured Query Language




it suport different type of queries ,functions,store procedure,trigger,indexing etc.

I think sql
is best

for more information please refer following links

http://wiki.answers.com/Q/What_is_the_difference_between_XML_and_SQL_data_storage

http://www.25hoursaday.com/StoringAndQueryingXML.html


http://www.rpbourret.com/xml/XMLAndDatabases.htm

please Mark as Answer if it helps

R D Patel

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

This link may also help you in understanding the difference between xml and sql.
http://www.sql-reports.net/2011/03/xml-vs-sql-which-database-is-the-right-one-for-you.html

Thanks,
Sanjay

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

In XML data storage, the data is stored in a file which represents an XML Schema of the data. To read the data, you have to pull and open the entire file in memory and use technics like xpath to get the data element you want.

In SQL data storage, the data is stored in a database ( usually relational database). To read the data, you simple sent an SQL query to the database. The database management engine analysis the query and get the required data elements you ask for in your query which is finally sent to you as a reply.

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

XML is platform independent database technology
SQL SERVER is Dependent.

Reading/retrieving in XML is fast
Reading/retrieving in sql server is slow as compare to xml

the disadvantage of xml is it is very large file

Thanks n Regards
Bhupendra Tiwari

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator