Shelby Bice (Work Log)

Shelby Bice Work Logs (log page)

Spring 2017 Work

2/14/2017 10:00 am - 12:00 pm Set up personal wiki, set up work log

2/16/2017 10:30 am - 12:00 pm Researched past work on databases, discussed project with Ed

2/21/2017 9:00 am - 12:00 pm Set up work page, reviewed SQL, researched designing database, continued going through wiki

2/23/2017 9:30 am - 12:00 pm Reviewed Perl, read about database design, set up project page for redesigning database, started documenting process

3/2/2017 9:15 am - 12:15 pm Started excel spreadsheet to document current schema design and improvements to be made, updated project pages

3/7/2017 9:30 am - 12:00 pm Continued working on spreadsheet, added relevant page links to project page, took notes on what I want documentation to look like in the future

3/9/2017 9:00 am - 12:00 pm Finished first draft of spreadsheet describing the current schema (and possible changes) to the Patent database

3/21/2017 9:30 am - 12:00 pm - Worked on determining "core" tables for new patent database

3/22/2017 5:30 pm to 6:30 pm - Patent Data meeting

3/23/2017 9:15 am - 12:00 pm - Narrowed down core tables and fields

4/4/2017 9:00 am - 11:45 pm - Worked on updating documentation, found documentation on pulling data/making tables and databases, started looking through DTDs to find extra fields to pull

4/6/2017 9:30 am - 11:30 pm - Kept looking through DTDs, kept updating documentation

4/11/2017 9:15 am - 12:00 pm - Worked on trying to update patent data through 2016

4/13/2017 9:30 am - 12:00 pm - Continued working on trying to update patent data through 2016, specifically parsing the data, worked with Ed to update perl scripts

4/18/2017 9:45 am - 12:30 pm - Cleaned up documentation more, kept working through the process of parsing the data

4/20/2017 10:00 am - 11:30 pm - wrote copy statements for copying data from RDP to database, continued working on documentation.