Oye!
Several key-value stores don't need one-to-many rows, and are instead
one-to-one key value pairs. i thought someone on this forum might have
experience with Tokyo Cabinet. i quote from the TC docs...
<quote>
As for database of hash table, each key must be unique within a
database, so it is impossible to store two or more records with a key
overlaps.
As for database of B+ tree, records whose keys are duplicated can be
stored.
</quote>
so i start with fruits.tsv inorder to bulk load it
/* fruits.tsv */
> cat fruits.tsv
apples 1
oranges 1
grapes 1
apples 2
/* creating the btree TC store */
> tcbmgr create fruits
/* bulk loading */
> tcbmgr importtsv fruits fruits.tsv
/* listing keys */
> tcbmgr list fruits
apples
oranges
grapes
apples
/* trying to get multiple values for apples */
> tcbmgr get fruits apple
10
1)Any ideas on how to get both the values from b-tree TC store
2) Any experiences in other one-to-many stores will also be insightful
~
Keep Clicking,
Bhasker V Kode,
http://developers.hover.in