Article:		Using Topic Maps to Extend Relational Databases
Subject:		queries using associations
Date:		2003-03-27 15:05:47
From:		Taylor Cowan
This is interesting, however, I see a weakness even in simple queries such as finding out "which employees are taking the XML class". You can get the topic id's associated with the XML topic, however, Employee_12 doesn't help you get back to a real employee record...unless you split the topic id into table/id then query again. The only way I can see to do this would be for the topic map id to be identical to the employee id, or for the employee table to have a column called "topic_map_id". Was that the ideal solution, for each table to have a column to associate a row back to its topic? I couldn't review the supplied DB. Perhaps next time you can supply a DDL or something for those of us who don't use *.mdb databases. Taylor

Previous Message

Next Message

• queries using associations
  2003-04-01 04:12:34 Marc de Graauw