Shelby Bice (Work Log)
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.
4/25/2017 10:00 am - 12:00 pm - worked on documentation, tried to determine how to clean up the USPTO Assignee Data
4/27/2017 1:00 pm - 3:00 pm - worked on documentation more, tried to figure out how to clean citation data
Fall 2017 Work
9/15/2017 2:00 pm - 5:00 pm - introduced to new patent database projected, reviewed and took notes on USPTO Assignment data (notes can be found under McNair/Projects/Redesigning Patent Database/New Patent Database Project as Notes on USPTO Assignment Data Paper)
9/22/2-17 8:30 am - 10:30 am - continued looking at paper on USPTO assignment data and adding to the notes on what the design of that database should look like, specifically on what I need for different tables and what I don't know yet about the design. Had to set up connection to RDP again due to technical issues.
