what is the difference between SQL Database and XML Database

Posted by Gow.Net under Sql Server on 3/14/2012 | Points: 10 | Views : 19479 | Status : [Member] | Replies : 4
what is the difference between SQL Database and XML Database which one is best?

gowthaman8870226416


Responses

Posted by: Patel28rajendra on: 3/14/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Sksamantaray on: 3/14/2012 [Member] Silver | Points: 25

Up
0
Down
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

Posted by: Muhsinathk on: 6/26/2012 [Member] Bronze | Points: 25

Up
0
Down
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

Posted by: Bhupentiwari on: 6/26/2012 [Member] Starter | Points: 25

Up
0
Down
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

Login to post response