[topicmapmail] Generating TMs out of relational Databases / How To?

[Murray Altheim]

Andreas Fleck wrote:
> Hello everybody,
> 
> i´ve searched the last two days for a good tutorial or "recipe" on how to
> generate Topic Maps out of the Data Model of a relational Database (MySQL).
> 
> - Can anybody point me to a good tutorial or give me a recipe on how to do
> this on the basic level (stuff like: Every Row of a Table has to be
> transformed into a topic)?`
> 
> - What ways of auto-generating Topic Maps out of RDBMS are there?
> 
> - For my project I am using TM4J, can I somehow use the Hybernate Backend to
> generate the Topic Maps?
> 
> Any help is highly appreciated. I´m pretty confused right now.
> 
> Greetings Andreas
> 
> 
> P.S. for those of you interested in a more precise describtion of the data
> modell:
> The datamodell of my database is rather simple. It consists of 4 Tables and
> describes Software-Tools (Table No.1), used within a Development-Project
> (Table No.2) and the Relationship (Table No.3) among those Tools, with the
> Linktype (Table No. 4), which is connecting those Software-Tools.
> My overall goal is to visualize those connections within Eclipse.

Andreas,

Before anyone could answer such questions with any specifics, they'd
really need to first understand what you're trying accomplish with
such an auto-generated Topic Map. Do you have a set of requirements
for the result? Is it for navigation, classification, integration
between systems or with an existing Topic Map system? Without that
kind of information it's difficult to know where to start.

Murray

......................................................................
Murray Altheim                          http://www.altheim.com/murray/
Strategic and Services Development
The Open University Library
The Open University, Milton Keynes, Bucks, MK7 6AA, UK               .

    The home stretch of the Leopard Challenge involves dragging a
    175-pound dummy about 30 yards to the finish line. "We're trying
    to get as real as we can, but we still fall short," said Keith
    Barret, a company manager, noting that the average American now
    weighs 188 pounds and that the average policeman with gear weighs
    more than 200.
    http://www.nytimes.com/2005/05/29/weekinreview/29eckholm.html