Closed Thread Icon

Topic awaiting preservation: search keywords: database desgin suggestions... Pages that link to <a href="http://ozoneasylum.com/backlink?for=12401" title="Pages that link to Topic awaiting preservation: search keywords: database desgin suggestions..." rel="nofollow" >Topic awaiting preservation: search keywords: database desgin suggestions...\

 
Author Thread
lallous
Paranoid (IV) Inmate

From: Lebanon
Insane since: May 2001

posted posted 09-04-2002 09:58

I want to make a program that can search for a keyword and tell me what textfile has this keyword.

I have a bunch of docs:
doc1.txt, doc2.txt, doc3.txt

instead of inserting the whole content in the database as we usually do, i thought of this:

1. create a table 'keywords' such:
autonumber: id
char(20): keyword
2.write a program that extracts all the keywords(new keywords) from a given input and spit them in the keywords table
3.make another table 'textfiles'
autonumber: id
text: description
datetime: docdate
4. make another table 'textkeywords'
autonumber: id
number: textfile
number: keyword
5. make an interface to define textfiles (insert them into 'textfiles' tbl)
6.then parse all keywords (if any new keywords found, insert them into keywords table), otherwise add records into the textkeywords table that links a 'textfile' to a specific 'keyword'

now if i want to search for a keyword, I only select from the keywords table for the IDs of the matched keywords,
then query the textkeywords.keyword and pull all the textkeywords.textfile then query textfile.id to get full textfile information...

it might seem a hassle, but it is simple to implement...
but i was wondering if it is a good/fast way as i'm thinking.

all suggestions are welcome.



WarMage
Maniac (V) Mad Scientist

From: Rochester, New York, USA
Insane since: May 2000

posted posted 09-04-2002 15:44

This doesn't sound like a bad idea.

I think you could go with it. When I do it, it is very similar, except in my content table I add a keywords and description field which would be the feilds that are queried to find the correct data. However, you solution seems a bit more elegant in making the query far more effective on the server.

« BackwardsOnwards »

Show Forum Drop Down Menu