Shelby Bice (Research Plan) - Revision history

Ed at 21:17, 21 March 2017

2017-03-21T21:17:06Z

ShelbyBice: /* Log */

2017-03-07T15:39:36Z

Log

ShelbyBice at 18:07, 2 March 2017

2017-03-02T18:07:55Z

ShelbyBice: /* Log */

2017-03-02T17:40:02Z

Log

ShelbyBice at 16:33, 2 March 2017

2017-03-02T16:33:15Z

ShelbyBice: /* Log */

2017-03-02T16:26:15Z

Log

ShelbyBice: /* Log */

2017-03-02T16:22:51Z

Log

ShelbyBice: /* Overview */

2017-03-02T15:56:04Z

Overview

ShelbyBice: /* Log */

2017-03-02T15:49:56Z

Log

ShelbyBice: /* Log */

2017-03-02T15:22:27Z

Log

← Older revision		Revision as of 21:17, 21 March 2017
Line 28:		Line 28:

	== Log ==		== Log ==
		+	[[Category:Work Log]]

← Older revision		Revision as of 15:39, 7 March 2017
Line 28:		Line 28:

	== 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

@@ Line 25: / Line 25: @@
 '''Project Pages:'''
-[[Shelby Bice (Redesigning Patent Database)]]
+[[Redesigning Patent Database]]
 == Log ==

← Older revision		Revision as of 17:40, 2 March 2017
Line 50:		Line 50:
	* 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		* 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		** 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

← Older revision		Revision as of 16:33, 2 March 2017
Line 49:		Line 49:
	* 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)		* 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		* 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

← Older revision		Revision as of 16:26, 2 March 2017
Line 47:		Line 47:

	'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.		'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.
−	* Created an Excel ~~sheet~~ 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)	+	* 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

← Older revision		Revision as of 16:22, 2 March 2017
Line 47:		Line 47:

	'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.		'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.
−	* Created an Excel sheet that records the each table, their attributes, 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)	+	* Created an Excel sheet 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)

@@ Line 22: / Line 22: @@
 * 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
 '''Project Pages:'''

← Older revision		Revision as of 15:49, 2 March 2017
Line 46:		Line 46:

	'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.		'''3/2/2017''' - Started compiling a list of what fields to include and how they would be related.
		+	* Created an Excel sheet that records the each table, their attributes, 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)

← Older revision		Revision as of 15:22, 2 March 2017
Line 44:		Line 44:
	* What client do we use to interact with the current patent database?		* 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		* 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.