377
edits
Changes
Jump to navigation
Jump to search
→Current Design and Scripts information
== Current Design and Scripts information ==
The scripts for querying data for the patent database exist in McNair/software/scripts/patent. If the design for the schema of the database tables are altered too much, may have to write new scripts.
The following pages are relevant to how previous databases are built/how to build tables in the database:
[[Harvard Dataverse Data http://mcnair.bakerinstitute.org/wiki/Harvard_Dataverse_Data]] - explains how to make tables from Harvard Dataverse data, where to find scripts, etc.
[[Patent Data Extraction http://mcnair.bakerinstitute.org/wiki/Patent_Data_Extraction_Scripts_(Tool)]] - explains locations of XML files and lists (at the bottom) where the Perl scripts can be found
[[Patent Data Cleanup http://mcnair.bakerinstitute.org/wiki/Patent_Data_Cleanup_-_June_2016]] - 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
[[Patent Data Processing - SQL Steps http://mcnair.bakerinstitute.org/wiki/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 ==
