* Andreas Fleck
|
| 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)?`
I think what you usually want is a "semantic mapping" in the sense
that you want a topic map that has the same semantics (or meaning) as
the database you started from.
This means that typically you have to look at the database and
consider what you want each table mapped to. Some common alternatives
are:
1. each row becomes a topic of a specific type, and each column a
name, occurrence, or association (possibly also PSI)
2. each row becomes an association of a specific type, and each
column a role of a specific type (with role player)
3. each row becomes an occurrence/name of a specific type, attached
to a topic indicated in one of the columns
| - What ways of auto-generating Topic Maps out of RDBMS are there?
The main ways at the moment are probably:
1. Use one of the standard DB2XML tools and produce XML from that
which you then map to XTM with XSLT
2. Use your favourite scripting language and produce LTM directly
| - For my project I am using TM4J, can I somehow use the Hybernate
| Backend to generate the Topic Maps?
I don't think so. I think that backend is bound to a specific schema,
but I'm not certain.
| The datamodell of my database is rather simple. It consists of 4
| Tables and describes Software-Tools (Table No.1),
Sounds to me like each row here becomes a topic of type software-tool,
with one column becoming the name, another occurrence of type X, ...
| used within a Development-Project (Table No.2)
Here each row is probably a development-project, one column the name,
another column an association with a software-tool, etc
| and the Relationship (Table No.3) among those Tools,
Probably each row is an association of a type given in the table, with
individual columns specifying the different tools in the association.
| with the Linktype (Table No. 4), which is connecting those
| Software-Tools.
Sounds like each row here is a topic, and that these topics are used
as the types of the associations defined by table no 3.
| My overall goal is to visualize those connections within Eclipse.
That should be doable with the visualization tool in OKS, which is a
Java component.
--
Lars Marius Garshol, Ontopian <URL: http://www.ontopia.net >
GSM: +47 98 21 55 50 <URL: http://www.garshol.priv.no >
|
