7,612
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 13:41, 21 September 2020
, 13:41, 21 September 2020no edit summary
{{Project|Has project output=Data|Has sponsor=McNair ProjectsCenter
|Has title=Redesign Assignment and Patent Database
|Has owner=Shelby Bice,
|Is dependent on=Reproducible Patent Data,
}}
'''FOR ED:Final Notes''' I finished adding going through This is more or less the finalized design for the unique paths patent database. Oliver Chang's code (you can see Reproducible Patent Data, which is his project page) more or less fits the design, though there are some differences and expect differences in variable names. In the unique fields I identified at future the bottom code should be altered so that the name of this page, under "Finding New Paths Unique to Plant, Reissue, variables match up and/or Design Patents"each table that is listed here exists in the database. Then, under my design The tables for the Patent Databaseextra variables that exist for reissue, there's a new section called "Unique Attributes Tables" where I've begun detailing a design , and plant patents have been added, and the instructions for adding tables can be found on Reproducible Patent Data. These three new tables that would include information that is unique to Design, Reissueshould fit the schema seen here, but as stated previously the schema in the code DOES NOT fit the schema here exactly and Plant tablesshould be altered in the future to fit this schema. Here are some questions I have:
'''1.For Oliver:''' Do you like design for the new tables? How do you think we should populate these tables? Unfortunately I can think of one way (putting all did not get to finish making the information schema in your code fit the main patent tables and then moving it out to Plantschema that is outlined here. For whoever works on this next, Reissuewhether that be you or another intern, or Design as needed) but I was wondering if there might be an easier way. '''2.''' There were some unique attributes to utility patents please note that I also included the variable in "Finding New Paths Unique to Plant, Reissue, and/or Design Patents". They only appear to be the schema in two of the oldest XML versions (4.1 and 4.0) and I'm code do not sure match up exactly with the information is particularly useful - but please take a look at schema outlined here, except for perhaps the field names Reissues, Plants, and let me know if you disagree and think they are useful and should be included Designs tables in a table the Patent database (called patentsj in the patent database. '''3.''' Do you know what some of these fields represent? For example, I've been trying to research online what a "Parent Document" and/or "Parent Grant Document" might represent for a reissue patentcode, and I've found a couple possible options. I will keep researchingbelieve, but if you know what they represent or one can create a database with any name of my descriptions for a field is wrong, please let me knowcourse).
This is an extension of the work I did last semester under "Redesigning Patent Database". Instead of simply reconfiguring the existing database, this project encompasses and full redesign and creation of a new Patent database and a new Assignment database that will be joined together.
==ER Diagram for Assignment and Patent Databases==
Note: this is currently out of sync with matches the current description design below for but may not match the patent exact database(nor the code that creates the schema of the database currently. It will In the future these should be updated once I have finalized how we will organize unique attributes for plant, design, and reissue patentsmade to sync up.
[[File:PatentAndAssignmentER2Erdplus-diagram (3).png]]
Attributes for each table are listed below with descriptions - because of how many attributes there are, I decided the ER diagram would be better suited as an overview of the tables rather than trying to show all the attributes on the diagram.
If you would like to edit the diagram, you can find the ER diagram you can go to https://erdplus.com/ and click "Open Diagram File" under the "Diagram" dropdown, then navigate to E:/McNair/Project/Redesigning Patent Database/New Patent Database Project/ERDiagramforPatentandAssignmentDatabases.erdplus. You should be able to edit the file then.
==Assignment Database Structure==
====PLANT====
=====Fields=====
* patent_number patent_no (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
* latin_name (varchar(255)) latin name for the plant
* us_botanical_variety(varchar(255)) denotes what variety of plant it is - for example, a rose has several different varieties
=====Fields=====
* patent_number patent_no (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
* parent_doc_status (varchar(255)) status of the parent application. Probably related to whether the patent application is pending or not
* parent_doc_number (int) probably application number for the parent document
====DESIGN====
=====Fields=====
* patent_number patent_no (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
* length_of_grant (int) length of grant, most likely in years
* hague_registration_date (date) filing date of international patent application
