XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Michael HightSubject: XQuery and Relational Data mapping----newbie questions
Author: Michael Hight
Date: 26 Apr 2005 11:14 AM

I am newbie to XQuery and Stylus Studio and would like to include this in our current prototype but have a few reservations.

Q: Does XQuery support the constraints on the tables while mapping relational data to xml? I mean to say that we have a complicated schema, it is relational, but I am wondering if this ide with xquery is going to be able to keep all the primary foriegn key relationships when extracting the data to xml??

Q: How would I use a look up to get the value out of the database and look up what that value means in the look up table and then insert the appropriate value in the xml?

Thanks so much
Best Regards,

Ivan PedruzziSubject: XQuery and Relational Data mapping----newbie questions
Author: Ivan Pedruzzi
Date: 29 Apr 2005 11:44 PM
Hi Michael

Q1) When running XQuery against relation sources what you get as output is an XML view of the same data. If you need to enforce some data constraints on the query result you will need to design an XML schema to validate your documents.

Q2) In XQuery you can access multiple documents/views; perform a lookup is easy as write an XPath predicate.

Hope this helps

Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.