The following pages are relevant to how previous databases are built/how to build tables in the database:
[[http://mcnair.bakerinstitute.org/wiki/Harvard_Dataverse_Data Harvard Dataverse Data ]] - explains how to make tables from Harvard Dataverse data, where to find scripts, etc.
[[http://mcnair.bakerinstitute.org/wiki/Patent_Data_Extraction_Scripts_(Tool) Patent Data Extraction ]] - explains locations of XML files and lists (at the bottom) where the Perl scripts can be found
[[http://mcnair.bakerinstitute.org/wiki/Patent_Data_Cleanup_-_June_2016 Patent Data Cleanup ]] - explains changes that were made to clean up problems in the database allpatent as a result of merging the Harvard Dataverse data and the USPTO data
[[http://mcnair.bakerinstitute.org/wiki/Patent_Data_Processing_-_SQL_Steps Patent Data Processing - SQL Steps ]] - explains SQL needed to merge two existing databases, one that contained the Harvard Dataverse data and one that contained the USPTO data
== Test Plan ==