DataDirect Connect for SQL/XML.DataDirect Connect for SQL/XML, is a standards-based software tool that allows SQL SQL
in full Structured Query Language.
Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. queries to create any desired XML XML
in full Extensible Markup Language.
Markup language developed to be a simplified and more structural version of SGML. It incorporates features of HTML (e.g., hypertext linking), but is designed to overcome some of HTML's limitations. structure using the SQL/XML extensions that are part of SQL 2003.
Many applications exchange data as XML, but most corporate data is stored in traditional relational databases. Because XML and SQL represent information in very different ways, developers often spend significant effort converting information between the two. DataDirect Connect for SQL//XML, developed to address this problem, allows Java applications to build XML documents directly as the result of SQL queries, or to extract information from XML documents and update relational data. Developers are freed from writing code to bridge XML hierarchies and sets of relational tables, or learning the complex and ad-hoc XML database A database that stores XML documents. There are two types. The first is the "XML-enabled database," which is a relational or object-oriented database that has been extended to hold XML data. extensions to relational databases.
DataDirect Connect for SQL/XML provides a standards-based approach:
It is compliant with SQL/XML, the XML extensions in the proposed SQL 2003 standard that include the XML data type, and provides access to SQL/XML results using standard JDBC (Java DataBase Connectivity) A programming interface that lets Java applications access a database via the SQL language. Since Java interpreters (Java Virtual Machines) are available for all major client platforms, this allows a platform-independent database API (Application Programming Interface) A language and message format used by an application program to communicate with the operating system or some other control program such as a database management system (DBMS) or communications protocol. calls. Using DataDirect Connect for SQL/XML, developers can write applications that work across any major database (including older versions) without recompilation Re`com`pi`la´tion
n. 1. A new compilation. .
The solution includes a graphical query builder for creating, changing, and testing SQL/XML queries. This lets users display SQL/XML statements in a graphical tree structure or in a text view that shows the complete text of the statements.
SQL/XML is a small extension to SQL that allows a SQL query to create any desired XML structure. For a SQL programmer it requires little new learning, and it allows existing databases to be used as is, with full support for the SQL language. www.datadirect.com