From OpenStreetMap Wiki
Link tables for nodes, ways, and segments
I don't like this idea all that much. A few thoughts why:
- Finding out whether an object is part of a relationship - which will be a very common operation as you need to prohibit deletion of such objects, and you also may need to return such objects together with their partners - requires searching SIX tables each time (e.g. you have a node, you need to search link_node_* and link_*_node). There must be other ways. I will sketch one on the page shortly.
- I think/hope that the abolution of segments will come before this; even if it doesn't, we must not make that more complicated by allowing segments to become partners in relationships
- Versioning needs to be taken care of
--Frederik Ramm 02:17, 15 June 2007 (BST)