Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Lucene: Java-User

Re: JDBC access to a Lucene index

 

 

Lucene java-user RSS feed   Index | Next | Previous | View Threaded


jukka.zitting at gmail

Oct 17, 2009, 12:59 AM

Post #1 of 3 (511 views)
Permalink
Re: JDBC access to a Lucene index

Hi,

On Fri, Oct 16, 2009 at 9:12 PM, Grant Ingersoll <gsingers [at] apache> wrote:
> I'm not aware of any, but you might get more mileage asking on java-user.

You're right, poor original choice of list from me.

java-users@, here's my question from java-dev@:

Some while ago I implemented a simple JDBC to JCR bridge [1] that
allows one to query a JCR repository from any JDBC client, most
notably various reporting tools.

Now I'm wondering if something similar already exists for a normal
Lucene index. Something that would treat your entire index as one huge
table (or perhaps a set of tables based on some document type field)
and would allow you to use simple SQL SELECTs to query data.

Any pointers would be welcome. If this hasn't already been done, would
there be interest in such a JDBC driver for Lucene?

[1] http://dev.day.com/microsling/content/blogs/main/jdbc2jcr.html

BR,

Jukka Zitting

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
For additional commands, e-mail: java-user-help [at] lucene


marcelo.ochoa at gmail

Oct 19, 2009, 1:43 PM

Post #2 of 3 (467 views)
Permalink
Re: JDBC access to a Lucene index [In reply to]

Hi Zukka:
This is similar approach to Lucene Domain Index:
http://docs.google.com/Doc?id=ddgw7sjp_54fgj9kg
But Lucene Domain Index is an specific implementation for Oracle
Databases 10g/11g which is integrated through the ODCI API and
replacing the Lucene file system storage by a BLOB storage.
Basically you defines Index on table columns and then query Lucene
Index by using a new operator:
lcontains(col,lucene-query,op)
two new ancillary operators:
lscore(op)
lhighlight(op)
and some pipeline functions which provides highlighting, facets, and so on.
But isn't a new JDBC driver implementation, you query Lucene
Domain Index using default Oracle's JDBC drivers.
Best regards, Marcelo.
On Sat, Oct 17, 2009 at 4:59 AM, Jukka Zitting <jukka.zitting [at] gmail> wrote:
> Hi,
>
> On Fri, Oct 16, 2009 at 9:12 PM, Grant Ingersoll <gsingers [at] apache> wrote:
>> I'm not aware of any, but you might get more mileage asking on java-user.
>
> You're right, poor original choice of list from me.
>
> java-users@, here's my question from java-dev@:
>
> Some while ago I implemented a simple JDBC to JCR bridge [1] that
> allows one to query a JCR repository from any JDBC client, most
> notably various reporting tools.
>
> Now I'm wondering if something similar already exists for a normal
> Lucene index. Something that would treat your entire index as one huge
> table (or perhaps a set of tables based on some document type field)
> and would allow you to use simple SQL SELECTs to query data.
>
> Any pointers would be welcome. If this hasn't already been done, would
> there be interest in such a JDBC driver for Lucene?
>
> [1] http://dev.day.com/microsling/content/blogs/main/jdbc2jcr.html
>
> BR,
>
> Jukka Zitting
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
> For additional commands, e-mail: java-user-help [at] lucene
>
>



--
Marcelo F. Ochoa
http://marceloochoa.blogspot.com/
http://marcelo.ochoa.googlepages.com/home
______________
Want to integrate Lucene and Oracle?
http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html
Is Oracle 11g REST ready?
http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
For additional commands, e-mail: java-user-help [at] lucene


jukka.zitting at gmail

Oct 21, 2009, 3:26 PM

Post #3 of 3 (450 views)
Permalink
Re: JDBC access to a Lucene index [In reply to]

Hi,

On Mon, Oct 19, 2009 at 10:43 PM, Marcelo Ochoa <marcelo.ochoa [at] gmail> wrote:
>   This is similar approach to Lucene Domain Index:
> http://docs.google.com/Doc?id=ddgw7sjp_54fgj9kg
>    But Lucene Domain Index is an specific implementation for Oracle
> Databases 10g/11g which is integrated through the ODCI API and
> replacing the Lucene file system storage by a BLOB storage.

Thanks for the pointer! Lucene Domain Index is not exactly what I'm
looking for, but it's seems close enough for me to at least borrow
some ideas from it.

BR,

Jukka Zitting

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
For additional commands, e-mail: java-user-help [at] lucene

Lucene java-user RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.