Hi all,
i am new here and from Germany, so please be patient with my english
We try to implement a fulltext search with a ranking but we are not able to set Oracle Text to our needs. So i will discribe what we want to do and it would be great if u could tell us, if this is possible and how.
There are some tables like:
Table People
ID Givenname Surename
------- -------------------- ----------------
1 Hans Meier
2 Frauke Huber
3 Werner Krause-Meier
Table Adress
ID Street Street_Number
------- -------------------- ----------------
1 Hauptstr 4
2 Lukas-Meier-Str 23
3 Bahnhofstr 11
Table People_Adress
People_ID Street_ID
------------- --------------
1 2
2 1
3 3
Now we want to search "Meier".
The result should be like:
Ranking Result
------- -------------------------
10 Hans Meier Lukas-Meier-Str 23 // ranking 10 because "Meier" is found in People and Adress
5 Werner Krause-Meier Bahnhofstr 11 // ranking 6 because "Meier" is only found in People
In real, there are more tables and columns per table and of course dependencies. Before we get deeper, we need to know if this is possible with Oracle Text.