Re: Search Engine
From: stu <smcgouga_at_nospam.co.uk>
Date: Wed, 6 Nov 2002 09:50:22 -0000
Message-ID: <aqaom4$dmu$1$8300dec7_at_news.demon.co.uk>
Date: Wed, 6 Nov 2002 09:50:22 -0000
Message-ID: <aqaom4$dmu$1$8300dec7_at_news.demon.co.uk>
Reffering to http://www.databaseanswers.com/data_models/search_engine.htm
Why duplicate the keyword field on the url_keyword table? I thought you should have an ID (counter) field on keywords table as a primary key. This keyword_id would then be used in url_keywords primary key.
I can see advantages in this design over mine: If you key URL_Keywords by keyword then Url_ID searching would be faster because we do not need to join Key_words table. But then whats the point in having the key_words table?
Cheers
Stu
Received on Wed Nov 06 2002 - 10:50:22 CET