Re: RDBMS schema (MySQL)

Hi,

Thursday, August 29, 2002, 10:50:29 PM, Brian K. Hughes wrote:
> I'm a developer for Acoustica, whose CD Burner product is due to be
> released this month with freedb support.  Here's a question one of you may 
> be able to answer that's sort of related to the schema discussion (if not, 
> feel free to tell me to go away and I'll repost with a different subject 
> *grin*).

Well, it doesn't really fit in here, but anyway...

> I pull a disc ID from the TOC of a CD and go query freedb with it.  The DB 
> gives me two possible choices for the album... both use the same artist, 
> title, and genre (which is confusing to the user to begin with), but each 
> has a different disc ID and none of them match the original disc ID. If
> the search is based on the disc ID, how is it that A) I'm finding other 
> records that do not have my disc ID, and B) why do none of the results 
> returned have my disc ID?

The magic of fuzzy matching ;)
The server software includes a method for finding inexact matches.
So if the server doesn't find an exact match, it tries to find inexact
matches and if it finds some, it gives you a list of the possible
matches (return-code 211).

- Joerg