| Dany wrote: the ''irreducible n-order predicate'' bit would suggest that | it isn't possible to go the other way, to store RDBMS data as triples | in the general case. | | IBL wrote: Here's an example of a general method. The first table is ''shredded'' | to produce the last table, then reassembled using the rule | | You can view, run and change this agent by pointing a browser to reengineeringllc.com | and selecting RelationToTriplesAndBackAgain this-person works for this-company in this-location in this-state ================================================================= Joe Smith Generic LLC Houston TX Jill Baker RabbitTech Denver CO row some-row position 1 contains some-item1 row that-row position 2 contains some-item2 row that-row position 3 contains some-item3 row that-row position 4 contains some-item4 --------------------------------------------------------------------------- the reassembled table has a row that-item1 that-item2 that-item3 that-item4 row this-row position this-position contains this-item ======================================================= 1 1 Joe Smith 1 2 Generic LLC 1 3 Houston 1 4 TX 2 1 Jill Baker 2 2 RabbitTech 2 3 Denver 2 4 CO