Henrik Ræder schrieb:
Hi
(First post - hope it's an appropriate place)
I've been implementing a database of a few MB of text (indexing
magazines) in SQLite, and so far have found it to work really well.
Now my boss, who has a wonderfully creative mind, asks me to implement a
full-text search function which is not the usual simplistic 'found' /
'not found', but more Google-style where a graded list of results is
returned.
For example, in a search for "MP3 Player", results with the phrases next
to each other would get a high rating, as would records with a high
occurance of the keywords.
This falls outside the usual scope of SQL, but would still seem a
relatively common problem to tackle.
Any ideas (pointers) how to tackle this?
You have come to the right place.
Take a closer look at:
http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex
Michael
--
Michael Schlenker
Software Engineer
CONTACT Software GmbH Tel.: +49 (421) 20153-80
Wiener Straße 1-3 Fax: +49 (421) 20153-41
28359 Bremen
http://www.contact.de/ E-Mail: [EMAIL PROTECTED]
Sitz der Gesellschaft: Bremen | Geschäftsführer: Karl Heinz Zachries
Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------