7,612
edits
Changes
Jump to navigation
Jump to search
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.== Overview ==
General Outline - updated 2/21/2017Familiarize 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'''Overall goals:'''
Documentation I need * Create better database that includes all the patent data to include:which 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/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]]
