I think that historically there was just the value on the books table, and the author_sort on the authors table is relatively recent. I believe that the reason both are kept is that at times one can want books to be sorted differently to the authors table - particularly in the case of multiple authors.
|