377
edits
Changes
Jump to navigation
Jump to search
→Redesigning Patent Database
}}
== '''Redesigning Patent 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
* 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 an explanation of what each script does
* Visual representation of example table entries that isn't just copied and pasted from a CSV file
==Documentation Relevant to Current Patent Database==
