On Wed, 24 May 2006, David J. Fiander wrote: > Since the collection of ISBNs can be treated as an equivalence class, > can't any arbitrary member of the class be designated as the group > identifier? This eliminates the need to create a synthetic id, and it > means that, for singular items, there's no need to create a separate > group id. I can see two drawbacks: 1) It could be confusing. If someone doesn't read the documentation properly they could be mislead to believe that the table is an un-normalized one. 2) One could optimize by only storing those numbers that have more than one in a group. From Thom's description it seems like that is what xISBN does. (I could be wrong here, going from memory). Problem of course if you don't store the 1 to 1 mapping is that you don't know if there really is no known relationships or if that particular isbn hasn't been examined for any relationships with other material yet. Of course, even if you examined it there might be a relationship that hasn't been caught, so the difference might not be that huge. In either case you could say it is really saying we don't know of any relation with this isbn and other materials. Jon Gorman