lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mag Gam <magaw...@gmail.com>
Subject Re: Lucene vs SQL database
Date Thu, 29 Sep 2005 13:29:56 GMT
Check this link out....I 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 <erik@ehatchersolutions.com> wrote:
>
>
> 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 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 would not work. Lucene has to index the database fields
> >> first. The
> >> indexing would happen with the first two sentences of my post.
> >>
> >
> > Integersting. We have some kind of set of privileges, required to
> > access the
> > object (let's say rows in table(s)), I thought if it is possible to
> > use
> > kind of "injection" of access control statement to SQL query for
> > extraction
> > 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 SecurityFilter. This simple example scheme
> assumes each document has an "owner" and only owners are allowed to
> see their documents and no others. By applying a SecurityFilter on a
> search, the results are constrained appropriately. This scheme is
> intentionally simplistic to show the possibilities. More commonly
> would be a situation with users and groups that need to be
> dynamically configurable - a Filter could still do this sort of
> thing, but how documents are associated with groups would need to be
> thoroughly conceived.
>
> Erik
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message