Home:XQuery Engine:XML Tools:Stylus Studio and DataDirect XQuery

Stylus Studio® 2007 XML Enterprise Suite for DataDirect XQuery®

Stylus Studio is a full-featured XML IDE that is completely integrated with DataDirect XQuery®.

You can use Stylus Studio to

• Easily connect to any relational database
  
  
• Use relational database tables as XML data sources in your XQuery
  
  
• Automatically create collection() functions and other XQuery expressions using simple drag-and-drop
  
  
• Preview XQuery results
  
  
• Debug XQuery code created in Stylus Studio
• Automatically generate Java classes that run a query using DataDirect XQuery®'s implementation of the XQuery API for Java (XQJ)

The following image shows a relational table being added to an XQuery — once the connection to a relational database server is made through the Stylus Studio File Explorer window, all of its databases and those databases' tables become available to Stylus Studio. To specify one or more tables as a relational data source in an XQuery document, just drag it from the File Explorer window and drop it on the XQuery Editor's data source panel.

Creating XQuery expressions in Stylus Studio is easy — just drag and drop the relational data source on the XQuery Source tab, ans Stylus Studio displays a short-cut menu that lets you select from collection() functions and, as shown in the following illustration, FLWOR expressions (for each, let, where, order by, and return).

The Mapper tab displays a graphical representation of the FLWOR expression created previously. Stylus Studio synchronizes graphical and text views of your XQuery code, and lets you edit in any view you choose. You can preview your XQuery code with the click of a button — Stylus Studio displays the results in the Preview window, as shown here.

Stylus Studio provides integrated tools that let you debug and tune the performance of your XQuery code. Once you are satisfied your that your query returns the results you expect, you can use Stylus Studio to automatically generate a simple Java class that exeucutes the query using DataDirect XQuery®.