Printer Friendly
The Free Library
22,741,889 articles and books

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.
COPYRIGHT 2003 A.P. Publications Ltd.
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2003, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion




Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Tools
Publication:Database and Network Journal
Date:Oct 1, 2003
Previous Article:MKS Toolkit V 8.6.
Next Article:Top ten viruses and hoaxes reported to Sophos in September 2003.

Related Articles
Connect ODBC 4.0.
DataDirect jXTransformer. (Tools).
DataDirect Connect for JDBC 3.1. (Database Products).
DataDirect SequeLink 5.3. (Data News and Products).
Cognos licenses database drivers from DataDirect Technologies.
DataDirect Connect for .NET. (Database and Network News & Products).
DataDirect Connect for JDBC 3.3.
XML hindered by lack of data connectivity standards.

Terms of use | Copyright © 2014 Farlex, Inc. | Feedback | For webmasters