154
edits
Changes
Jump to navigation
Jump to search
Patent Data Processing - SQL Steps (view source)
Revision as of 17:29, 23 June 2016
, 17:29, 23 June 2016→Objective
== Objective ==
The McNair Center owns two sets of patent data - one set that is inherited from Harvard, the Harvard dataverse, which is stored in the database patentdata and another that is generated by crawlers pulling data from the USPTO website, which is stored in the database '''patent_2015'''.
We are now merging and cleaning the two data sets, and storing them in a schema that is amalgamation of the two underlying schema for the citations tables, assignees tables, and patents tables. The destination schema is '''allpatent'''.
