[Sigia-l] The Horror of Access Database

[Listera]

"karl fast" wrote:

> The point was that an RDBMS doesn't use inverted indexes, unlike a
> full-text system. And SQL isn't designed for doing these types of
> queries.

Yes and no. A database, in my book anyway, ought to be a datastore and not
much else. The *application* logic belongs in the application server and the
language with which you get at the data shouldn't make that much of a
difference. In that sense, there's nothing that prevents SQL or any database
(think storage) from handling full-text indexing.
 
> This makes it difficult to build a search interface to a relational
> database so it functions like a full-text web search engine.

With sets, it's a piece of cake, as I have previously explained here. You do
have to go through a layer of abstraction and conversion.
 
> These problems become simpler with SQL Server or Oracle or another
> high end RDBMS that supports full-text indexes. Access, however,
> doesn't have this. IIRC the original post was talking about Access.

Well, yes, I'm assuming a modicum of programming capability here.
 
> You're right, of course, that you can make it work. I was just
> pointing out that the the problems here run deeper than the
> interface.

It seems to.

Best,

Ziya