Background:
I've written a script that checks, for a given list of domain names, which ones are made up of two dictionary words. The script builds the words from the letters, and determines the word length, and checks the appropriate table (which only contains words of that length) in my WORDS db to see if it's a word.
Intent:
What I want to do is build a database of keyword value when it comes to domain sales. The script should be able to determine trends in prices, and which words are "hot." The user should be able to narrow the results by date, word length, original domain extension (.com, .net).
Question:
After my script determines the keywords that make up the name, what would be the best database setup to have to meet my intent?
The only thing I can think of is (for example domains: DomainName.com, DomainSeller.net):
db: Keywords
table: first position keywords
(keyword)(length)(keyword that was in second position)(tld)(price)(date)
| domain | 6 | name,seller | .com,net | $100000,$1500 | 1/2/2005,3/5/2007 |
So basically, arrays within the rows.
I just don't see how I'd be able to retrieve the data to meet my intent. Let's say I wanted to find the 5 keywords with the highest average price in the past month. Would the database setup above be able to be searched to determine that?
It's always so hard to balance how much to type, since I don't want people to have to read through an essay in order to help me. Let me know if I can explain anything in greater detail. Thanks!
