Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What is XML?


What is XML?

Author
Message
Stephen Hirsch
Stephen Hirsch
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 161
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/shirsch/whatisxml.asp
pete callaghan
pete callaghan
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 82

At last sanity!. XML is just another technical solution in search of a problem.

Many years ago a user said "We have a problem sending our orders to xyz co. ltd - their system doesnt understand our systems data format". A passing techy thought "I could fix that!" and suggested xml. Therby missing the point completely.

The real issue when communicating data twixt diferent systems is not that system B does not know which field holds system A's stock code, its that a stock code on system A is "00123" but on system B its "WIDGET01". XML doesnt begin to address this.

Good data storage mediums are simple, efficient and transparent to applications. XML is complex, massively wasteful of storage and computationally an open ended black hole. It is fundamentally inappropriate as a data storage medium, and a poor choice for data transfer.

Cage rattled ?


Brett Anthony
Brett Anthony
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 42

Yes the hype is crazy, I thought it would have died down by now but its still going strong!

As my Dad once said to me "Horse's for coarse's".

A great saying, and it simply means this, XML isnt the only way of transporting data, it's just ONE of the many ways you can transport data! If size is a problem, then use something else. No one has a gun to anyone's head telling them they must use XML, use it when it fits best. For some applications it works great, as a data store, Im sure there are other better formats. There was some huge debate over SQL2005 handling XML data types. I couldnt see the fuss, if it doesnt work for you then dont use it, and if you want to use it, its always there as an OPTION! Dont limit yourself, you only cage yourself in. Ide prefer to have a toolbox full of tools for every occasion, I dont have to use them all, buts its always good to have it just in case?

Also dont forget that DTDs are being phased out over the "Schema", basically XML describing itsself.

Good article dude, keep it up.


SuperDBA-207096
SuperDBA-207096
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1591 Visits: 711

Stephen,

Nice article! Finally a simple explanation of XML!

Mark


Jeff Gray
Jeff Gray
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1031 Visits: 389

Every time you use XML, God kills a kitten.


YSLGuru
YSLGuru
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1172 Visits: 1665

Thank you sooo much for writing an article that is an honest look at XML and not one that’s nothing but another praise of XML and how XML is the second coming in the programming world. I’m so fed up with hearing how XML will solve every known computer related problem. Personally I have no issue with Microsoft integrating XML into dotNET or even into SQL Server 2005 but I do have issue with them selling XML as the end all in development and making it sound like as if everything needs to be converted to XML as soon as possible.

XML is just another tool in a developer’s toolbox and anyone who sees it as anything else is fooling themselves. I have seen many am articles and related pieces on the net and in print talking about how developers who want to stay in demand need to jump on the XML bandwagon ASAP, leaving everything else behind. IN a few years, after a sizeable number of companies and users have tried to ‘do it all in XML’ have been thru the process and realized the folly of substituting everything else for XML, things will swing back to normal like they are now and XML will be viewed as no more then what it is, another method, option or tool for working with software.

The smart developer will learn how and when not to use XML as well as how to use it.

Ed



Kindest Regards,

Just say No to Facebook!
Stewart Joslyn
Stewart Joslyn
Old Hand
Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)

Group: General Forum Members
Points: 371 Visits: 188
Note that even .NET uses binary internally - not everything is XML.

I agree wholeheartedly with the article. The systems at each end still need to know the schema so its no different to a binary struct - just bigger. The only advantage that I can see for XML - and it can be a big one - is that its human-readable which makes debugging and investigation a lot easier. ... but then you can write a simple decoder for any other structure.



JJ B
JJ B
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 2850
I appreciate this article for it's objective voice. I've long felt the same way, but it feels like nice vindication when someone else posts similar thoughts.

For most of my data transfers, I still feel that a the good-old comma delimited text file is peachy-keen. However, if I have to transfer long narratives/text fields, it seems like XML is the way to go. What do other programmers use when you have to transfer large text fields?
Timothy Blank
Timothy Blank
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 2
THANK YOU THANK YOU THANK YOU especially for pointing out that XML is heirarchical -- I've been fighting very frustrating battles with people who believe in the next silver bullet but have no appreciation for data modeling. The hard fact that people need to get is that data modeling has nothing to do with any particular technology and and everything to do with understanding the business.
Steve Lackey
Steve Lackey
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
I'm not sure that XML was intended to be a language to fully encode reality between the angle brackets. Nor is every use case possible to capture. But for the really dull ones, like exchanging business documents, the world will not miss the hours p-ed away manually coding flat ASCII mappings between EDI, Some Guy's Clever Markup Scheme, and your RDBMS.

What it offers is a lot more reuse. It's not very good as a primary data store, but it makes the transfer of complex data easier, and using standardized parsers for manipulating it are easier than writing your own. It's just one tool among many, though a useful one.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search