7,612
edits
Changes
Jump to navigation
Jump to search
Shelby Bice (Research Plan) (view source)
Revision as of 17:17, 21 March 2017
, 17:17, 21 March 2017no edit summary
== 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/1621/2017 - Talked over project ''' * Familiarize myself with EdSQL, Perl, began reading and database design* Familiarize myself with existing wiki pages related 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 patent query new data * Test database* Remove extraneous information from database (copies, patents that we're not interested in, etc.) '''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 databasesan explanation of what each script does* Visual representation of example table entries that isn't just copied and pasted from a CSV file '''Project Pages:'''[[Redesigning Patent Database]] == Log ==[[Category:Work Log]]
