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.

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.