[New Article] Using Regex and The XML Classes To Parse Your Log Files

My blog has moved.
You can view this post at the following address:
http://www.osherove.com/blog/2003/6/10/new-article-using-regex-and-the-xml-classes-to-parse-your-lo.html
Published Tuesday, June 10, 2003 4:50 AM by RoyOsherove
Filed under: ,

Comments

Monday, June 09, 2003 7:33 PM by Darren Neimke

# re: [New Article] Using Regex and The XML Classes To Parse Your Log Files

Nice one Roy :-) Bookmarked!
Tuesday, June 10, 2003 12:14 AM by kpako@yahoo.com (Dare Obasanjo)

# Dare Obasanjo

Roy,
I keep wondering why developers choose to use the DataSet which is a relational data structure which kind off understands XML for their XML processing needs instead of using the XmlDocument which is actually an XML data structure. I'd never think of using the DataSet if I wanted to load and store XML but it seems a lot of developers such as yourself believe this is the way to go.
Tuesday, June 10, 2003 12:29 AM by Roy Osherove

# re: [New Article] Using Regex and The XML Classes To Parse Your Log Files

Dare: The reason I use the Dataset, is to be able to give the user an "SQL like" way of searching, instead of using XPath queris syntax. SQL is a bit more natural. That's the only reason, though. I agree, XMLDocument is the way to go when you want to just load up and search XML stuff..
Tuesday, July 22, 2003 4:00 AM by Christian Romney

# re: [New Article] Using Regex and The XML Classes To Parse Your Log Files

I like the combining datasets and the XmlDataDocument class for flexibility. This lets you use compact T-SQL in the stored procs for pulling data out of the database instead of writing 500+ line convoluted FOR XML EXPLICIT queries. You can then use the XmlDataDocument class to get an XML representation for XSLT transformations quite easily. Any performance hit could be easily justified by the increase in maintainability, although the XML processing in SQL is unlikely to perform as well as the XMLDataDocument when all is said and done.