On Tue, Jul 27, 2010 at 22:29, Craig Taverner wrote:
> Mapping property values to a discrete set, and refering to them using
> their 'id' is quite reminiscent of a foreign key
> in a relational database.
Yes, with a relational database I would create foreign keys and maybe bitmap
indexes on colum
Mapping property values to a discrete set, and refering to them using their
'id' is quite reminiscent of a foreign key in a relational database. Why not
take the next step and make a node for each value, and link all data nodes
to the value nodes? This is then a kind of index, a category index.
I
Lately I've played with some OpenStreetMap data...
Nodes imported have many properties with a small set of values (road
type, point-of-interest type, colour, ...) but I don't know in advance
the set of values (sometimes a new value can become standard,
sometimes an invalid value is present).
Other
3 matches
Mail list logo