So you do have updates? Because updates makes a database more complicated.
If you need lat/lng then you need an R-tree and very few databases come with that.
Sounds to me like your going to have to write your own database - or more accurately your own index.
Basically store data as append only, and handle change as delete/append. Store just the offset to the data as the key.
I really hope your index can fit on one machine.
Do it like the facebook link I gave you earlier.
Your going to have a hard time with index merges (lat/lng merge with tags).
Maybe a better idea is don't store the object in the database, but just the offset to it (plus machine ID).
Then use any commercial database that has an R-Tree.
You have 200GB to 1PT of data to store. Which needs at least 25 machines.
But if you can store just the index, but not the data, maybe you can store the index on just one machine - that will makes things easier. (Obviously you'll have multiple machines with the same index for load balancing.)
This might help also: http://www.ddj.com/184410998 (instead of an R-Tree, you might be able to a regular index).
If you need lat/lng then you need an R-tree and very few databases come with that.
Sounds to me like your going to have to write your own database - or more accurately your own index.
Basically store data as append only, and handle change as delete/append. Store just the offset to the data as the key.
I really hope your index can fit on one machine.
Do it like the facebook link I gave you earlier.
Your going to have a hard time with index merges (lat/lng merge with tags).
Maybe a better idea is don't store the object in the database, but just the offset to it (plus machine ID).
Then use any commercial database that has an R-Tree.
You have 200GB to 1PT of data to store. Which needs at least 25 machines.
But if you can store just the index, but not the data, maybe you can store the index on just one machine - that will makes things easier. (Obviously you'll have multiple machines with the same index for load balancing.)
This might help also: http://www.ddj.com/184410998 (instead of an R-Tree, you might be able to a regular index).