377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 10:15, 28 September 2017
, 10:15, 28 September 2017→Connecting Patent database and Assignment database
==Connecting Patent database and Assignment database==
The answer to connecting the Patent database to the Assignment database lies somewhere in using the information in the table DOCUMENT_INFO to get a patent_id from the Patent database PATENT table for each assignment in the Assignment database ASSIGNMENT table. The patent_id will be stored in the DOCUMENT_INFO table once it has been found, but it is unclear currently how exactly to use the information in DOCUMENT_INFO to accomplish this.
According the paper on "The USPTO Patent Assignment Dataset: Descriptions and Analysis" mentions in the text of the paper that there will be patent numbers stored a table constructed from DOCUMENT_INFO called DOCUMENT_INFO_ADMIN if the patent was assigned a patent number. The patent number is "for the appno_doc_num from administrative data." The "appno_doc_num" is the Application Document USPTO number from DOCUMENT_INFO.
