This article looks in detail at how to generate XML data from your relational
database. Although the examples were run on Oracle, very little of the code
is Oracle specific. You can easily use all the ideas and examples presented
here in other relational databases. We did this project at University of
Massachusetts Boston as part of the Electronic Field Guide (EFG) project.
XML is the de facto standard for data exchange. It's simple, Unicode based,
and platform independent. XML is a metadata language; it contains information
about the data. All these features make it an attractive standard for
exchanging data.
Why Generate XML from Relational Data?
Today most data (80% or more), is stored in relational databases such as
Oracle, DB2, SQL Server 2000, and others. The Intern... (more)
In this article I am going to introduce you to the open source, free (GNU
LGPL license), native XML database eXist (www.exist-db-org). Data is
important, no question about it. Data that can't be queried is not very
useful. Users expect to have good query response time. From my personal
experience and testing, I am confident in saying that eXist is a fairly good
database. It has very good... (more)
Berkeley DB XML (BDB XML) is a popular native XML database. It can be
accessed through the shell or within another program. This month I will show
you how to use BDB XML in Java. BDB XML has similar APIs for all supported
languages such as Java and C++, therefore the ideas presented in this article
apply to all supported languages. I have been closely following BDB XML from
the very firs... (more)
In this article I am going to introduce you to the latest version of the
Berkeley DB XML, version 2.2.8. Berkeley DB XML (BDB XML) is built on top of
the well-known Berkeley Database (BDB). BDB XML is an open source, native XML
database. Like its ancestor, BDB, it's an embedded database. It provides APIs
for the Java, C++, Perl, Python, PHP, and Tcl languages. It supports the
popular XML... (more)
Apache Software Foundation's Xindice is an open source native XML database.
Apache provides great software to developers such as the Apache Web Server,
Tomcat Application Server, Cocoon Web Development Framework, Struts
Framework, Ant, and many more under an open source license. Apache Web Server
is an industrial-strength product that is used by many high-traffic Web
sites. Apache Tomcat... (more)