XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XQuery and Relational Data mapping----newbie questions
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Michael HightSubject: XQuery and Relational Data mapping----newbie questions
Author: Michael Hight
Date: 26 Apr 2005 11:14 AM
Hi

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,
Michael
Posttop
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
Ivan
   
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!  
go

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.