469,645 Members | 1,551 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

Search across multiple sources


I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider while in another database I have a lot of user entered content. Ideally I'd like to search across both databases via a single web-based search form.

The obvious way is to create a tsearch index/table in both databases and then to connect to each one in turn and to merge the results together but that doesn't seem like the best solution and potentially there could be issues with ranking and so on.

Is it possible to create a single search database which can store search data from a number of different databases. This is all on the same server of course.

Another option I looked at was to use an external search tool lke mnogosearch (http://www.mnogosearch.ru/doc/msearc...xing.html#htdb) although since I've used tsearch elsewhere it would be nice to use it here as well.

Cheers,
Graeme

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 22 '05 #1
2 1772
Why not use schema and single search table contains indices from
different schemes (use trigger to update search table)

On Sun, 1 Feb 2004, Merrall, Graeme wrote:

I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider while in another database I have a lot of user entered content. Ideally I'd like to search across both databases via a single web-based search form.

The obvious way is to create a tsearch index/table in both databases and then to connect to each one in turn and to merge the results together but that doesn't seem like the best solution and potentially there could be issues with ranking and so on.

Is it possible to create a single search database which can store search data from a number of different databases. This is all on the same server of course.

Another option I looked at was to use an external search tool lke mnogosearch (http://www.mnogosearch.ru/doc/msearc...xing.html#htdb) although since I've used tsearch elsewhere it would be nice to use it here as well.

Cheers,
Graeme

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Regards,
Oleg
__________________________________________________ ___________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #2
Merrall, Graeme wrote:
I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider while in another database I have a lot of user entered content. Ideally I'd like to search across both databases via a single web-based search form.

The obvious way is to create a tsearch index/table in both databases and then to connect to each one in turn and to merge the results together but that doesn't seem like the best solution and potentially there could be issues with ranking and so on.

Is it possible to create a single search database which can store search data from a number of different databases. This is all on the same server of course.

Another option I looked at was to use an external search tool lke mnogosearch (http://www.mnogosearch.ru/doc/msearc...xing.html#htdb) although since I've used tsearch elsewhere it would be nice to use it here as well.

Cheers,
Graeme

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


I don't know if it works, just a thought:

You can examine, wether contrib/dblink works in conjunction with
tsearch[2]. If this is runnable, you can create a "search database" with
dblink'ed search queries/views over your data store.

Bernd
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Lefteris | last post: by
83 posts views Thread by D. Dante Lorenso | last post: by
2 posts views Thread by pengbsam | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.