Difference between revisions of "Shelby Bice (Research Plan)"
ShelbyBice (talk | contribs) |
ShelbyBice (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | '''Overall goals''' | + | '''Overall goals:''' |
| + | |||
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''' | ||
| + | |||
Familiarize myself with SQL, Perl, and database design | Familiarize myself with SQL, Perl, and database design | ||
Familiarize myself with existing scripts and schema for existing database | Familiarize myself with existing scripts and schema for existing database | ||
| Line 11: | Line 13: | ||
Use scripts to query new data | Use scripts to query new data | ||
| − | '''Documentation I need to include''' | + | '''Documentation I need to include:''' |
| + | |||
Schema of new database (with justification of design), would like to include a visual representation | 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 | SQL commands that were used to fill database with explanation of what they do | ||
Revision as of 11:52, 21 February 2017
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
2/16/2017 - Talked over project with Ed, began reading existing wiki pages related to patent data and databases
