Changes

2017-1112-308 1: 00 pm - 2:30 - 3:30 pm, 3:45 pm - 5:00 pm (I went updated the ER Diagram on my project page to get a snack because I was starving!) - Finished up finding unique fieldsinclude the three tables for reissue, added them to database designplant, and researched what design patents respectively. Finished typing up the status of the fields represented - again, this is taking a while since there is little project as I am leaving it with notes to no documentation online about what fields on these XML files actually represent.Oliver and Ed

2017-12-07 3:15 PM - 4:45 PM (came in late due to finals) - finished debugging additions to Oliver's code for the tables that are related to design, reissue, and plant patents, added a troubleshooting section to Oliver's page with instructions on how to deal with issues importing the project.  2017-12-04 2:45 pm - 4:00 pm - continued debugging and started typing up troubleshooting tips for the next person who alters the patent code 2017-12-01 3:15 pm - 5:00 pm - ran code (and ran into errors) which I have been working on fixing. If I don't finish today, I'll continue doing so on Monday. I plan to write up some of the mistakes I made in adding the tables to the database and add them to Oliver's page, with his permission so that people in the future who are not familiar with the code (like I wasn't) hopefully won't fall into the same pitfalls. The main things are 1) how to set up a maven project (if IntelliJ doesn't automatically set it up for you when you open/import the project, and 2) how to set up the data source so you can run SQL scripts and actually load data into the database on the RDP. 2017-11-30-17 1:55 pm - 3:55 pm - continued altering code. Wrote creation tables script in SQL for creating tables for the design, reissue, and plant patents, and went through the checklist to make sure I had done everything to create these new tables based on Oliver's Reproducible Patent Data page. Will definitely run code tomorrow and will type up the exact process I went through to create new tables.  2017-11-17 2:15 pm - 5:00 pm - continued altering code to include the special fields for plant, reissue, and design patent. Their models and the changes to XmlParser relevant to those models should be done. I will go through the rest of the code and check where else I need to make alterations next time I am in.  2017-11-16 8:45 am - 10:30 am - continued altering code to include the special fields for plant, reissue, and design patents 2017-11-14 8:30 - 10:30 am - met with Oliver to go over his code, began working on scripts and finding paths for the fields qunie to design, reissue, and plant patents. 2017-11-10: 2:00 - 5:00 pm - updated format of worklog, finished researching fields of the new design, utility, and reissue tables, and documenting what each table contains 2017-11-03: 2:30 - 3:30 pm, 3:45 pm - 5:00 pm (I went to get a snack because I was starving!) - Finished up finding unique fields, added them to database design, and researched what the fields represented - again, this is taking a while since there is little to no documentation online about what fields on these XML files actually represent. 2017-11-2: 2:15 pm - 4:00 pm - made a main data page and continued going through the xpaths Oliver found. Notified Michelle so she can continue adding patent pages

2017-909-29: 2:00 pm - 5:00 pm - finished adding the design for the Patent database to the project page, added descriptions of the fields for each table to the project page including the datatype that I think the field will be when it's loaded into the database

2017-909-28: 9:00 am - 10:30 am - continued going over and documenting last semester's patent database design and adding the details to the Redesign Assignment and Patent Database project page. Additionally, I began trying to determine how to match up the information in the Document_Info table in Assignment to match up with a patent_id in the Patent table in Patent.

2017-909-26: 8:45 am - 10:00 am - continued worked on design of Assignment database by checking my design against the work done last semester on the assignment data restructure to make sure I didn't miss anything major. Began going over my patent database design from last semester to tweak it. Will need to sync up with Joe Reilly to see if there are any new fields that we are pulling from the data. Additionally, I made a new project page called Redesign Assignment and Patent Database that encompasses the new design for the Assignment database and Patent database redesign and moved some of the notes from McNair/Projects/Redesigning Patent Database/New Patent Database Project/Notes on USPTO Assignment Data Paper to the project page.

2017-909-23: 2:00 pm - 4:00 pm - continued working on design of Assignment database and how it will connect to Patent database by writing out what will be in each table in Assignment and questions about different possible structures of tables that we will have to address before finalizing the design - the notes can be found under McNair/Projects/Redesigning Patent Database/New Patent Database Project as Notes on USPTO Assignment Data Paper. Questions are highlighted in yellow throughout the document[[Category:Work Log]]

2017-909-22: 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.

2017-909-15: 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)

</onlyinclude>

2017-404-27: 1:00 pm - 3:00 pm - worked on documentation more, tried to figure out how to clean citation data

2017-404-25: 10:00 am - 12:00 pm - worked on documentation, tried to determine how to clean up the USPTO Assignee Data

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

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

2017-404-13: 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

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

2017-404-606: 9:30 am - 11:30 pm - Kept looking through DTDs, kept updating documentation

2017-404-404: 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

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

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

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

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

2017-303-707: 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

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

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

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

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

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