Changes

9/15/2017 -11-3: 2:00 30 - 3:30 pm, 3:45 pm - 5:00 pm (I went to get a snack because I was starving!) - introduced Finished up finding unique fields, added them to new patent database projecteddesign, reviewed and took notes on USPTO Assignment data (notes can be found under McNair/Projects/Redesigning Patent Database/New Patent Database Project as Notes researched what the fields represented - again, this is taking a while since there is little to no documentation online about what fields on USPTO Assignment Data Paper)these XML files actually represent.

9/22/2017 8-11-2: 2:30 am 15 pm - 104:30 am 00 pm - continued looking at paper on USPTO assignment made a main data page and adding to continued going through 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 issuesxpaths Oliver found. Notified Michelle so she can continue adding patent pages

2017-10-31: 9/23/2017 2:00 pm am - 410:00 pm 30 am - continued working on design of Assignment database and how it will connect started trying to Patent database by writing out determine from Oliver's research what will be in each table in Assignment paths are unique to utility, reissue, and questions about different possible structures of tables plant patents that we will have to address before finalizing the not yet accounted for in our design - of 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]]table

9/26/2017 8:45 am - 10-27: 2:00 am pm - 3:30 pm - continued worked on design Kept updating tables. For some of Assignment database by checking my design against the work done last semester on the assignment data restructure new values I've been adding to make sure tables (I didn't miss anything major. Began going over my patent database design from last semester realize we had XPaths for some fields) I'm struggling to tweak it. Will need to sync up with Joe Reilly to see if there are any new fields find out exactly what the field means (for example, the date on a citation - is this the date the citedpatent was granted? or is the date that we are pulling from the datacitingpatent cited the citedpatent?) so the process is slow going. Additionally, I made a new project page called Redesign Assignment and Patent Database that encompasses want to get the new design for documentation right though so in the Assignment database future someone can look up and Patent database redesign see exactly what each field in the table represents and moved some of the notes from McNair/Projects/Redesigning Patent Database/New Patent Database Project/Notes on USPTO Assignment Data Paper not have to the project page.guess

