Re: How to define my data in schema.xml

2013-06-19 Thread Mysurf Mail
3 9:58 AM > > To: solr-user@lucene.apache.org > Subject: Re: How to define my data in schema.xml > > Hi Jack, > Thanks, for you kind comment. > > I am truly in the beginning of data modeling my schema over an existing > working DB. > I have used the school-teachers-stude

Re: How to define my data in schema.xml

2013-06-18 Thread Jack Krupansky
@lucene.apache.org Subject: Re: How to define my data in schema.xml Hi Jack, Thanks, for you kind comment. I am truly in the beginning of data modeling my schema over an existing working DB. I have used the school-teachers-student db as an example scenario. (a, I have written it as a disclaimer in my

Re: How to define my data in schema.xml

2013-06-18 Thread Mysurf Mail
organized to > satisfy those user queries. > > -- Jack Krupansky > > -Original Message- From: Mysurf Mail > Sent: Tuesday, June 18, 2013 2:20 AM > To: solr-user@lucene.apache.org > Subject: Re: How to define my data in schema.xml > > > Thanks for your reply

Re: How to define my data in schema.xml

2013-06-18 Thread Jack Krupansky
hat will guide you in thinking about how the data would need to be organized to satisfy those user queries. -- Jack Krupansky -Original Message- From: Mysurf Mail Sent: Tuesday, June 18, 2013 2:20 AM To: solr-user@lucene.apache.org Subject: Re: How to define my data in schema.xml Tha

Re: How to define my data in schema.xml

2013-06-17 Thread Mysurf Mail
Thanks for your reply. I have tried the simplest approach and it works absolutely fantastic. Huge table - 0s to result. two problems as I described earlier, and that is what I try to solve: 1. I create a flat table just for solar. This requires maintenance and develop. Can I run solr over my regul

Re: How to define my data in schema.xml

2013-06-17 Thread Gora Mohanty
On 18 June 2013 01:10, Mysurf Mail wrote: > Thanks for your quick reply. Here are some notes: > > 1. Consider that all tables in my example have two columns: Name & > Description which I would like to index and search. > 2. I have no other reason to create flat table other than for solar. So I > w

Re: How to define my data in schema.xml

2013-06-17 Thread Mysurf Mail
Thanks for your quick reply. Here are some notes: 1. Consider that all tables in my example have two columns: Name & Description which I would like to index and search. 2. I have no other reason to create flat table other than for solar. So I would like to see if I can avoid it. 3. If in my exampl

Re: How to define my data in schema.xml

2013-06-17 Thread Gora Mohanty
On 17 June 2013 21:39, Mysurf Mail wrote: > Hi, > I have created a flat table from my DB and defined a solr core on it. > It works excellent so far. > > My problem is that my table has two hierarchies. So when flatted it is too > big. What do you mean by "too big"? Have you actually tried indexin

How to define my data in schema.xml

2013-06-17 Thread Mysurf Mail
Hi, I have created a flat table from my DB and defined a solr core on it. It works excellent so far. My problem is that my table has two hierarchies. So when flatted it is too big. Lets consider the following example scenario My Tables are School Students (1:n with school) Teachers(1:n with scho