We have a quite large ArcSDE (~120 versioned feature classes & tables, 1M-3M records) which has Oracle or SQL underlying DBMS. This SDE is exposed through a MapService and we use ArcGIS JS API to display layers.
Now we'd like to have full-text search against set of feature classes and tables in the SDE. ESRI manuals say we should set up XML columns to enable search through documents. But I really don't understand how it helps.
So the questions are:
- Is ArcSDE capable of full-text searching?
- And if yes, is there any services in ArcGIS Server or whatever which can help us with this?
Firstly, I'd like to say that I little bit messed up terms. I thought that ArcSDE==SDE==geodatabase. However It's different things and I actually meant geodatabase.
Secondly, here's the solution we've came up with: There's Find task available on ArcGIS Map Service out of box, which does text search against given layers. It performs unexpectetly fast and we're going to use it. If performance is unsatisfactory we'll enable Lucene to cache queries. Hope this solution will work. I'll report the result here as soon as we implement this approach.