Jump to navigation Jump to search
no 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
* Add pages on other projects to Redesigning Patent Database (this wikipage) under Related Projects
* 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
* Start documentation for how new tables should be added to database
* 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
* Start documentation for how new tables should be added to database
{{McNair Projects

Navigation menu