> > but is there a way where we can store user records separately and project > records separately. and jut give the link in solr ?? like mentioned below > and still making it > searchable and facetable ?? > With single core, unfortunately not.
Denormalizing data for storage and searches is a regular practice in Solr. It might not sound "proper" if you try to do this with heavily normalized data but there nothing wrong about it. To be specific, in your case, the fields to facet and search upon are designed correctly. My understanding is that you need the relationships to be preserved only for display. Right? If yes, then you can always create an untokenized field, say string, and store all the project specific data in some delimited format. e.g. in your case - projectName$$projectBU$$projectLocation etc. This data can be interpreted in your application to convert it back into a proper relational data structure for each document in the result. Cheers Avlesh On Thu, Oct 15, 2009 at 9:57 AM, ashokcz <ashokkumar.gane...@tcs.com> wrote: > > Hi All , > I have a specific requirement of storing multiple type of records. but dont > know how to do it . > First let me tell the requirement. > I have a table called user table and a user can be mapped to multiple > projects. > User table details are User Name , User Id , address , and other details . > I have stored them in solr but now the mapping between user and project has > to be stored . > Project table have (project name , location , business unit ,etc) > > I can still go ahead and store user has single record with project details > as indvidual fields , like > UserId:user1 > UserAddress: india > ProjectNames: project1,project2 > ProjectBU: retail , finance > ProjectLocation:UK,US > > Here i will search in fields like UserId , ProjectBU ,ProjectLocation and > have made UserAddress, ProjectLocation as facets > > > but is there a way where we can store user records separately and project > records separately . > and jut give the link in solr ?? like mentioned below and still making it > searchable and facetable ?? > > User Details > ========= > UserId:user1 > UserAddress: india > ProjectId:1,2 > > Project Details > ========== > ProjectId:1 > ProjectNames: project1 > ProjectBU: retail > ProjectLocation:UK > > ProjectId:2 > ProjectNames: project2 > ProjectBU:finance > ProjectLocation:US > > > -- > View this message in context: > http://www.nabble.com/storing-multiple-type-of-records-%28Parent---Child-Relationship%29-tp25902894p25902894.html > Sent from the Solr - User mailing list archive at Nabble.com. > >
