377
edits
Changes
Jump to navigation
Jump to search
* Add pages on other projects to Redesigning Patent Database (this wikipage) under Related Projects
* Start documentation for how new tables should be added to database
Redesigning Patent Database (view source)
Revision as of 11:59, 21 March 2017
, 11:59, 21 March 2017no edit summary
Documentation on the process and eventual designs for the new patent database.
Deliverables by end of semester:
Design and build new patent database with core tables from data, add tables from Patent Data Restructure and Small Inventors Project,
write thorough documentation on schema of new patent database and instructions on what documentation should be written when it is altered
TODO on 3/21/2017 and 3/23/2017
* Determine what tables in database need to always be there (patents, inventors, etc.) and which tables were added for separate projects
* Start documentation for the "core" tables of the databases that should not be deleted.
* Make ER Diagram for "core" tables in database
* Start documentation for how one should go about changing/altering the "core" tables
* Determine if any current tables in the database "patent" that I do not have currently listed as "core" tables should be added as core tables by determining which project(s) they're related to:
** For example, I know what I should include lexjudge in the new schema, but now they are several other "lex-" tables. Do these needs to be considered "core" tables?
*Evaluate perl scripts for pulling data for new database
Future:
* Start documentation for how new tables should be added to database
{{McNair Projects
