Shelby Bice (Research Plan)
Revision as of 12:20, 21 February 2017 by ShelbyBice (talk | contribs)
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
2/21/2017 - Brushed up on Perl, SQL, Entity - Relationship model of designing databases
- In the documentation, I want to briefly explain what the entity-relationship model is before including
the diagram so that readers have a little bit of background
- Found a tool for creating a visual representation called ERDPlus.com - create a standalone instead of an account, can download