| Intermedia vs Multilingual Data [message #76046] |
Thu, 22 May 2003 13:26 |
Kiran G Kumar
Messages: 5
Registered: April 2003
|
Junior Member |
|
|
Hello
In our oracle DB, we have a table which has a column, that keeps Multilingual Data (around
21 languages including Japanese, Chinese ..etc). Now we want to build a SEARCH feature in our web application, which will pick up the records from this table based on this field.
We want to use Oracle Text (formally Intermedia) features for this. I would to know what is the best way of using this, and what are all the things required to do to use this.
We have Oracle Intermedia feature is installed ( I mean I can create context indexes)
My questions are
(1) Which type of Index should be created on this column ? ( I heard that context index, catalog index and some other indexes.., so guide me which one is the best in my case)
(2) This field will ve updates/insert operations (I means users will insert new records/update existing record).. So, do these intermedia indexes will automatically updated
so that I can fetch these new records ? ( I mean if any updates/inserts happen in this field, by querying on this column will I get these records )
(3) Is there any maintainance activity required when we use this intermedia indexes ?
(4) Please let me know if there any pros and cons of using this intermedia ?
Appreciate your help.
Thanks for your time
Kiran
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
