Difference between revisions of "Shelby Bice (Research Plan)"
ShelbyBice (talk | contribs) (Created page with "2/16/2017 - Talked over project with Ed, began reading existing wiki pages related to patent data and databases") |
ShelbyBice (talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | 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 | 2/16/2017 - Talked over project with Ed, began reading existing wiki pages related to patent data and databases | ||
Revision as of 11:46, 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
