Full Text Indexing

[Mag Gam <ma...@gmail.com>]

Is there any news about full text indexing for Derby? We have been
looking at daffodil db, but we would really like to use apache-derby.

Re: Full Text Indexing

[Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>]

I don't think I'll have a good single table example, as I use Lucene as 
core part of my project (it's at my "micro-kernel" project 
infra-structure - that is multi-database driven).

What I could point you is that I use OJB and/or Hibernate for 
persistence, and between my application and OJB/Hibernate I have a layer 
for persistence (like a Broker layer) that detects (from some 
configuration tables) what objects need to be indexed during 
insert/update/delete operations, and uses the indexes for search when 
selecting data from database.

Everything needed to be indexed, I must put the primary key of the table 
- always - for referencing when loading data from database. So, the 
operation isn't transparent, but is almost easy.

BUT, it will require you work with an database abstraction or broker 
layer - some extra effort sometimes not applyable to simpler projects (I 
really don't mind how complex is your app, neither if this extra cost 
could be viable).

Maybe I could create an independent infra-structure for this model of 
work, that is applyable to generic projects (with some functions and 
triggers doing hard job) but I'll not have time to contribute this 
before second quarter of 2006. Sorry.


Edson Richter



Mag Gam escreveu:

>Edison:
>
>Yes I have been **trying** to get Lucene to work, and it seems a lot
>more programming is needed.
>
>As usual, do you have a good example for a single table?
>
>
>
>On 10/15/05, Edson Carlos Ericksson Richter
><ed...@mgrinformatica.com.br> wrote:
>  
>
>>I have being using Apache Lucene for a while. Works like a charm, but
>>need some extra programming to work.
>>
>>Richter
>>
>>Mag Gam escreveu:
>>
>>    
>>
>>>Is there any news about full text indexing for Derby? We have been
>>>looking at daffodil db, but we would really like to use apache-derby.
>>>
>>>
>>>      
>>>
>>
>>
>>    
>>

Re: Full Text Indexing

[Mag Gam <ma...@gmail.com>]

Edison:

Yes I have been **trying** to get Lucene to work, and it seems a lot
more programming is needed.

As usual, do you have a good example for a single table?



On 10/15/05, Edson Carlos Ericksson Richter
<ed...@mgrinformatica.com.br> wrote:
> I have being using Apache Lucene for a while. Works like a charm, but
> need some extra programming to work.
>
> Richter
>
> Mag Gam escreveu:
>
> >Is there any news about full text indexing for Derby? We have been
> >looking at daffodil db, but we would really like to use apache-derby.
> >
> >
>
>
>
>

Re: Full Text Indexing

[Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>]

I have being using Apache Lucene for a while. Works like a charm, but 
need some extra programming to work.

Richter

Mag Gam escreveu:

>Is there any news about full text indexing for Derby? We have been
>looking at daffodil db, but we would really like to use apache-derby.
>  
>