xml-dev - FW: DTD-to-DB SCHEMA

[Andrew Layman <andrewl@microsoft.com>]

Thomas Bergstraesser asked me to forward this to you:


We have developed the Open Information Model (OIM) a set of over 200 types
that describe meta data in the application development, database design, and
data warehousing domain. Part of this model is a complete database schema
model for relational, multidimensional, and legacy models.

> The OIM is described completely in UML and can be mapped onto different
> implementation technologies. The interchange of meta data described by OIM
> uses XML and we generate DTDs directly from the UML model. The DTD
> provides the tags and structures to describe elements like schema, table,
> column as well as cross relationships to components or executables.
> 
> We have announced recently that we will move the OIM and its XML
> Interchange Format to the Meta Data Coalition. We are currently in the
> process of removing all vendor- specific information from the model in
> order to make it technology-independent and vendor-neutral. As its sounds
> this might be an ideal starting point for your efforts and provides you
> with the additional benefit that your schema can be stored in many
> existing repositories and displayed by over 60 modeling tools.
> 
> Our Web site http://www.microsoft.com/repository should provide you with
> all the necessary information including a downloadable version of our SDK.
> The SDK includes the UML model of the OIM, the DTD generator, and the DTDs
> for all the different parts of the OIM as well as the necessary
> import/export utilities. Note that this is all still focussed on the
> Microsoft Repository technology.
> 
> I hope this information is helpful for you.
> 
>     - thomas
> 
> 
	.......

> FF,
> 
> I work on database persistence with schema mapping on the IBM San
> Francisco project (reusable components -- see
> www.ibm.com/Java/Sanfrancisco/).  Anyway, we're currently working on
> developing an XML interface to our schema mapping tool that allows users
> to update their mappings via XML documents.  It's currently in a
> somewhat-early development phase right now.
> 
> What is it specifically that you need to do?  Are there any features
> that would be useful for you?  One of the things we're looking for is a
> standard DTD that can describe a database table (with, for example,
> <TABLE> tags and <COLUMN> tags that would describe the tables and
> columns).  Is there anything that you know of that does this.  Thanks
> ...
> 
> --
> Shawn Lauzon
> IBM San Francisco Database Persistence
> www.ibm.com/Java/Sanfrancisco/
> email: lauzon@us.ibm.com
> 
> 
> xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@ic.ac.uk
> Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
> To (un)subscribe, mailto:majordomo@ic.ac.uk the following message;
> (un)subscribe xml-dev
> To subscribe to the digests, mailto:majordomo@ic.ac.uk the following
> message;
> subscribe xml-dev-digest
> List coordinator, Henry Rzepa (mailto:rzepa@ic.ac.uk)

xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@ic.ac.uk)