Re: Lucene vs SQL.

2012-08-01 Thread Konstantyn Smirnov
If you tokenize AND store fields in your document, you can always pull them and re-invert using another analyzer, so you don't need to store the "original data" somewhere else. The point is rather the performance. I started a discussion on that topic http://lucene.472066.n3.nabble.com/Performance

Re: Lucene vs SQL.

2012-07-27 Thread Denis Bazhenov
The main idea behind Lucene is search the data. In most fast and scalable way possible. For achieving this goal Lucene give up on original data availability and consistency. So you should be ready to discard your index and rebuild it from scratch. To do this, you need to have your original data.

Re: Lucene vs SQL.

2012-07-27 Thread Felipe Carvalho
Please forgive my lack of knowledge on this theme, but why cannot Lucene / Solr cannot be used as primary database / data store? On Fri, Jul 27, 2012 at 3:16 AM, Aditya wrote: > Check out these articles on this topic. Hope it helps. > http://www.findbestopensource.com/article-detail/lucene-solr-a

Re: Lucene vs SQL.

2012-07-26 Thread Aditya
Check out these articles on this topic. Hope it helps. http://www.findbestopensource.com/article-detail/lucene-solr-as-nosql-db http://www.lucidimagination.com/blog/2010/04/30/nosql-lucene-and-solr/ In nutshell, It is good to use Lucene as NoSQL but better have your data stored in some persistent

Re: Lucene vs SQL database

2005-09-30 Thread Eugeny N Dzhurinsky
On Fri, Sep 30, 2005 at 12:22:53PM -0400, Erik Hatcher wrote: > > That is exactly correct. The source code to the SecurityFilter is > found in the .zip file you can download from http:// > www.lucenebook.com - and it wouldn't hurt our feelings one bit if you > bought the book too :) Nice, I

Re: Lucene vs SQL database

2005-09-30 Thread Erik Hatcher
On Sep 30, 2005, at 5:45 AM, Eugeny N Dzhurinsky wrote: On Thu, Sep 29, 2005 at 08:56:50AM -0400, Erik Hatcher wrote: of only allowed data... But if Lucene needs to index anything, how > could I > >define the access privileges for data? There are many options available. One such te

Re: Lucene vs SQL database

2005-09-30 Thread mark harwood
See the code here for an example: http://issues.apache.org/jira/browse/LUCENE-434 This demonstrates: * embedding and running Lucene queries directly in Derby or HSQLDB databases * alternatively, using an RDBMS-provided result set (from potentially any database) to filter an externally run Lucene

Re: Lucene vs SQL database

2005-09-30 Thread Eugeny N Dzhurinsky
On Thu, Sep 29, 2005 at 08:56:50AM -0400, Erik Hatcher wrote: > >of only allowed data... But if Lucene needs to index anything, how > >could I > >define the access privileges for data? > There are many options available. One such technique I described in > "Lucene in Action" ... a SecurityFilt

Re: Lucene vs SQL database

2005-09-29 Thread Chris Lu
We have a product, DBSight, just to extract database content and render search results. Many features can be found on the website. Chris Lucene RAD on Any Databases http://www.dbsight.net On 9/29/05, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote: > Is there any way to use

Re: Lucene vs SQL database

2005-09-29 Thread Eugeny N Dzhurinsky
On Thu, Sep 29, 2005 at 09:29:56AM -0400, Mag Gam wrote: > Check this link outI am trying to do the same > > http://marc.theaimsgroup.com/?l=lucene-user&m=100556272928584&w=2 > I am using Apache Derby and trying to integrate that with lucene > Its tough to find a very very simple example f

Re: Lucene vs SQL database

2005-09-29 Thread Mag Gam
Check this link outI am trying to do the same http://marc.theaimsgroup.com/?l=lucene-user&m=100556272928584&w=2 I am using Apache Derby and trying to integrate that with lucene Its tough to find a very very simple example for this online. goodluck On 9/29/05, Erik Hatcher <[EMAIL PRO

Re: Lucene vs SQL database

2005-09-29 Thread Erik Hatcher
On Sep 29, 2005, at 8:46 AM, Eugeny N Dzhurinsky wrote: On Thu, Sep 29, 2005 at 08:39:53AM -0400, George Abraham wrote: Eugene, You could grab all the fields for a record in a SQL database, mash it all together and transfer it into one indexing field in Lucene. Use some scripting tools (or

Re: Lucene vs SQL database

2005-09-29 Thread Eugeny N Dzhurinsky
On Thu, Sep 29, 2005 at 08:39:53AM -0400, George Abraham wrote: > Eugene, > You could grab all the fields for a record in a SQL database, mash it all > together and transfer it into one indexing field in Lucene. Use some > scripting tools (or even JDBC and Java) to do this. However if you are > ask

Re: Lucene vs SQL database

2005-09-29 Thread Nader Henein
You can use something like hibernate to load the database tables into java objects and then load them into Lucene Documents, fast and dirty will take you a few hours to code, but if you're going the distance a couple of days should do the trick. Nader Henein George Abraham wrote: Eugene, Yo

Re: Lucene vs SQL database

2005-09-29 Thread George Abraham
Eugene, You could grab all the fields for a record in a SQL database, mash it all together and transfer it into one indexing field in Lucene. Use some scripting tools (or even JDBC and Java) to do this. However if you are asking if Lucene can go and look over a SQL database and return results, that