Shelby Bice (Research Plan)

Overview

Overall goals:

• Create better database that includes all the patent data to which the McNair Center has access.
• More importantly, create documentation of process so it can improved upon/replicated in the future.

General Outline - updated 2/21/2017

• Familiarize myself with SQL, Perl, and database design
• Familiarize myself with existing scripts and schema for existing database
• Design a better representation for database
• Fix scripts if necessary
• Start moving data into new database by querying existing databases (using SQL)
• Use scripts to query new data
• Test database
• Remove extraneous information from database (copies, patents that we're not interested in, etc.)

Documentation I need to include:

• Schema of new database (with justification of design), would like to include a visual representation
• SQL commands that were used to fill database with explanation of what they do
• Clear instructions on where to find scripts in bulk drive and an explanation of what each script does
• Visual representation of example table entries that isn't just copied and pasted from a CSV file

Project Pages: Redesigning Patent Database