Difference between revisions of "Shelby Bice (Research Plan)"

From edegan.com
Jump to navigation Jump to search
Line 4: Line 4:
  
 
* Create better database that includes all the patent data to which the McNair Center has access.
 
* 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.
+
* More importantly, create documentation of process so it can improved upon/replicated in the future.
  
 
'''General Outline - updated 2/21/2017'''
 
'''General Outline - updated 2/21/2017'''
Line 20: Line 20:
 
* SQL commands that were used to fill database with explanation of what they do
 
* 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
 
* Clear instructions on where to find scripts in bulk drive and an explanation of what each script does
 
  
 
== Log ==
 
== Log ==
  
 
2/16/2017 - Talked over project with Ed, began reading existing wiki pages related to patent data and databases
 
2/16/2017 - Talked over project with Ed, began reading existing wiki pages related to patent data and databases

Revision as of 11:54, 21 February 2017

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

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

Log

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