You are viewing a plain text version of this content. The canonical link for it is here.
Posted to java-user@lucene.apache.org by "J.Zhu" <J....@open.ac.uk> on 2007/01/06 20:52:23 UTC
Similarity for Span and Boolean query
Hi, all,
The equation for similarity is given on this web page:
http://lucene.apache.org/java/docs/api/org/apache/lucene/search/Similari
ty.html
I would like to know what are the equations for similarity if the query
is a span or boolean query.
Jianhan
Re: Lucene Index of Oracle RDBMS
Posted by Chris Lu <ch...@gmail.com>.
You can try DBSight. It's using a lucene+database+website domain
specific approach to facilitate rapid index design. It's used by
Computer Science Corporation for some military information project,
and websites like www.twenga.com.
--
Chris Lu
-------------------------
Instant Full-Text Search On Any Database/Application
site: http://www.dbsight.net
demo: http://search.dbsight.com
On 1/8/07, Aronin, Maxim <ar...@bah.com> wrote:
> Hello,
>
> Does anyone know of instances where Lucene was used to index Oracle
> RDBMS at a recognizable company or a government agency? Powered by
> Lucene list did not seem to have any such examples
>
> Thanks for your help!
>
> Max
>
> ---------------------------------------------------------------------
> 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
Re: Lucene Index of Oracle RDBMS
Posted by Marcelo Ochoa <ma...@gmail.com>.
Max:
The code of the Oracle-Lucene integration is in a very early stage,
see the first patch released (22/Nov/06 03:44 PM), but it uses the
lucene-2.0.0 core API which is very stable.
I don't know if somebody is using the code, but I testing it a lot
with small and large test suites and seem to be stable and scalable.
If you want to test the code with large datasets, I can help you to
put the code running in an Oracle 10gR2+
Best regards, Marcelo.
On 1/8/07, Aronin, Maxim <ar...@bah.com> wrote:
> Hello Marcelo,
>
> Thanks for the details of your implementation. I was wondering if you
> could share where this implementation is taking place. Also, are you
> aware of any implementations at companies or government agencies where
> Lucene was used to index Oracle.
>
> My client is thinking about implementing Lucene index instead of Oracle
> Text, but would like to see a list of recognizable companies/agencies
> where this has been done before. Any additional suggestions for where I
> can search for this information would be appreciated.
>
> Again thanks for your help,
>
> V/R,
>
> Max Aronin
>
> -----Original Message-----
> From: Marcelo Ochoa [mailto:marcelo.ochoa@gmail.com]
> Sent: Monday, January 08, 2007 8:22 AM
> To: java-user@lucene.apache.org
> Subject: Re: Lucene Index of Oracle RDBMS
>
> Hi Max:
> I am working in a Oracle-Lucene integration, see patch:
> http://issues.apache.org/jira/browse/LUCENE-724
> Today I'll upload a latest development release which includes several
> performance enhancement and new methods to integrate with the Oracle
> Data Cartridge API without using data information which is faster than
> the previous one.
> Unlike other Lucene data store implementation using BLOB, the
> OJVMDirectory implementation runs inside the Oracle embedded virtual
> machine. This architecture decision reduce network round trip and data
> marshaling because it runs in the same memory space as the Oracle data.
> Another feature is a Data Cartridge integration which provides Lucene
> as a new Domain Index for the Oracle Databases like the Oracle Text's
> ctxsys.context index, it means that you can index columns of type
> VARCHAR2, CLOB or XMLType directly by using a simple "create index"
> command. All DML operations on the base table automatically update the
> Lucene Index.
> Also two new operators are provided to the SQL Engine,
> lcontains(column_name,lucene_query_parser_syntax,corr_id) and
> lscore(corr_id), these two operators can be used inside or outside the
> SQL where.
> Best regards, Marcelo.
>
> On 1/8/07, Aronin, Maxim <ar...@bah.com> wrote:
> > Hello,
> >
> > Does anyone know of instances where Lucene was used to index Oracle
> > RDBMS at a recognizable company or a government agency? Powered by
> > Lucene list did not seem to have any such examples
> >
> > Thanks for your help!
> >
> > Max
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> > For additional commands, e-mail: java-user-help@lucene.apache.org
> >
> >
>
>
> --
> Marcelo F. Ochoa
> http://marcelo.ochoa.googlepages.com/home
> ______________
> Do you Know DBPrism? Look @ DB Prism's Web Site
> http://www.dbprism.com.ar/index.html
> More info?
> Chapter 17 of the book "Programming the Oracle Database using Java & Web
> Services"
> http://www.amazon.com/gp/product/1555583296/
> Chapter 21 of the book "Professional XML Databases" - Wrox Press
> http://www.amazon.com/gp/product/1861003587/
> Chapter 8 of the book "Oracle & Open Source" - O'Reilly
> http://www.oreilly.com/catalog/oracleopen/
>
> ---------------------------------------------------------------------
> 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
>
>
--
Marcelo F. Ochoa
http://marcelo.ochoa.googlepages.com/home
______________
Do you Know DBPrism? Look @ DB Prism's Web Site
http://www.dbprism.com.ar/index.html
More info?
Chapter 17 of the book "Programming the Oracle Database using Java &
Web Services"
http://www.amazon.com/gp/product/1555583296/
Chapter 21 of the book "Professional XML Databases" - Wrox Press
http://www.amazon.com/gp/product/1861003587/
Chapter 8 of the book "Oracle & Open Source" - O'Reilly
http://www.oreilly.com/catalog/oracleopen/
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
RE: Lucene Index of Oracle RDBMS
Posted by "Aronin, Maxim" <ar...@bah.com>.
Hello Marcelo,
Thanks for the details of your implementation. I was wondering if you
could share where this implementation is taking place. Also, are you
aware of any implementations at companies or government agencies where
Lucene was used to index Oracle.
My client is thinking about implementing Lucene index instead of Oracle
Text, but would like to see a list of recognizable companies/agencies
where this has been done before. Any additional suggestions for where I
can search for this information would be appreciated.
Again thanks for your help,
V/R,
Max Aronin
-----Original Message-----
From: Marcelo Ochoa [mailto:marcelo.ochoa@gmail.com]
Sent: Monday, January 08, 2007 8:22 AM
To: java-user@lucene.apache.org
Subject: Re: Lucene Index of Oracle RDBMS
Hi Max:
I am working in a Oracle-Lucene integration, see patch:
http://issues.apache.org/jira/browse/LUCENE-724
Today I'll upload a latest development release which includes several
performance enhancement and new methods to integrate with the Oracle
Data Cartridge API without using data information which is faster than
the previous one.
Unlike other Lucene data store implementation using BLOB, the
OJVMDirectory implementation runs inside the Oracle embedded virtual
machine. This architecture decision reduce network round trip and data
marshaling because it runs in the same memory space as the Oracle data.
Another feature is a Data Cartridge integration which provides Lucene
as a new Domain Index for the Oracle Databases like the Oracle Text's
ctxsys.context index, it means that you can index columns of type
VARCHAR2, CLOB or XMLType directly by using a simple "create index"
command. All DML operations on the base table automatically update the
Lucene Index.
Also two new operators are provided to the SQL Engine,
lcontains(column_name,lucene_query_parser_syntax,corr_id) and
lscore(corr_id), these two operators can be used inside or outside the
SQL where.
Best regards, Marcelo.
On 1/8/07, Aronin, Maxim <ar...@bah.com> wrote:
> Hello,
>
> Does anyone know of instances where Lucene was used to index Oracle
> RDBMS at a recognizable company or a government agency? Powered by
> Lucene list did not seem to have any such examples
>
> Thanks for your help!
>
> Max
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>
--
Marcelo F. Ochoa
http://marcelo.ochoa.googlepages.com/home
______________
Do you Know DBPrism? Look @ DB Prism's Web Site
http://www.dbprism.com.ar/index.html
More info?
Chapter 17 of the book "Programming the Oracle Database using Java & Web
Services"
http://www.amazon.com/gp/product/1555583296/
Chapter 21 of the book "Professional XML Databases" - Wrox Press
http://www.amazon.com/gp/product/1861003587/
Chapter 8 of the book "Oracle & Open Source" - O'Reilly
http://www.oreilly.com/catalog/oracleopen/
---------------------------------------------------------------------
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
Re: Lucene Index of Oracle RDBMS
Posted by Marcelo Ochoa <ma...@gmail.com>.
Hi Max:
I am working in a Oracle-Lucene integration, see patch:
http://issues.apache.org/jira/browse/LUCENE-724
Today I'll upload a latest development release which includes
several performance enhancement and new methods to integrate with the
Oracle Data Cartridge API without using data information which is
faster than the previous one.
Unlike other Lucene data store implementation using BLOB, the
OJVMDirectory implementation runs inside the Oracle embedded virtual
machine. This architecture decision reduce network round trip and data
marshaling because it runs in the same memory space as the Oracle
data.
Another feature is a Data Cartridge integration which provides
Lucene as a new Domain Index for the Oracle Databases like the Oracle
Text's ctxsys.context index, it means that you can index columns of
type VARCHAR2, CLOB or XMLType directly by using a simple "create
index" command. All DML operations on the base table automatically
update the Lucene Index.
Also two new operators are provided to the SQL Engine,
lcontains(column_name,lucene_query_parser_syntax,corr_id) and
lscore(corr_id), these two operators can be used inside or outside the
SQL where.
Best regards, Marcelo.
On 1/8/07, Aronin, Maxim <ar...@bah.com> wrote:
> Hello,
>
> Does anyone know of instances where Lucene was used to index Oracle
> RDBMS at a recognizable company or a government agency? Powered by
> Lucene list did not seem to have any such examples
>
> Thanks for your help!
>
> Max
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>
--
Marcelo F. Ochoa
http://marcelo.ochoa.googlepages.com/home
______________
Do you Know DBPrism? Look @ DB Prism's Web Site
http://www.dbprism.com.ar/index.html
More info?
Chapter 17 of the book "Programming the Oracle Database using Java &
Web Services"
http://www.amazon.com/gp/product/1555583296/
Chapter 21 of the book "Professional XML Databases" - Wrox Press
http://www.amazon.com/gp/product/1861003587/
Chapter 8 of the book "Oracle & Open Source" - O'Reilly
http://www.oreilly.com/catalog/oracleopen/
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: Lucene Index of Oracle RDBMS
Posted by "N. Hira" <nh...@cognocys.com>.
Max,
We use a (customized version of) Lucene as part of our Cognocys IAM
product, which is also available with Oracle RDBMS.
I can tell you that the software is used at Medtronic, a global medical
technology company.
-h
---------------------------------------------------------------------------
Hira, N.R.
Solutions Architect
Cognocys, Inc.
On Mon, 2007-01-08 at 07:55 -0500, Aronin, Maxim wrote:
> Hello,
>
> Does anyone know of instances where Lucene was used to index Oracle
> RDBMS at a recognizable company or a government agency? Powered by
> Lucene list did not seem to have any such examples
>
> Thanks for your help!
>
> Max
>
> ---------------------------------------------------------------------
> 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
Lucene Index of Oracle RDBMS
Posted by "Aronin, Maxim" <ar...@bah.com>.
Hello,
Does anyone know of instances where Lucene was used to index Oracle
RDBMS at a recognizable company or a government agency? Powered by
Lucene list did not seem to have any such examples
Thanks for your help!
Max
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: Similarity for Span and Boolean query
Posted by Chris Hostetter <ho...@fucit.org>.
: The equation for similarity is given on this web page:
: http://lucene.apache.org/java/docs/api/org/apache/lucene/search/Similari
: ty.html
:
: I would like to know what are the equations for similarity if the query
: is a span or boolean query.
That equation does cover BooleanQueries -- the "coord" factor is a
BooleanQuery concept -- strictly speaking that equation describes the
basics of a boolean query containing multiple term queries.
beyond that, the calculations can get a little hard to discribe in generic
equations -- the best way to understand the score calculations for any of
the other query types (including the Span queries) is to look at the
"Explanation.toString()" output for a query on a matching document -- and
consult the code for the corisponding Scorer class to see if there are any
special cases you might not be noticing becuase of the particular
query/doc explanation you are looking at (ie: query boosts, the coord
factor on a boolean query, etc...)
-Hoss
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org