7,612
edits
Changes
Jump to navigation
Jump to search
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[[Category:Work Log]]
Shelby Bice (Research Plan) (view source)
Revision as of 17:17, 21 March 2017
, 17:17, 21 March 2017no edit summary
* Start moving data into new database by querying existing databases (using SQL)
* Use scripts to query new data
* Test database
* Remove extraneous information from database (copies, patents that we're not interested in, etc.)
'''Documentation I need to include:'''
* 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
* Visual representation of example table entries that isn't just copied and pasted from a CSV file
'''Project Pages:'''
[[Redesigning Patent Database]]
== Log ==
