154
edits
Changes
Jump to navigation
Jump to search
-- ==Patents ==
Column Names:
patent int,
kind varchar,
claims int,
apptype int,
appnum int,
gdate date,
gyear int,
appdate date,
appyear int
Column Names:
patentnumber int,
kind varchar,
grantdate date,
type varchar,
applicationnumber varchar,
filingdate date,
prioritydate date,
prioritycountry varchar,
prioritypatentnumber varchar,
ussubclass varchar,
maingroup varchar,
subgroup varchar,
cpcsubclass varchar,
cpcmaingroup varchar,
cpcsubgroup varchar,
classificationnationalcountry varchar,
classificationnationalclass varchar,
title varchar,
numberofclaims int,
primaryexaminerfirstname varchar,
primaryexaminerlastname varchar,
primaryexaminerdepartment varchar,
pctpatentnumber varchar,
filename varchar
patentnumber int, -- patent kind varchar, -- kind grantdate date, --gdate type varchar, applicationnumber varchar, filingdate date, prioritydate date, prioritycountry varchar, prioritypatentnumber varchar, ussubclass varchar, maingroup varchar, subgroup varchar, cpcsubclass varchar, cpcmaingroup varchar, cpcsubgroup varchar, classificationnationalcountry varchar, classificationnationalclass varchar, title varchar, numberofclaims int, primaryexaminerfirstname varchar, primaryexaminerlastname varchar, primaryexaminerdepartment varchar, pctpatentnumber varchar, filename varchar claims int, apptype int, appnum int, gyear int, appdate date, appyear int
filename,
********** ==== INDEX CREATION **************====
**== Citations==
************ Columns *********************
Patent Data Processing - SQL Steps (view source)
Revision as of 17:03, 23 June 2016
, 17:03, 23 June 2016no edit summary
--3818842
Note : The assignees table was updated on 6/23 to remove the 'null' string and the '-1' values.
Patentdata:
appdate | date |
appyear | integer |
filename | varchar |
Combined Schema:
appdate date,
appyear int
Output Schema: patents
primaryexaminerdepartment,
pctpatentnumber,
-1,
-1,
ALTER TABLE patents ADD PRIMARY KEY (patentnumber);
CREATE INDEX
To Extract Patents with Numbers Only and to Ignore Other RegExes
$$ LANGUAGE plperl;
patentdata:
Column | Type | Modifiers
