Difference between revisions of "Redesigning Patent Database"

From edegan.com
Jump to navigation Jump to search
Line 1: Line 1:
 
Documentation on the process and eventual designs for the new patent database.
 
Documentation on the process and eventual designs for the new patent database.
 +
 +
TODO on 3/7/2017
 +
* Continue working on Excel spreadhseet analyzing current schema and new schema design (this spreadsheet can be found under Projects/Redesigning Patent Database/Comparing current schema and new schema)
 +
 
{{McNair Projects
 
{{McNair Projects
 
|Has title=Redesigning Patent Database
 
|Has title=Redesigning Patent Database
Line 12: Line 16:
 
}}
 
}}
 
== '''Redesigning Patent Database''' ==
 
== '''Redesigning Patent Database''' ==
 +
 +
==Documentation Relevant to Current Patent Database==
  
 
== Description ==
 
== Description ==

Revision as of 14:15, 2 March 2017

Documentation on the process and eventual designs for the new patent database.

TODO on 3/7/2017

  • Continue working on Excel spreadhseet analyzing current schema and new schema design (this spreadsheet can be found under Projects/Redesigning Patent Database/Comparing current schema and new schema)



McNair Project
Redesigning Patent Database
Project logo 02.png
Project Information
Project Title Redesigning Patent Database
Owner Shelby Bice
Start Date 201701
Deadline 201705
Keywords Database, Patent
Primary Billing
Notes
Has project status Active
Copyright © 2016 edegan.com. All Rights Reserved.


Redesigning Patent Database

Documentation Relevant to Current Patent Database

Description

The purpose of this project is to create a new, redesigned database to hold all of the patent information that the McNair Center has accumulated and document the process so that the design can be easily understood and replicated or edited as needed.

This database will include design patents, utility patents, and reissues.

Development

Design will be built upon a relational database model. I will be referencing this article on database design as I develop the design (http://en.tekstenuitleg.net/articles/software/database-design-tutorial/one-to-many.html), and I will be creating an ER diagram.

Current Design and Scripts information

The scripts for querying data for the patent database exist in McNair/software/scripts/patent. If the design for the schema of the database tables are altered too much, may have to write new scripts.

Test Plan

Log: