Difference between revisions of "Small Inventors Project"

From edegan.com
Jump to navigation Jump to search
Line 55: Line 55:
  
 
Created times_cited which counts the number of times a patent is cited
 
Created times_cited which counts the number of times a patent is cited
 +
 +
DROP TABLE citation_cleaned
 +
CREATE TABLE citation_cleaned AS
 +
  SELECT patent, cited
 +
  FROM citation
 +
  WHERE (patent IS NOT NULL AND
 +
  citation is NOT NULL);
 +
#SELECT 74164171
 +
 +
ALTER TABLE citation_cleaned RENAME patent to citing;
 +
 +
DROP TABLE citations_made
 +
CREATE TABLE citations_made AS
 +
  SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;
 +
#SELECT 5214098
 +
 +
DROP TABLE times_cited
 +
CREATE TABLE times_cited AS
 +
  SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;
 +
#SELECT 6977741
 +
 +
ALTER TABLE citations_made RENAME citing to patent;
 +
ALTER TABLE times_cited RENAME cited to patent;
  
  

Revision as of 19:03, 9 March 2017


McNair Project
Small Inventors Project
Project logo 02.png
Project Information
Project Title Small Inventors Project
Owner Avesh Krishna
Start Date 201702
Deadline 201705
Keywords Patents, Small Business
Primary Billing
Notes
Has project status Active
Copyright © 2016 edegan.com. All Rights Reserved.


General

Story: What happened to the American Small Inventor

  • Identify small inventors
  • Are they patenting more or less
  • Has AIA helped them
  • Are their patents being attacked in IPR/litigation
  • What do they do with their IP (license/transfer)
  • What are they valued at

Micro Entities

Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001

either an employee of institute of higher education OR
rights to patent will be assigned to institute of higher education
however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity

Small Entities

Is a person or small business

How to find: Fee Status Table

Want to create a new table with all small and micro patents and if they are small or micro

Then find all patents citing a small or micro patent

basically a left join of the table and the citations table (so including small micro or large designation is shown)


Look to see how many patents cite knowledge used by small or micro firms

break down by category small medium large

Find \

Patent Database

created citation_cleaned table which removed all rows with NULL value in either column

Created citations_made table which counts the number of patents cited by a patent

Created times_cited which counts the number of times a patent is cited

DROP TABLE citation_cleaned
CREATE TABLE citation_cleaned AS
  SELECT patent, cited
  FROM citation
  WHERE (patent IS NOT NULL AND
  citation is NOT NULL);
#SELECT 74164171

ALTER TABLE citation_cleaned RENAME patent to citing;

DROP TABLE citations_made
CREATE TABLE citations_made AS
  SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;
#SELECT 5214098

DROP TABLE times_cited
CREATE TABLE times_cited AS
  SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;
#SELECT 6977741

ALTER TABLE citations_made RENAME citing to patent;
ALTER TABLE times_cited RENAME cited to patent;


originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality.

citations across classes.

Whole (2005) paper that corrects the bias inherent in those measure,