===Spring 2017===
2/14/2017 10-4-27: 1:00 am pm - 123:00 pm Set up personal wiki- worked on documentation more, set up work logtried to figure out how to clean citation data
2/16/2017 -4-25: 10:30 00 am - 12:00 pm Researched past work - worked on databasesdocumentation, discussed project with Edtried to determine how to clean up the USPTO Assignee Data
2/21/2017 9-4-20: 10:00 am - 1211:00 30 pm Set up work page, reviewed SQL, researched designing - wrote copy statements for copying data from RDP to database, continued going through wikiworking on documentation.
2/23/2017 -4-18: 9:30 45 am - 12:00 30 pm Reviewed Perl, read about database design, set - Cleaned up project page for redesigning databasedocumentation more, started documenting kept working through the processof parsing the data
3/2/2017 -4-13: 9:15 30 am - 12:15 00 pm Started excel spreadsheet - Continued working on trying to document current schema design and improvements update patent data through 2016, specifically parsing the data, worked with Ed to be made, updated project pagesupdate perl scripts
3/7/2017 -4-11: 9:30 15 am - 12:00 pm Continued working on spreadsheet, added relevant page links to project page, took notes - Worked on what I want documentation trying to look like in the futureupdate patent data through 2016
3/9/2017 -4-6: 9:00 30 am - 1211:00 30 pm Finished first draft of spreadsheet describing the current schema (and possible changes) to the Patent database- Kept looking through DTDs, kept updating documentation
3/21/2017 -4-4: 9:30 00 am - 1211:00 45 pm - Worked on determining "core" updating documentation, found documentation on pulling data/making tables for new patent databaseand databases, started looking through DTDs to find extra fields to pull
2017-3/22/2017 5-23: 9:30 pm to 615 am - 12:30 00 pm - Patent Data meetingNarrowed down core tables and fields
2017-3/23/2017 9-22: 5:15 am - 1230 pm to 6:00 30 pm - Narrowed down core tables and fieldsPatent Data meeting
4/4/2017 -3-21: 9:00 30 am - 1112:45 00 pm - Worked on updating documentation, found documentation on pulling data/making determining "core" tables and databases, started looking through DTDs to find extra fields to pullfor new patent database
4/6/2017 -3-9:30 9:00 am - 1112:30 00 pm - Kept looking through DTDs, kept updating documentationFinished first draft of spreadsheet describing the current schema (and possible changes) to the Patent database
4/11/2017 -3-7: 9:15 30 am - 12:00 pm - Worked Continued working on spreadsheet, added relevant page links to project page, took notes on trying what I want documentation to update patent data through 2016look like in the future
4/13/2017 -3-2: 9:30 15 am - 12:00 15 pm - Continued working on trying Started excel spreadsheet to document current schema design and improvements to update patent data through 2016be made, specifically parsing the data, worked with Ed to update perl scriptsupdated project pages
4/18/2017 -2-23: 9:45 30 am - 12:30 00 pm - Cleaned Reviewed Perl, read about database design, set up documentation moreproject page for redesigning database, kept working through the started documenting process of parsing the data
4/20/2017 10-2-21: 9:00 am - 1112:30 00 pm - wrote copy statements for copying data from RDP to Set up work page, reviewed SQL, researched designing database, continued working on documentation.going through wiki
4/25/2017 -2-16: 10:00 30 am - 12:00 pm - worked Researched past work on documentationdatabases, tried to determine how to clean up the USPTO Assignee Datadiscussed project with Ed
4/27/2017 1-2-14: 10:00 pm am - 312:00 pm - worked on documentation moreSet up personal wiki, tried to figure out how to clean citation dataset up work log
[[Category:Work Log]]