XQuery for the SQL programmer – Why XQuery?

XQuery for the SQL programmer – Why XQuery?

October 30, 2008 0 Comments

Over the last month, wearing our SQL-glasses we mastered the basics of XQuery. But wait... what we’ve learned up to now in the XQuery for the SQL programmer series is about “do in XQuery what you can do in SQL”. Doesn’t sound like a compelling reason to use XQuery

To be clear, I’m not advocating to replace SQL with XQuery. For a lot of good reasons SQL is there today, and it will be there tomorrow. Admitting, that’s also a good thing for DataDirect, as a fair amount of our business is based on ODBC, JDBC and ADO.NET.

Why do I want to use XQuery against relational databases? Minollo answered the question before. It’s all about the data integration promise offered by products like DataDirect’s Data Integration Suite.

If you frequent xml-connection.com, you know about the use cases

  • Publishing relational data as XML
  • Shredding XML into an RDBMS
  • Aggregating your LDAP repository with relational data
  • Developing WebServices
  • Interfacing through EDI messages
  • Handling proprietary formats
  • Bulk loading of XML
  • Joining XML with your relational database
  • Querying WebServices
  • Reading office documents to update your database
  • Producing EDI messages

 

Are you suffering data integration?
Tech Tags:

Marc Van Cappellen

View all posts from Marc Van Cappellen on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.

Comments
Comments are disabled in preview mode.
Topics
 
 
Latest Stories in
Your Inbox
Subscribe
More From Progress
d12fcc0bdb669b804e7f71198c9619a7
5 Questions Automakers Should Ask to Improve Asset Uptime
Download Whitepaper
 
SF_MQ_WCM
2018 Gartner Magic Quadrant Web Content Management (WCM)
Download Whitepaper
 
What-Serverless-Means-For-Enterprice-Apps-Kinvey
What Serverless Means for Enterprise Apps
Watch Webinar