What databases?

Ron Bourret has written an article that discusses how databases can be used with XML as well as briefly summarizing the software available for this purpose. You can find it at:

http://www.informatik.tu-darmstadt.de/DVS1/staff/bourret/xml/XMLAndDatabases.htm

 Check out SIM (Structured Information Manager) at http://www.mds.rmit.edu.au/sim_2.1/welcome.html,

sgrep at http://www.cs.helsinki.fi/~jjaakkol/sgrep.html

BUS (Bottom Up Search) at <"http://savage.comeng.chungnam.ac.kr/~sgml/>,

Cheshire at <http://cheshire.lib.berkeley.edu/>

XQL proposal at <http://www.w3.org/TandS/QL/QL98/pp/xql.html>.

Guide to Local Site, Intranet, and Portal Search Engines: http://www.searchtools.com>

Check out Software AG's soon to be released native XML database system at http://www.softwareag.com/tamino/

1. SQL products such as Oracle, IBM DB2, and Informix are object-relational DBMSs. The engineering staffs at those companies have been developing extensions for XML. There will be several important releases in the next few months (Oracle iFS, IBM's XML Extender). You'll have the option of storing a XML document in the database or as an external file. When stored internally, you can decompose a document or store it as a single column in a table.

2. POET, Bluestone, Object Design (eXcelon), and Adabas (Tamino) are also in the XML server space.

3. "Modeling, Metadata, XML (Web Techniques, June 1999) http://www.webtechniques.com/archives/1999/06/data/

Databases and XML XSQL

Have a look at the Oracle XSQL Servlet at http://technet.oracle.com/tech/xml Oracle XML SQL Utility for Java handles the SQL-to-XML for you, and the Oracle XSQL Servlet that makes it easy to build XML documents which pull in the data from one or more queries...

XML-DBMS, for transferring data between XML documents and relational databases. XML-DBMS views the XML document as a tree of objects (element types are usually classes, and PCDATA and attributes are properties of those classes) and map these to the database with an object-relational mapping. Included in XML-DBMS is an XML-based mapping language used to define the object view and map it to the database. XML-DBMS is free for all uses and comes with source code. For more info and download,

see:http://www.informatik.tu-darmstadt.de/DVS1/staff/bourret/xmldbms/xmldbms.htm

 

Languages that can model Data:

UML, OMG IDL, Microsoft IDL, Java, C++,
XML Schema:
DTD,
SOX <http://www.commerceone.com/solutions/xml/sox/sox.htm>,
XML-Data <"http://www.w3.org/TR/1998/NOTE-XML-data/>,
XML-Data-Reduced <http://www.ltg.ed.ac.uk/~ht/XMLData-Reduced.htm>,
DCD <http://www.w3.org/TR/NOTE-dcd>,
DDML <http://www.w3.org/TR/NOTE-ddml>,
RDF & RDF schema,
SQL


mappings between languages:

Java<->bytes:

Java serialization
RMI-IIOP


Java<->XML:

XML Data Binding
<http://www.javasoft.com/aboutJava/communityprocess/jsr/jsr_031_xmld.html>

a hypothetical "Java archive" facility, mentioned in the XML Data Binding
JSR above

CommerceOne's SOX->Java mapping

IBM XML BeanMaker
<http://www.alphaworks.ibm.com/aw.nsf/techmain/98D0F921C80C8ED6882566F30070
3F7C?OpenDocument>

Coins <http://www.jxml.com/coins/index.html>

KOML <http://www.inria.fr/koala/XML/serialization/>


OMG IDL<->Java:

OMG Java->IDL
OMG IDL->Java


XML<->OMG IDL:

Forthcoming OMG Request For Proposals (from the ORBOS task force)


Microsoft IDL<->Java:

Microsoft


XML<->Microsoft IDL:

Microsoft SOAP / Userland XML-RPC


OMG IDL<->Microsoft IDL:

Chapter 18 in CORBA 2.3



UML<->IDL:

Rational Rose


UML<->Java:

Rational Rose


XML<->Database:

IBM's XPK4J
<http://www.alphaworks.ibm.com/aw.nsf/techmain/7B29BBCB9A1C1C1A882566F30070
3F83?OpenDocument>

IBM's DataCraft
<http://www.alphaworks.ibm.com/aw.nsf/techmain/12CD979739AB8E968825671B0065
A4A6?OpenDocument>


RDF<->XML:

W3C's XML-based syntax for RDF, in RDF spec
<http://www.w3.org/TR/REC-rdf-syntax/>


RDF schema <-> XML schema:

subject of debate in W3C


More than two sided:

WDDX <http://www.wddx.org/>
XMOP <http://jabr.ne.mediaone.net/documents/xmop.htm>



Mike Spreitzer <spreitze@parc.xerox.com

http://parcweb.parc/spreitze/ (Xerox internal)
http://www.parc.xerox.com/spreitze/ (external)

 

DB2, Oracle, Informix, and Microsoft SQL Server are all SQL DBMSs, but the
first three are object-relational products. They have extensible
architectures so you can add user-defined types and user-defined methods to
customize a database. You can add custom access methods and indexes by
writing server extensions. You can install Java classes in a database to add
types and methods
(http://www.devx.com/upload/free/features/javapro/1999/03mar99/kn0399/kn0399