The main takeaway from looking over Patent Assignment Data Restructure is that, after assembling 2017-10-26: 2:00 pm - 4:00 pm - worked on updating the table according to my design (which doesn't seem to have any contradictions with the Patent Assignment Data Restructure) that there will by multiple steps designs for cleaning the data, patent databases tables based on what was discussed on Friday (specifically the fields relating to location adding inventors and address in the assignment table. While the Patent Assignment Data Restructure mentions connecting to the Patent databaselawyers tables, it is not clear from the page what field would be used to connect to the Patent database.altering fields on patent tables) - will continue this on Friday

9/28/2017 9-10-20: - 2:00 am pm - 105:30 am 00 pm - continued going over met with Ed and documenting last semester's Oliver about 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.

Tomorrow I will finish adding the design 2017-10-19: 2:00 pm - 4:00 pm - finished up ER diagram and description of all tables for the Patent patent database, started reading papers concerning creating an inventor's database to (looks like other research groups have merged the project page, add descriptions of USPTO data with the fields for each Harvard Dataverse data in order to create an inventors table to the project page, and start working on ER diagrams for the two databases.)

Links 2017-10-17: 8:45 am - 10:30 am - continued trying to solve twitter issues, worked on ER diagram, skimmed through a paper I found (linked at the top of the page for creating Redesign Assignment and Patent Database) to see how they cleaned the data, since I assume that will be the next step to research after finishing the ER diagrams: https://erdplus.com/#/standalone or https://creately.com/app/?tempID=hqdgwjki1&login_type=demo#

9/29/2017 -10-12: 2:00 30 pm - 5:00 pm - finished adding the design for the Patent database to the project page, added descriptions of the fields for each table write blog post on Grace Hopper Celebration and attempted to the project page including the datatype that I think the field will be when it's loaded into the databasesolve Twitter issue

2017-10/-03/2017 : 8:45 am - 10:30 am - finished adding descriptions to the fields for each table in the patent database, started work on an ER diagram

10/12/2017 -9-29: 2:30 00 pm - 5:00 pm write blog post on Grace Hopper Celebration and attempted - finished adding the design for the Patent database to the project page, added descriptions of the fields for each table to solve Twitter issuethe project page including the datatype that I think the field will be when it's loaded into the database

10/17/2017 8-9-28:45 9:00 am - 10:30 am - continued trying going over and documenting last semester's patent database design and adding the details to solve twitter issues, worked on ER diagram, skimmed through a paper I found (linked at the top of the page for Redesign Assignment and Patent Database) project page. Additionally, I began trying to see determine how they cleaned to match up the data, since I assume that will be information in the next step Document_Info table in Assignment to research after finishing match up with a patent_id in the ER diagramsPatent table in Patent.

10/19/2017 2:00 pm - 4:00 pm - finished up ER diagram and description of all tables Tomorrow I will finish adding the design for patent the Patent databaseto the project page, started reading papers concerning creating an inventor's database (looks like other research groups have merged add descriptions of the fields for each table to the USPTO data with project page, and start working on ER diagrams for the Harvard Dataverse data in order to create an inventors table)two databases.

10Links for creating ER diagrams: https:/20/2017 - 2erdplus.com/#/standalone or https:00 pm - 5:00 pm - met with Ed and Oliver about patent database design//creately.com/app/?tempID=hqdgwjki1&login_type=demo#

10/2017-9-26/2017 2:00 pm 8:45 am - 410:00 pm am - continued worked on updating 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 designs data. Additionally, I made a new project page called Redesign Assignment and Patent Database that encompasses the new design for the patent databases tables based on what was discussed on Friday (specifically adding inventors Assignment database and Patent database redesign and lawyers tables, altering fields moved some of the notes from McNair/Projects/Redesigning Patent Database/New Patent Database Project/Notes on patent tables) - will continue this on FridayUSPTO Assignment Data Paper to the project page.

10/27/2017 2:00 pm - 3:30 pm - Kept updating tables. For some of The main takeaway from looking over Patent Assignment Data Restructure is that, after assembling the new values I've been adding table according to tables my design (I didnwhich doesn't realize we had XPaths for some fields) I'm struggling seem to find out exactly what have any contradictions with the field means (Patent Assignment Data Restructure) that there will by multiple steps for examplecleaning the data, specifically the date on a citation - is this fields relating to location and address in the date assignment table. While the citedpatent was granted? or is Patent Assignment Data Restructure mentions connecting to the date that the citingpatent cited the citedpatent?) so the process Patent database, it is slow going. I want to get not clear from the documentation right though so in the future someone can look up and see exactly page what each field in would be used to connect to the table represents and not have to guessPatent database.

10/31/2017 -9-23: 2:00 am pm - 104:30 am 00 pm - started trying continued working on design of Assignment database and how it will connect to determine from Oliver's research Patent database by writing out what paths are unique to utility, reissue, will be in each table in Assignment and plant patents questions about different possible structures of tables that we will have not yet accounted for 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 our design of yellow throughout the tabledocument[[Category:Work Log]]

11/2/2017 2-9-22: 8:15 pm 30 am - 410:00 pm 30 am - made a main continued looking at paper on USPTO assignment data page and continued going through 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 xpaths Oliver founddesign. Had to set up connection to RDP again due to technical issues. Notified Michelle so she can continue adding patent pages

11/3/2017 2:30 - 39-15:30 pm, 32:45 00 pm - 5:00 pm (I went to get a snack because I was starving!) - Finished up finding unique fields, added them introduced to new patent database designprojected, reviewed and researched what the fields represented - again, this is taking a while since there is little to no documentation online about what fields took notes on USPTO Assignment data (notes can be found under McNair/Projects/Redesigning Patent Database/New Patent Database Project as Notes on these XML files actually represent.USPTO Assignment Data Paper)