MySQL Database Support
Superior Data Integration and Conversion
With the Data Integration Suite, MySQL Enterprise 5.0.x users treat data in MySQL tables and views as XML, making querying, publishing, reporting – and even updating – relational data a snap.
The Data Integration Suite runs on any Java platform, and is easily embeddable into almost any Java program. Users of the MySQL relational database take advantage of high-performance, scalable, reliable XQuery processing provided by the Data Integration Suite.
- MySQL users run Data Integration Suite XQuery against data stored in their Enterprise version
- Data Integration Suite XQuery helps aggregate MySQL data with information available in native XML documents and/or in EDI messages
Thanks to Data Integration Suite, MySQL users have access to a standard-based, easy, and high-performance way to access data stored in their databases as XML for the first time.
MySQL – Data Integration Suite Benefits
- High Performance – Special optimization and mediation provides the best possible Data Integration Suite performance, including the transparent conversion of 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 to process large XML documents. Portions of the XQuery dealing with relational data are issued to the relational database as SQL, allowing the application to take advantage of database scalability.
- Emendable – The Data Integration Suite does not require any other product or application server, and it plugs into any architecture.
- Data Source Independent – The Data Integration Suite integrates query results from XML, relational data, SOAP messages, EDI, legacy, or a combination of data sources.
- Web Services Integration – The Data Integration Suite consumes or creates Web Services from an XQuery.
- RDBMS Updating – The Data Integration Suite provides efficient XML shredding and transparent relational updates for XQuery applications that need to insert, update, or delete data in relational tables.
- Standards Based – Because it is based on the XQuery standard, the Data Integration Suite ensures stability for developers through standards-based XQuery and XQJ implementations. Data Integration Suite is tested with XQTS (W3C XQuery Test Suite).
- Plan Explain – The Data Integration Suite can generate a graphical XQuery execution plan that provides developers with information for optimal query tuning.
- Connection Pooling – The Data Integration Suite integrates with the application server's JDBC pool manager to take advantage of familiar connection pooling from other JDBC applications.
