Db design for a flexible search
Date: 19 Dec 2005 14:48:32 -0800
Message-ID: <1135032512.051256.184120_at_f14g2000cwb.googlegroups.com>
Hello,
I don't know if this is the appropiate newsgroup for this post, but
it's the most related one I could find. Please advise if it isn't.
I'm building a database containing music data, basically artist and
tracks. For example, a record might be "14369, The Beatles, Help",
where the first number is an ID key. I might later add things like
albums, but it doesn't make a difference in this issue. The problem is
that these names are often unusual, and I want to be able to build a
search engine that is capable of overcoming this and displaying
relevant results. For example, there's a song named "A.D.I.D.A.S.", and
many people are likely to search for just "adidas". Or names like
Beyoncé, P!nk, and such. I can see ways to overcome accented
characters rather easily, but other cases are tougher. What would be
the correct approach to this? I was thinking of adding an extra
field(s) that would contain keywords that people are likely to search.
Or is there a more automated way to solve this things?
Any comment or idea is greatly appreciated. Thanks!
Diego