Data Model (Deprecated) - Revision history

OliverC: add note to current schema per "Redesigning Patent Database"

2017-05-24T13:55:46Z

add note to current schema per "Redesigning Patent Database"

OliverC: OliverC moved page Data Model to Data Model (Deprecated)

2017-05-24T13:54:07Z

OliverC moved page Data Model to Data Model (Deprecated)

MarcelaInteriano at 20:49, 17 January 2017

2017-01-17T20:49:49Z

Carlin at 21:27, 2 September 2016

2016-09-02T21:27:06Z

MarcelaInteriano: Created page with "The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to..."

2016-07-29T18:53:41Z

Created page with "The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to..."

New page

The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to follow.

[[Image:1007px-Patent Data.png|1024x768px]]


===XML Schema===

Tags we are using:
*CPC Classification: https://en.wikipedia.org/wiki/Cooperative_Patent_Classification
*IPC - these are good and we just need the main classification
*USPC - just a numeric but not split. Is 22431 224/31 or 22/431, etc.

Tags we aren't using:
*Kind codes: http://www.uspto.gov/learning-and-resources/support-centers/electronic-business-center/kind-codes-included-uspto-patent
*Series codes: http://www.uspto.gov/web/offices/ac/ido/oeip/taf/filingyr.htm

===Fields of Interest===
In order to satisfy the data model, the following fields were of particular interest when extracting the data from the XML files and placing them in tables.
{{:Patent_Data_Extraction_Scripts_(Tool)}}

← Older revision		Revision as of 13:55, 24 May 2017
Line 1:		Line 1:
−	~~Return to~~ [[Patent ~~Data (Wiki Page)~~]].	+	'''See [[Patent]] for current implementation'''

	The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to follow.		The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to follow.

← Older revision		Revision as of 20:49, 17 January 2017
Line 1:		Line 1:
		+	Return to [[Patent Data (Wiki Page)]].
		+
	The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to follow.		The USPTO and Harvard Dataverse data has been combined into one database spanning from 1901 to 2016. The image below summarizes the data model the database was constructed to follow.

← Older revision		Revision as of 21:27, 2 September 2016
Line 19:		Line 19:
	In order to satisfy the data model, the following fields were of particular interest when extracting the data from the XML files and placing them in tables.		In order to satisfy the data model, the following fields were of particular interest when extracting the data from the XML files and placing them in tables.
	{{:Patent_Data_Extraction_Scripts_(Tool)}}		{{:Patent_Data_Extraction_Scripts_(Tool)}}
		+	[[Category: Internal]]
		+	[[Internal Classification: Legacy\| ]]

← Older revision	Revision as of 13:54, 24 May 2017
(No difference)