Quoting Dave Caroline <[email protected]>: > Picking one author as lead is bending the data to fit the schema, a > mistake in my opinion, they may be equal. > Often there is a lead author, which can change with edition an example is > High Performance Mysql > 1st ed was Jeremy D. Zawodny (lead), Derek J. Balling. > 2nd ed is Baron Schwartz (lead), Peter Zaitsev, Vadim Tkachenko, > Jeremy D. Zawodny, Arjen Lentz, Derek J. Balling
This is true, and if you can determine that they are equal, then of course you can create multiple authors. That usually means knowing the item. The difficulty is that you don't know how or why the Amazon inputters decided to create the author field with multiples. So it may take some investigation. If you don't want to go through that investigation, following the pattern of another edition in the database is a second-best option. What I'm not sure about is how multiple authors affect the merging of editions... the order may make a difference, but I don't know. kc > > So you need a join table to correctly join multiple authors to a work > There are a number of works that the person or committee collating the > book is only an editor and does not write any or little content. > > Libraries may have done things in a particular way but was it right, > or was it just bending data to fit the schema because of the costs of > going back to the software suppliers and getting it right was too high > way back when. > > Dave Caroline > _______________________________________________ > Ol-discuss mailing list > [email protected] > http://mail.archive.org/cgi-bin/mailman/listinfo/ol-discuss > To unsubscribe from this mailing list, send email to > [email protected] > -- Karen Coyle [email protected] http://kcoyle.net ph: 1-510-540-7596 m: 1-510-435-8234 skype: kcoylenet _______________________________________________ Ol-discuss mailing list [email protected] http://mail.archive.org/cgi-bin/mailman/listinfo/ol-discuss To unsubscribe from this mailing list, send email to [email protected]
