377
edits
Changes
Jump to navigation
Jump to search
→Log:
==Log:==
'''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 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
Learning commands from Patent Data - SQL Steps
* copy command is PostgreSQL that copies a SQL table to a text file
** DELIMITER set what will separate columns in text file
** HEADER specifies that there will be a header in the text file with the names of the columns
* Definitely need to include more detail about what these do in the documentation
* insert into command inserts a new entry into the table
'''2/23/2017''' - Read great database design article, dug through some more wiki articles, started reviewing Perl
* What client do we use to interact with the current patent database?
* Will need to determine all the fields that need to be included in the database before finishing the design and ER diagram, will need Ed's input
'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.
* Created an Excel spreadsheet that records the each table, their current attributes in the existing patentdata table, what I think the attributes should be in the new table, their relationship to a patent (i.e. one-to-many, many-to-many, etc.), their primary key, questions I have relating to the table, future steps for cleaning up the data in the table (i.e., once all the data has been move to the new database, removing patents that are not US-based), and current problems that have been recorded with the existing table for that information (if an existing table exists)
* Once Excel spreadsheet is completed (and questions in the Questions column are answered or removed from the spreadsheet entirely) I will look into trying to embed it on my "Redesigning Patent Database" wiki page so that future users can sort of follow my thought process. I will also create separate wiki pages to explain each table once the new database is created
** instructions for adding a table to a wiki page https://www.mediawiki.org/wiki/Help:Tables
* Making spreadsheet led me to realize there is some data that is repeated (filedate in fee table when it is also located in patent table, and the fee table includes the patent
[[Category:Internal]]
