Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Freesearch - How to.
We are building a web-application on top on an already existing solution.
The web-application will access the database using information-Server and
ASP. In the WEB-application we want to provide the possibility to perform
free-search among information in a number of database-fields in the
database. Currently we are thinking about using views as the interface
between the database, and the web application. The search-view are planned
to be defined as something like:
create view somesearchview as
select a.id1field1 ID1,a.idfield2 ID2,......,a.idfieldN IDN,,a.idtype Type
a.attrval1 || a.attrval2 || ..... || a.attrvalN || b.attrval1.... ||
b.attrvalN Data
where
A and B is in this example the tables and the ID-fields uniquely identify the records, the actual search will be performed using the Data-column.
We do see that performance may be a problem, and are therefore looking into possible solution in Oracle 7.3.x and 8.0.5.
Information in the database is dynamic, and changes must immediately reflected in any index-trees and duplicate tables. We are assuming that Microsoft Index-server probably not will be of much help in this case. Received on Wed Oct 13 1999 - 08:09:33 CDT