XQuery Engine

DataDirect XQuery® Fact Sheet

DataDirect XQuery® is an XQuery processor that enables developers to access and query XML, relational data, SOAP messages, EDI, legacy, or a combination of data sources, and, in addition, provides full update support for relational data. DataDirect XQuery supports the XQuery for Java™ (XQJ) API, and is easily embeddable into any Java program — it does not require any other product or application server, and has no server of its own. It is recommended for developers who need to combine and efficiently process XML, relational, and legacy data formats in application scenarios such as data integration, XML-based data exchange, XML-driven web sites, and XML publishing. DataDirect XQuery vastly simplifies and enhances the performance of combining and processing different types of data (relational, XML, legacy, EDI, and more) in heterogeneous environments and thus enables developers to build and deploy high-performance applications quickly and efficiently.

Query XML, relational, SOAP messages, EDI, or a combination of data sources

Today's web services, web sites, data integration, and publishing applications need data from many sources including XML, relational, and legacy formats. DataDirect XQuery uses a single language – XQuery, to process XML, relational data, or a combination of data sources.

Using DataDirect XQuery significantly simplifies application development by reducing the amount of code developers write and maintain to use XML, relational, and legacy data together. The result – less development effort and developers completing projects quickly and efficiently.

Full update support for relational data

DataDirect XQuery allows you to update relational data from within XQuery. This is useful for all applications that need to insert, update, or delete data in relational tables. The addition of update functionality makes DataDirect XQuery very well-suited for ETL application scenarios, where it provides efficient XML shredding and transparent relational updates.

Special optimizations for accessing relational data and XML

DataDirect XQuery provides special query optimization and mediation for optimal performance when accessing relational data. The product is designed to move the minimum amount of data out of the database and leverages indexes and tuning defined on the database server, thus providing the best performance possible.

DataDirect XQuery utilizes optimization techniques including document projection and document streaming to provide the performance, scalability and reliability required to process very large XML files. This significantly reduces development efforts and processing time by eliminating intermediate processing of XML data files.

Easily embeddable XQuery component for all major databases

DataDirect XQuery is easily embeddable into applications; it does not require any other product or application server, has no server of its own, and is not tied to a specific vendor database or database version.

Application developers can write one easy-to-maintain application regardless of the databases and versions they are using – Oracle, DB2, MySQL, Microsoft SQL Server, or Sybase. Their applications are insulated from frequent changes to the database and database vendor tools.

Features	Benefits
High Performance	Special optimization and mediation provides the best possible XQuery performance including transparently converting relevant parts of the XQuery to efficient SQL statements for execution in relational databases.
Scalable	XML streaming and document projection drastically reduce the amount of memory required when processing large XML documents. Portions of the XQuery dealing with relational data are issued to the relational database as SQL to take advantage of database scalability.
Embeddable	Does not require any other product or application server and plugs into any architecture.
Data Source Independent	Integrates query results from XML, relational data, SOAP messages, EDI, legacy, or a combination of data sources
Web Services Integration	Easily consume or create Web Services from an XQuery.
RDBMS Updates	Efficient XML shredding and transparent relational updates for XQuery applications that need to insert, update, or delete data in relational tables.
Standards-based	Stability for developers through standards-based XQuery and XQJ implementations, tested with XQTS.
Plan Explain	Generates a graphical XQuery execution plan to provide information for optimal query tuning.
Connection Pooling	Integrates with the application server’s JDBC pool manager to take advantage of familiar connection pooling from other JDBC applications.

Data Source Support

Oracle 9i, 10g, 11g, Microsoft SQL Server 2000, 2005 Sybase ASE 12.5.x, MySQL (Enterprise Version), IBM DB2 UDB v8.x, v9.1 for Windows, Unix, Linux, and z/OS and DB2 UDB v5R2, v5R3, v5R4 for iSeries (AS/400), Informix 9.4 & 10, PostgreSQL 8.1 & 8.2

Other Relational Databases XML Sources Web Services EDI Flat Files Supports any Java-enabled platform that supports J2SE 1.4.x or higher.

XML Tools for DataDirect XQuery Development

Stylus Studio®, an award-winning XML IDE with advanced XQuery development support including integration with DataDirect XQuery. Stylus Studio is available for Windows 2000 SP2, Windows XP and Windows Vista. Visit the Stylus Studio Web site for more information www.stylusstudio.com.
DataDirect XQuery Eclipse-based editor, an Eclipse plug-in that exposes a specialized XQuery editor to allow users to develop and test XQueries using DataDirect XQuery. The editor has features similar to those found in Stylus Studio’s XQuery editor including:
- Syntax coloring
- Auto completion of functions (including DataDirect XQuery specific ones)
- Visual management of database connections
- Preview of XQuery result, including the possibility to bind external variables and static context input
- Scalable rendering of result
- Support for plan explain rendering

The plug-in is available via the Eclipse download/update mechanism and is free to licensed users of DataDirect XQuery.

Try DataDirect XQuery® Free!

Put the power, scalability, and performance of DataDirect XQuery® to work for you today! Our free trial lets you see for yourself how easy it is to build data integration applications that access relational, EDI, and other file formats as XML!

Download DataDirect XQuery® today!

Back to School with DataDirect XQuery®

Getting your mind around the possibilities of a data integration technology as promising as XQuery can be difficult, but our XML developers Webinars will help you understand the power and versatility of XQuery, and our favorite XQuery processor, DataDirect XQuery®.

From information about how to leverage relational data to real-world use cases, our Webinars will help you see why DataDirect XQuery® is the best choice for today's tough data integration and aggregation challenges.

DataDirect XQuery FAQ

This informative DataDirect XQuery® FAQ answers frequently-asked questions about DataDirect XQuery®, including questions about performance, scalability, use-cases, resources, and more.

If you're more of a hands-on learner, then download a free copy and start exploring DataDirect XQuery® today!

Feeds

Multimedia

Newsletter