On 5/13/10 8:59 AM, Fernando Gómez wrote:
> Any suggestions? Do other document oriented databases offer a better
> solution for this?
>    
Hey Fernando,

I'd suggest you checkout CouchDB. CouchDB uses JSON as it's document 
format, provides advanced indexing (anywhere in the JSON docs) via 
map/reduce queries that are typically written in JavaScript. The 
map/reduce queries are simple lamda JavaScript functions that are part 
of a "design" document (also a simple JSON object) in CouchDB. Check out 
the following two links for more info:
http://books.couchdb.org/relax/design-documents/design-documents
http://books.couchdb.org/relax/design-documents/views

A simple map reduce query using your city and address.city keys would 
look something like this:

function (doc) {
   if (doc.city) {
     emit(doc.city, doc);
   } else if (doc.address.city) {
     emit(doc.address.city, doc);
   }
}

That function would return the full document representation "keyed" by 
their cities (which is handy for sorting and later reducing by counting 
unique cities).

CouchDB lets you focus on pulling out the data you want, and it handles 
the indexing. Pretty handy. :)

Let me know if you have other questions about CouchDB.

Take care,
Benjamin