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

M.Altheim M.Altheim@open.ac.uk
Tue, 31 May 2005 15:32:48 +0100


DQoNCj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTogdG9waWNtYXBtYWlsLWFk
bWluQGluZm9sb29tLmNvbSBbbWFpbHRvOnRvcGljbWFwbWFpbC1hZG1pbkBpbmZvbG9vbS5jb21d
DQo+IE9uIEJlaGFsZiBPZiBCw6luw6lkaWN0ZSBMZSBHcmFuZA0KPiBTZW50OiAzMSBNYXkgMjAw
NSAxMjozOQ0KPiBUbzogdG9waWNtYXBtYWlsDQo+IFN1YmplY3Q6IFJFOiBbdG9waWNtYXBtYWls
XSBHZW5lcmF0aW5nIFRNcyBvdXQgb2YgcmVsYXRpb25hbCBEYXRhYmFzZXMgLyBIb3cNCj4gVG8/
DQo+IA0KPiBIZWxsbywNCj4gDQo+IFRoYW5rIHlvdSBNdXJyYXkgZm9yIHRoaXMgcmVmZXJlbmNl
IHRvIG15IHdvcmsgOykNCj4gDQo+IEkgYWdyZWUgd2l0aCBKYWNrLCB0aGVyZSBpcyBhIGxvdCB0
byBkbyBpbiB0aGUgZmllbGQgb2YgdG9waWMgbWFwcw0KPiB2aXN1YWxpemF0aW9uLg0KPiANCj4g
SSBoYWQgdG8gZm9jdXMgb24gb3RoZXIgc3ViamVjdHMgdGhlIGxhc3QgZmV3IHllYXJzIGJ1dCBJ
IGFtIHN0aWxsIHZlcnkNCj4gaW50ZXJlc3RlZCBpbiBUTSB2aXN1YWxpemF0aW9uIGFuZCBJIHdv
dWxkIGJlIGdsYWQgdG8gY29udHJpYnV0ZSBpbiB0aGlzDQo+IGFyZWEuIEkgZG8gbm90IGhhdmUg
bXVjaCB0aW1lIGZvciBwcm9ncmFtbWluZyBhdCB0aGUgbW9tZW50LCBidXQgSSB3b3VsZCBiZQ0K
PiBnbGFkIHRvIHNoYXJlIG15IGlkZWFzLg0KPiANCj4gQmVzdCByZWdhcmRzLA0KPiANCj4gQmVu
ZWRpY3RlIExlIEdyYW5kDQoNCkJlbmVkaWN0ZSwNCg0KWW91J3JlIHF1aXRlIHdlbGNvbWUsIGFu
ZCBJJ20gZ2xhZCB0byBoZWFyIGZyb20geW91IC0tIGl0J3MgYmVlbg0KYSBmZXcgeWVhcnMsIHll
cz8NCg0KSSB3b3VsZCBiZSBpbnRlcmVzdGVkIGluIGhlYXJpbmcgeW91ciBleHBlcmllbmNlIGlu
IHRyeWluZyB0bw0KYW5zd2VyIGEgcXVlc3Rpb24gSSB0aGluayBpcyBwZXJ0aW5lbnQgdG8gdGhp
cyBkaXNjdXNzaW9uOg0KDQogIFE6IEluIHRoZSBhcmVhIG9mIFRvcGljIE1hcCB2aXN1YWxpemF0
aW9uLCB3aGVuIHZpc3VhbGl6aW5nDQogICAgIFRvcGljcyBhbmQgQXNzb2NpYXRpb25zIGJldHdl
ZW4gVG9waWNzLCBhcmUgdGhlIHRlY2huaXF1ZXMNCiAgICAgdXNlZCB0byB2aXN1YWxpemUgaGln
aGx5LWRldGFpbGVkLCByZWxhdGl2ZWx5IHNtYWxsIFRvcGljDQogICAgIE1hcHMgc3VpdGFibGUg
Zm9yIGxhcmdlciBzY2FsZSBvbmVzPyBJZiBub3QsIGlzIHRoaXMgDQogICAgIGRpc2NvbnRpbnVp
dHkgYmFzZWQgb24gYSBjb250aW51dW0sIG9yIGlzIHRoZXJlIHJvdWdobHkNCiAgICAgYSB0aHJl
c2hvbGQgYXQgd2hpY2ggYSBkaWZmZXJlbnQgdmlzdWFsaXphdGlvbiBwYXJhZGlnbQ0KICAgICBp
cyB0aGVuIHJlcXVpcmVkPyANCg0KRm9yIGV4YW1wbGUsIG9uZSB2aXN1YWxpemF0aW9uIHRlY2hu
aXF1ZS9wYXJhZGlnbSBtaWdodCBiZSANCnN1aXRhYmxlIGZvciBzYXksIDIwIFRvcGljcywgYW5v
dGhlciBmb3IgMzAwIFRvcGljcywgYnV0DQpuZWl0aGVyIHN1aXRhYmxlIGZvciAzMDAwIG9yIDMw
LDAwMC4gRG9lcyB0aGlzICpncmFkdWFsbHkqIA0KYmVjb21lIHVuc3VpdGFibGUsIG9yIGlzIHRo
ZXJlIGEgdGhyZXNob2xkIChyb3VnaGx5KSBhdCANCndoaWNoIHBvaW50IGEgc3BlY2lmaWMgc3R5
bGUgb2YgdmlzdWFsaXphdGlvbiBkb2Vzbid0IHNjYWxlIA0KYW55IGZ1cnRoZXI/IA0KDQpLbm93
aW5nIHN1Y2ggYSB0aHJlc2hvbGQgKGV2ZW4gcm91Z2hseSkgd291bGQgaGVscCBkZXRlcm1pbmUN
CmZvciBhIGdpdmVuIHByb2plY3Qgd2hpY2ggdmlzdWFsaXphdGlvbiBhcHByb2FjaCBpcyBzdWl0
YWJsZS4NCg0KT2YgY291cnNlLCB0aGVyZSBhcmUgbWFueSBmYWN0b3JzIGluIG1ha2luZyBzdWNo
IGRlY2lzaW9ucywNCnN1Y2ggYXMgdGhlIHJlcXVpcmVkIG9uLXNjcmVlbiBpbmZvcm1hdGlvbiwg
YWJpbGl0eSB0byB6b29tLA0KZmlsdGVyLCBvciBsb2NhbGl6ZSwgZXRjLiAgV2hhdCBJJ20gdGhp
bmtpbmcgaXMgdGhhdCBpdCBtaWdodA0KYmUgdmFsdWFibGUgdG8gYmVnaW4gY2F0YWxvZ3Vpbmcg
dGhlIGRpZmZlcmVudCB2aXN1YWxpemF0aW9uDQp0ZWNobmlxdWVzIChhcyB5b3UgaGF2ZSBkb25l
IHNvIHdlbGwgaW4gdGhlIFhNTCBUb3BpYyBNYXBzIA0KYm9vayksIGJ1dCBwZXJoYXBzIG9uIGEg
d2lraSBvciBzb21ld2hlcmUgdGhhdCB3b3VsZCBhbGxvdw0KbmV3IHByb2plY3RzIHRvIGJlIGFk
ZGVkIGJ5IHRoZWlyIGF1dGhvcnMuIEJlY2F1c2UgdmlzdWFsaS0NCnphdGlvbiBpcyBzbyBjcnVj
aWFsIGluIGxhcmdlIHNjYWxlIGluZm9ybWF0aW9uIG1hbmFnZW1lbnQNCnByb2plY3RzLCBhbmQg
d2hlcmUgVG9waWMgTWFwcyBtYXkgcHJvdmlkZSBpbXBvcnRhbnQgbmV3DQphYmlsaXRpZXMsIGl0
J2QgYmUgZ3JlYXQgdG8gaGF2ZSBzb21ld2hlcmUgd2hlcmUgd2UgY291bGQgDQprZWVwIHRyYWNr
IG9mIGV4aXN0aW5nIHByb2plY3RzIGFuZCBuZXcgZGV2ZWxvcG1lbnRzLiANCg0KTm93LCBJIGRv
bid0IG1lYW4gdG8gcHV0IGFueSBwcmVzc3VyZSBvbiB5b3UgLS0gSSdtIHN1cmUgdGhhdA0Kd2Ug
Ym90aCBhZ3JlZSB0aGF0IHRoZXJlIGFyZSBubyBzaW1wbGUgYW5zd2VycywgYnV0IGl0IHdvdWxk
DQpiZSB2YWx1YWJsZSB0byB0aGUgY29tbXVuaXR5IHRvIGJlZ2luIHRvIGRlbGluZWF0ZSB0aGUg
ZmFjdG9ycy4NCg0KSSBub3RlIHRoYXQgZWFzeXRvcGljbWFwcy5vcmcgc2VlbXMgdG8gaGF2ZSBi
ZWVuIGRlc3Ryb3llZCBieQ0Kc3BhbSwgc28gdGhlcmUncyBub3QgYSBwYXJ0aWN1bGFybHkgZ29v
ZCwgdmVuZG9yLW5ldXRyYWwgcGxhY2UgDQp0byBkbyB0aGlzLiBJIGhvcGUgdG8gaGF2ZSBhIHdp
a2kgdXAgYnkgdGhlIGVuZCBvZiBzdW1tZXIsIHNvDQpwZXJoYXBzIHRoZXJlLi4uICB1bnRpbCBz
dWNoIHRpbWUsIHRoaXMgbGlzdCBkb2VzIHByb3ZpZGUgDQphcmNoaXZlcywgc28gd2UnbGwgYXQg
bGVhc3QgaGF2ZSBhIHJlY29yZC4NCg0KQWxsIHRoZSBiZXN0LA0KDQpNdXJyYXkNCg0KLi4uLi4u
Li4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4u
Li4uLi4uLg0KTXVycmF5IEFsdGhlaW0gICAgICAgICAgICAgICAgICAgICAgICAgIGh0dHA6Ly93
d3cuYWx0aGVpbS5jb20vbXVycmF5Lw0KU3RyYXRlZ2ljICYgU2VydmljZSBEZXZlbG9wbWVudCAN
ClRoZSBPcGVuIFVuaXZlcnNpdHkgTGlicmFyeQ0KTWlsdG9uIEtleW5lcywgQnVja3MsIE1LNyA2
QUEsIFVLDQoNCiAgICAgICAgICBJbHMgb250IGwnb3J0ZWlsIGRlIEJvdWMsICYgZCd1biBDaGV2
cmVpbCBsJ29yZWlsbGUsDQogICAgICAgICAgTGEgY29ybmUgZCd1biBDaGFtb2lzLCAmIGxhIGZh
Y2UgdmVybWVpbGxlDQogICAgICAgICAgQ29tbWUgdW4gcm91Z2UgQ3JvaXNzYW50OiAmIGRhbmNl
bnQgdG91dGUgbnVpY3QNCiAgICAgICAgICBEZWRhbnMgdW4gY2FycmVmb3VyLCBvdSBwcmVzIGQn
dW5lIGVhdSBxdWkgYnJ1aWN0Lg0KDQo=