lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amir Kibbar <amir.kib...@tangram-soft.co.il>
Subject Re: [jira] Created: (LUCENE-487) Database as a lucene index target
Date Wed, 11 Jan 2006 19:45:19 GMT
Robert,

It seems that way. It's just that I tried to find something that does that
and just couldn't, so I've decided to write something myself.

I will certainly take a look now at compass framework's solution.

Amir

On 1/11/06, Robert Engels <rengels@ix.netcom.com> wrote:
>
> You are better off using the one that has already been contributed then.
> It
> uses JDBC and breaks the file into blocks. Much more efficient. Sorry to
> say
> but your solution/code is inferior to what already exists.
>
> -----Original Message-----
> From: amir.kibbar@gmail.com [mailto:amir.kibbar@gmail.com]On Behalf Of
> Amir Kibbar
> Sent: Wednesday, January 11, 2006 1:37 PM
> To: java-dev@lucene.apache.org; rengels@ix.netcom.com
> Subject: Re: [jira] Created: (LUCENE-487) Database as a lucene index
> target
>
>
> Robert,
>
> My solution is the latter. If it is possible to do it using blob seek, I
> will attempt to do it next.
>
> Amir
>
> On 1/11/06, Robert Engels <rengels@ix.netcom.com> wrote:
> >
> > Since no code has been posted, I'll just ask the question...
> >
> > Does your implementation use the Blob "seek" functions when reading and
> > writing, or does it read/write the blob in its entirety.
> >
> > If it is the latter, your solution is only acceptable for the smallest
> of
> > Lucene indexes. If it is the former, it would be interesting to see the
> > results using various db & drivers, as many JDBC blob impls do not
> support
> > this functionality, and read/write the blob completely behind the
> scenes.
> >
> > -----Original Message-----
> > From: Amir Kibbar (JIRA) [mailto:jira@apache.org]
> > Sent: Wednesday, January 11, 2006 12:35 PM
> > To: java-dev@lucene.apache.org
> > Subject: [jira] Created: (LUCENE-487) Database as a lucene index target
> >
> >
> > Database as a lucene index target
> > ---------------------------------
> >
> >          Key: LUCENE-487
> >          URL: http://issues.apache.org/jira/browse/LUCENE-487
> >      Project: Lucene - Java
> >         Type: New Feature
> >   Components: Store
> >     Versions: 1.9
> > Environment: MySql (version 4.1 an up), Oracle (version 8.1.7 and up)
> >     Reporter: Amir Kibbar
> >     Priority: Minor
> >
> >
> > I've written an extension for the Directory object called DBDirectory,
> > that allows you to read and write a Lucene index to a database instead
> of
> a
> > file system.
> >
> > This is done using blobs. Each blob represents a "file". Also, each blob
> > has a name which is equivalent to the filename and a prefix, which is
> > equivalent to a directory on a file system. This allows you to create
> > multiple Lucene indexes in a single database schema.
> >
> > The solution uses two tables:
> > LUCENE_INDEX - which holds the index files as blobs
> > LUCENE_LOCK - holds the different locks
> >
> > Attached is my proposed solution. This solution is still very basic, but
> > it does the job.
> > The solution supports Oracle and mysql
> >
> > To use this solution:
> >
> > 1. Place the files:
> > - DBDirectory in src/java/org/apache/lucene/store
> > - TestDBIndex in src/test/org/apache/lucene/index
> > - objects-mysql.sql in src/db
> > - objects-oracle.sql in src/db
> >
> > 2. Edit the parameters for the database connection in TestDBIndex
> >
> > 3. Create the database tables using the objects-mysql.sql script
> (assuming
> > you're using mysql)
> >
> > 4. Build Lucene
> >
> > 5. Run TestDBIndex with the database driver in the classpath
> >
> > I've tested the solution on mysql, but it *should* work on Oracle, I
> will
> > test that in a few days.
> >
> > Amir
> >
> > --
> > This message is automatically generated by JIRA.
> > -
> > If you think it was sent incorrectly contact one of the administrators:
> >    http://issues.apache.org/jira/secure/Administrators.jspa
> > -
> > For more information on JIRA, see:
> >    http://www.atlassian.com/software/jira
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: java-dev-unsubscribe@lucene.apache.org
> > For additional commands, e-mail: java-dev-help@lucene.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: java-dev-unsubscribe@lucene.apache.org
> > For additional commands, e-mail: java-dev-help@lucene.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-dev-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-dev-help@lucene.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message