Db design for a flexible search

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 Received on Mon Dec 19 2005 - 16:48:32 CST