Forum OpenACS Q&A: Search proposal for OpenACS/Oracle?

Collapse
1: Search proposal for OpenACS/Oracle?
Posted by Gregor Obernosterer on 11/18/02 04:31 PM
Does anybody know/have experience with a site-wide (granularity) search engine that indexes Oracle and works with OpenACS?
Collapse
2: Re: Search proposal for OpenACS/Oracle? (response to 1)
Posted by Tilmann Singer on 11/18/02 11:45 PM
Could you be more specific? What do you mean by granularity - are you looking for a solution that allows for searches within specific acs_objects, e.g. only forums postings?

There is of course the old site-wide-search package that uses oracle intermedia, and there is the new search package, which unfortunately only works with postgresql yet - until someone implements the intermedia-driver service contract.

Collapse
3: Re: Search proposal for OpenACS/Oracle? (response to 1)
Posted by Gregor Obernosterer on 11/19/02 03:52 PM
... so that the search result(s) the user gets back for a search item are only items he/she has permission to look at.
Collapse
4: Re: Search proposal for OpenACS/Oracle? (response to 1)
Posted by Peter Marklund on 11/19/02 04:45 PM
Gregor,
Intermedia doesn't provide any permissioning AFAIK. However, in the client projects I worked on at aD we used Intermedia and for permissioning we used the object permissions that OpenACS provide.

We ended up with a SQL statement that selects ACS objects that have an intermedia index match (we used the contains stored procedure in a where clause) and for permissioning we added a where clause with the permission_p stored procedure.

In the ShareNet system we built an advanced search that allowed you to filter objects on their ratings, their modification and creation date, and their categorization. As a bonus Intermedia allows you to check for similar spelling (fuzzy matching).