Changes

The {{Project|Has project output=Data,Tool,Content,Guide|Has sponsor=McNair Center|Has title=Patent Data|Has owner=Marcela Interiano|Has start date=Spring 2016||Has keywords=Patent , Database,Data page |Has project status=Subsume|Due Date=NA}}This project is concerned with maintaining and updating patent data, to enable the McNair Center staff to extract meaningful data for academic papers and reports. Currently, there are two primary sources for instructions this data - the US Patent and Trademark Office as well as the Harvard Dataverse. Data from the LexMachina online database has been added to provide information on how [[Guide to get Patent Litigation (Wiki Page) | patent litigation]]. All the USPTO acquired data is stored in normalized tables to be accessed and modified using PostgreSQL. The patent data, how to use the has been separated into multiple databases based on data source or subject matter. Each database, and consists of several tables for which the documentation of our databaseknown [[Patent Data Issues | issues]] have been recorded.

== ER diagram Data Sources==See Data has been extracted from the '''[http[USPTO Bulk Data]]''', the '''[[Harvard Dataverse]]''', and '''[[Lex Machina]]''', an online patent litigation database. {{#section://wwwUSPTO_Bulk_Data_Processing|bulk}}{{#section:Harvard_Dataverse|dataverse}} The sources used were intended to follow the overall [[Data Model]] established by the McNair Center.edegan.com/wiki/images/0/06/Patent_Data.png ER Diagram]

== Downloading the files Database Specifics==The files [[Patent|Patent Database]] contains the merged datasets from the USPTO bulk data and Harvard Dataverse using PostgreSQL. Specifics on how the datasets were merged are given in [[Patent Data Processing - SQL Steps]].Patent Database focuses on patents, patent litigation, patent maintenance, patent assignment, and other details on patent owners. The [[USPTOAssigneesData|USPTO Assignees Database (in xml formatversion 2) for granted ]] focuses on patent assignments, a transaction between one or more patent owners with one or more parties where ownership or interest in one or more patents is assigned or shared. The database consists of historical assignment data can be obtained at provided by the USPTO in XML files. Specifics on how the database are given on the [[https://wwwUSPTO Assignees Data Processing]] Page.google.com/googlebooks/uspto-patents-grants-text.html granted patent ==Academic Projects== ===[[Little Guy Academic Paper|'Little Guy' Academic Paper]]===The files for patent first application data can of the refined database will be obtained at the [[httpsLittle Guy Academic Paper]]. {{#section://wwwLittle_Guy_Academic_Paper|Little Guy}}===Patent Trolls=== Academic Paper: The patent database will also be used to explore the existence of patent trolls and characteristic litigation activity.googleAn academic paper may be developed defining patent trolls and other entities often confused as patent trolls.com/googlebooks/uspto-patents-applications-textThe data from Lex Machina will be used to track troll behavior and associated outcomes as well as the impact of other patent intermediary and assertion bodies.html patent applications] Issue Brief: Based on an analysis of the litigation data from Lex Machina, an issue brief, tentatively titled [[The Truth Behind Patent Trolls Issue Brief| The files for maintenance fees data can Truth Behind Patent Trolls]], on patent troll activity may be obtained at written to report on how best to curve abuses through [https://www[Innovation Policy| innovation policy]] and reform.google.com/googlebooks/uspto  <!--patentsflush -maintenance-fees.html maintenance]>