MYSQL File Analysis for Library Database

Library-v6.txt is the complete dump of the library database imported to mysql. (from books-v5.xls). It's big (5M) so will take awhile to download. Once it's fully loaded into the browser you can use the browser's find facility to find records. Check the overall content and use of fields to make sure they look right.

Library-fielduse.txt is a listing of the use of the other fields which have repeating data values, along with the number of occurrences of that value in the field. As with the images db we need to look at this with an eye toward reducing the number of fields, concatenating them into other fields (like description) where possible.

library-classfields.txt is a listing of the use of the various fields that are used for classification. With the images db we have the benefit of a primary taxonomy field (otherno), but we have no such field with the library db so we need to 'grab' something from one of these fields to use for that taxonomy... or create another field for that purpose. This is the biggest issue with the library db and will take the most time to sort out.