Re: SAPDB text indexing support (from user list)

Richard Barrington wrote:
> The text search issue is one that comes up fairly often, so is the API
> interface that it uses publishable? Perhaps it would be possible to
> produce/use a GPL'd text search library if the hooks are already in
> place, and were documented?

I don't think you need the API to start.
- iterate through the table
- create an index that maps search words to the values of the key columns
- possibly use the content of other columns as a hint which parser to 
use, which language specific stop words to skip etc
- be sure to keep the index in the database, otherwise, transaction 
handling will be a major headache
- add methods to update the index for added, deleted and changed rows, 
these methods are later to be called by triggers

Except for the very last step, everything can be done using the current 
interfaces.

The extended stored procedures and triggers will support JDBC, ODBC and 
Python in the first release.

Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
[email protected]
http://www.sapdb.org