Data Integration Suite – MySQL Database Support

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 can now take advantage of high-performance, scalable, reliable XQuery processing that is provided by the Data Integration Suite.

  • MySQL users can 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.

MySQL Examples XQuery Applications

The following examples show how the Data Integration Suite works with data in a MySQL relational database. Consider the following scenario: The company receives book orders from a variety of partner companies; when an order is received, an XML document consistent with a "canonical" internal XML Schema (structure) must be created so that it can be sent to the warehouse to fulfill the order.

Orders are usually submitted in a proprietary XML format; but in some cases orders are not even in XML format. Nor is the information contained in these orders a subset of what the “canonical” internal format requires. Once fulfilled, orders also need to be archived in the company’s main database for archiving/reporting purposes. The company relies on a MySQL database to store information about all the books in inventory, and to keep track of the orders.

  1. Process XML using MySQL – Learn how to use DataDirect XQuery to merge data contained inside XML documents and a live MySQL database table, and how to format a resulting XML document in a way that is consistent with a specific XML Schema.
  2. Process EDI as XML using MySQL – This example covers integrating an EANCOM message, a common EDI data format with the relational data contained inside a MySQL database table, then formatting the results in a XML format, all using Data Integration Suite.
  3. Archive XML in MySQL – The final example shows how to process an incoming XML or EDI message with data contained in a MySQL database, and how to save the resulting data back into the MySQL database table using Data Integration Suite’s advanced support for database inserts and updates.

Check out the Data Integration Suite Performance: Generating SQL or download a free trial of the Data Integration Suite today!