XSQL
| XSQL - Combining XML and SQL | |
|---|---|
| File extension : | no |
| Type: | Markup language , database language |
| Extended by: | XML , SQL |
| Standard (s) : | xsql.sourceforge.net |
XSQL combines the possibilities of a universal data description offered by XML with the possibilities of SQL in order to be able to further process queries of relational databases and their results independently of the respective programming language and the database system used.
On the one hand, the SourceForge project of the same name deals with the implementation of XSQL ; on the other hand, the Oracle Application Server provides a number of system programs to be able to process XML with PL / SQL or Java .
xsql.sourceforge
The SourceForge project xsql.sourceforge.net specifies the implementation of XSQL through a DTD . However, it is planned to use an XML schema at a later date . A tree and event- based API is used to parse the XSQL files and access their elements . XSQL by changes to the Perl - module XML::Generator::DBI realized. These changes are made by the module maintainer. XSQL is therefore available on every hardware platform on which Perl can be used. If there is enough interest, other programming languages can also be supported.
Oracle Application Server
The Oracle Application Server from Oracle uses XSQL pages to save XML data, transform and display them with XSLT if necessary . For application development with, for example, JDeveloper , the respective XML parser for Java or PL / SQL must be installed. The required classes are contained in the current revision of ORACLE's XML Developer Kit (XDK).
Web links
SourceForge project
- David Dooling: XSQL - Combining XML and SQL. SourceForge , November 1, 2002, accessed October 25, 2009 .
- XML :: Generator :: DBI. CPAN , accessed October 25, 2009 .
Oracle Application Server:
- Steven Feuerstein: XML for the PL / SQL Developer. Oracle Corporation , archived from the original on August 22, 2006 ; accessed on October 25, 2009 (English).
- Department of Computer Science, Mathematics and Natural Sciences: Database web applications with XML developer kit and XSQL pages from ORACLE. University of Technology, Economics and Culture Leipzig , accessed on October 25, 2009 .