Re: Using Solr to index a database

2009-05-06 Thread Amit Nithian
Each PRODUCT would be a document in your index with fields number, name and price. If you wanted to start off simple, your schema.xml could just define these three fields; however, for a search index, you may want to index name several ways (i.e. with and without stop words etc). The DIH is intell

Re: Using Solr to index a database

2009-05-06 Thread uday kumar maddigatla
Hi I too having the same doubt. I would like to check How Solr is index and search the data which is there in database. For example, lets say we have a table called PRODUCTS, and within that table, we have the following columns: NUMBER (product number) NAME (product name) PRICE How would w

Re: Using Solr to index a database

2009-04-21 Thread Noble Paul നോബിള്‍ नोब्ळ्
delta query is for incremental imports us ethe 'query' attribute to import data On Tue, Apr 21, 2009 at 7:35 PM, ahammad wrote: > > Thanks for the link... > > I'm still a bit unclear as to how it goes. For example, lets say i have a > table called PRODUCTS, and within that table, I have the fo

Re: Using Solr to index a database

2009-04-21 Thread ahammad
Thanks for the link... I'm still a bit unclear as to how it goes. For example, lets say i have a table called PRODUCTS, and within that table, I have the following columns: NUMBER (product number) NAME (product name) PRICE How would I index all this information? Here is an example (from the link

Re: Using Solr to index a database

2009-04-20 Thread Noble Paul നോബിള്‍ नोब्ळ्
On Mon, Apr 20, 2009 at 7:15 PM, ahammad wrote: > > Hello, > > I've never used Solr before, but I believe that it will suit my current > needs with indexing information from a database. > > I downloaded and extracted Solr 1.3 to play around with it. I've been > looking at the following tutorials:

Re: Using Solr to index a database

2009-04-20 Thread ahammad
For now it's unclear, as this is sort of an "experiment" to see how much we can do with it. I am inclined to use the index within Solr though, simply for the very powerful querying (the stuff I've seen at least). I am not exactly sure how much of the querying capabilities I'll require though. I'l

Re: Using Solr to index a database

2009-04-20 Thread Glen Newton
You have not indicated how you wish to use the index (inside Solr or not). It is possible that LuSql might be an preferable alternative to Solr/DataImportHandler, depending on your requirements. LuSql: http://lab.cisti-icist.nrc-cnrc.gc.ca/cistilabswiki/index.php/LuSql Disclaimer: I am the autho