Kings DB: sample data now entered
Posted by mholmes on 07 Oct 2010 in Activity log
I've put all the sample data into the database. I gave up on trying to avoid duplicate inkslingers because it could only really be done using flow control structures in SQL, and that requires functions, but I don't seem to be able to get functions working through PhpMyAdmin. There's are a couple of things to think about now we can see this data in context:
- Many of the sources have very long titles (paragraph length). Our title field is only 45 characters long, so I've had to truncate them all, but I've added a new field called "sc_fullTitle" where the full title is stored. The truncation was done programmatically, and the results in the short title fields are not very informative, so I think one immediate task will be to create a meaningful short title for each of the documents. If this can't be done in 45 characters then we can make that field bigger, but it can't be too big because it'll be displayed in the form of a drop-down list when you're choosing which source a reference comes from.
- The sources have no source type, because the Zotero data was not explicit enough for me to guess the type of source -- mostly they were described as "book".
- The inkslingers have no title or nationality, because there was no data for these fields in the Zotero output.
- We still don't have any values for datePrecisions -- is this field worth keeping?
- The regions (anthro and Euro) have no continent and description information.