Shelby Bice (Research Plan)

From edegan.com
Revision as of 11:49, 21 February 2017 by ShelbyBice (talk | contribs)
Jump to navigation Jump to search

Overall goals \n 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 \n 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

Documentation I need to include \n 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

2/16/2017 - Talked over project with Ed, began reading existing wiki pages related to patent data and databases