7,612
edits
Changes
Jump to navigation
Jump to search
'''Overall goals''' \nCreate 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.== Overview ==
'''Documentation I need * Create better database that includes all the patent data to include''' \nwhich the McNair Center has access.Schema of new database (with justification of design)* More importantly, would like to include a visual representationSQL commands that were used to fill database with explanation create documentation of what they doClear instructions on where to find scripts process so it can improved upon/replicated in bulk drive and an explanation of what each script doesthe future.
Shelby Bice (Research Plan) (view source)
Revision as of 17:17, 21 March 2017
, 17:17, 21 March 2017no edit summary
'''General Outline - updated 2/21/2017Overall goals:''' \nFamiliarize myself with SQL, Perl, and database designFamiliarize myself with existing scripts and schema for existing databaseDesign a better representation for databaseFix scripts if necessaryStart moving data into new database by querying existing databases (using SQL)Use scripts to query new data
'''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]]
