I've prototyped a solution which makes use of multiple doc types. Does the following have any value in terms of field value storage or are field values saved once and pointers from other records maintained making the below design redundant?
we have CITY (500) and each city has many HOTEL (75000). our schema looks like: doc type : CITY (stored and indexed) n number of city attributes (lat,lon, name, city description, city holiday categories etc) All stored and indexed doc type HOTEL (stored and indexed) n number of hotel attributes (lat, lon, hotel name, hotel description, star rating, feature list, etc ) All stored and indexed n number of city attributes (lat,lon, name, city description, city holiday categories) **not stored** but indexed Basically we can search hotels using city attributes but to display city data for a chosen hotel we would search for that city document to retrieve values. Do we gain anything here ? Basically would the city fields associated with hotels be stored and repeated 74500 less times or are the values stored once and pointers for each hotel document kept to point at the city values ? Has any one done a similiar thing and ran into problems ?? thanks in advance lee c
