[topicmapmail] Topic Maps in a DBMS

[Murray Altheim]

Dan Corwin wrote:
> Hi Murray-
> 
> If I want to persist various topic maps in a data base,
> what table structures would I declare?
> 
> I can visualize topic maps concretely as XTM fragments,
> or sometimes as networks of Java objects.
> 
> But what does a topic map look like under (e.g) mySQL?
> 
> And is this black art or a cookbook design pattern?
> 
> Dan

Well, there've been several suggestions since my first reply, but
apart from those is perhaps another:  open source is definititely
not "black box", and you can look under the hood of the open source
topic map engine TM4J to see how it handles storage of topic map
objects. I use the in-memory implementation so I'm not familiar with
how the DB code works, but TM4J also includes a number of DB
implementations as well, hibernate and ozone, plus I believe several
DB APIs. Perhaps Kal can elucidate when he gets a change.

Murray

...........................................................................
Murray Altheim                         http://kmi.open.ac.uk/people/murray/
Knowledge Media Institute
The Open University, Milton Keynes, Bucks, MK7 6AA, UK                    .

    "Shhh. Be vewy, vewy quiet. We're hunting wabbits." -- Elmer Fudd

    "I don't know how close we are, closer than we were yesterday,
     I guess. All I know is we're on the hunt." -- George W. Bush
     BBC News: http://news.bbc.co.uk/1/hi/world/americas/3110615.stm