Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (asf.osuosl.org: domain of chris.lu@gmail.com designates
 72.14.204.194 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=by6xNxgWET0CQHag64qDsvlDfDdCAeo5h/Re6AXIX/5PtdUJzLw58XX+qV5ZYG3b35j/AgmCsDyAByNgc65yOXtEmM/bvdrwWQhFFs/rsl1Q7c0e9uPV61YQOp40b0SjDU+bvQnsqTD5+Lp7ZkK+5GQg9tyg/ubXW7IGadpOv3M=
Message-ID: <6e3ae6310510241050h5373f77fx81ff125d42cba386@mail.gmail.com>
Date: Mon, 24 Oct 2005 10:50:08 -0700
From: Chris Lu <chris.lu@gmail.com>
To: java-user@lucene.apache.org
Subject: Re: lucene and databases
In-Reply-To: <435D1A31.4070002@sun.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <435D1A31.4070002@sun.com>

JDBCDirectory doesn't help you to index content in rdms.
It just stores the lucene index into rdms. This approach will be
slower than file system based approach.

For your first question, "Indexing content that is stored in a dbms",
you can take a look at DBSight. It's a generic tool to easily extract
content from database and build an index, which seems simple, but
behind the scene, it does more than that, including, multi-threaded
extraction and search, multi index support, template-based search
result, scheduled index updating, web-based control and configuration,
remote index replication, etc.

Chris Lu
------------------------------
Lucene Full-Text Search on Any Database
http://www.DBSight.net


On 10/24/05, Rick Hillegas <Richard.Hillegas@sun.com> wrote:
> Thanks to Yonik for replying to my last question about queries and filter=
s.
>
> Now I have another issue. I would appreciate any pointers to attempts to
> integrate Lucene with databases. There's a tantalizing reference to a
> class called JDBCDirectory mentioned at
> http://wiki.apache.org/jakarta-lucene/LatestNews. However, my browser
> times out trying to access the follow-up link
> http://ppinew.mnis.com/jdbcdirectory. An email thread
> (http://www.mail-archive.com/java-user@lucene.apache.org/msg01036.html)
> makes me hope that this class helps an application index a body of
> documents stored in a relational database. But this class, perhaps a
> cousin of FSDirectory and RAMDirectory, doesn't seem to be part of
> Lucene proper.
>
> In any event, I would appreciate pointers to people's experience
> integrating Lucene with relational databases. I realize this is a very
> broad question. It sweeps up topics like the following:
>
> o Indexing content that is stored in a dbms
>
> o Wrapping filters around the results of sql queries
>
> o Integrating Lucene query syntax with sql query syntax
>
> o Practical tips about when to expose information as a Lucene field vs.
> when to expose that  information as a column in a relational table
>
> Thanks,
> -Rick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org