Help with CPC

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

talya.ponchek
Posts: 8
Joined: Wed Mar 23, 2016 10:57 am

Help with CPC

Post by talya.ponchek » Fri Apr 08, 2016 5:22 pm

Hello,
I've read all the threads on CPC search here.
I have constructed the following query (this is just for getting a feeling with how to work with patstat):
select tls201_appln.appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date, granted, nb_citing_docdb_fam, cpc_position, cpc_class_symbol
from tls201_appln join tls224_appln_cpc on tls201_appln.appln_id = tls224_appln_cpc.appln_id
where
tls201_appln.appln_id in (select distinct appln_id from tls224_appln_cpc where cpc_class_symbol = 'B60L 11/1881')
I received zero results.
Can you please tell me if I'm doing anything wrong. I wasn't expecting zero results.
Thanks!
Talya


mkracker
Posts: 96
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Help with CPC

Post by mkracker » Mon Apr 11, 2016 12:55 pm

I copied your query and just made sure that there are 2 spaces between the CPC subclass part 'B60L' and the CPC subgroup part '11/1881'. Then the query returned 24 991 rows in the PATSTAT 2015 Autumn Edition.

Code: Select all

select tls201_appln.appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date, granted, nb_citing_docdb_fam, cpc_position, cpc_class_symbol
from tls201_appln join tls224_appln_cpc on tls201_appln.appln_id = tls224_appln_cpc.appln_id
where tls201_appln.appln_id in 
   (select distinct appln_id from tls224_appln_cpc 
   where cpc_class_symbol = 'B60L  11/1881')
The format of the CPC symbol in PATSTAT is the same as the format of the IPC symbol. For a detailed explanation please see this forum entry: "Question about search for IPC_class_symbol" (patstat/topic4767.html)

Best regards,
Martin
-------------------------------------------
Martin Kracker / EPO PATSTAT


talya.ponchek
Posts: 8
Joined: Wed Mar 23, 2016 10:57 am

Re: Help with CPC

Post by talya.ponchek » Mon Apr 11, 2016 2:23 pm

Dear Martin,
Thank you so much for the help!
Best,
Talya


talya.ponchek
Posts: 8
Joined: Wed Mar 23, 2016 10:57 am

Re: Help with CPC

Post by talya.ponchek » Wed Apr 13, 2016 10:27 am

Dear Martin,
I have a follow-up question.
Why when I use both CPC and IPC codes in the same search using "and" I'm getting fewer results.

This is the query:
select distinct
app.*
from
TLS201_APPLN app,
TLS224_APPLN_CPC cpc,
TLS209_APPLN_IPC ipc
where 1=1
and app.appln_id=cpc.appln_id
and app.appln_id=ipc.appln_id
and app.ipr_type='PI'
-- and app.granted=1
and app.appln_auth in ('DE','IL')
and cpc.CPC_CLASS_SYMBOL in (
'H01M 10/00',
'H01M2010/00',
'H01M 6/00',
'H01M 2/00',
'H01M 8/00',
'Y10S 977/948',
'H01M 12/00',
'Y02E 60/12',
'B60L2240/54',
'B60Y2400/112',
'B60Y2400/114',
'Y02T 10/7005',
'Y10S 903/908',
'Y10S 903/903',
'B60L 11/1851',
'B60L 11/1881',
'B60L 11/1879',
'Y02T 10/6273',
'Y02T 10/7072',
'B60Y2300/91',
'H02J 7/00',
'H02J 7/0027',
'G01R 31/36',
'Y10S 320/00',
'Y10S 320/21',
'Y10S 320/12',
'H02J2007/00',
'H02J 7/14',
'B60Y2400/435',
'Y02T 10/7072',
'G01R 31/3624',
'G01R 31/3606',
'B60L 11/1809',
'Y02T 90/10',
'B60L2230/00',
'Y02T 90/12',
'Y02T 90/14',
'Y02T 90/16',
'Y02T 90/167',
'Y02T 90/163'
)
--and ipc.IPC_CLASS_SYMBOL in ('H01M 6/00','H01M 2/00','H01M 8/00','H01M 10/00','H01M 12/00')
--and ipc.IPC_VALUE='I'

When I add the last 2 rows I get only 507 results whereas without them I have 7,901 results.
Thanks in advance,

Talya


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: Help with CPC

Post by nico.rasters » Sun Apr 24, 2016 2:49 pm

If you say CPC IN (A,B,C,D,E) AND IPC IN (A) then the IPC IN (A) part will severely cut down the results.
AND does not add things. You'll need OR for that.
I wouldn't mix IPC and CPC like this anyway. Also note that the coverage may vary, as CPC is the new classification. I think I saw a graph in one of the posts here pointing it out.

Btw, since you are exploring the database, here's a tip. If WHERE cpc_class_symbol = 'B60L 11/1881' gives you zero results then you could have done SELECT DISTINCT cpc_class_symbol FROM tls224_appln_cpc WHERE cpc_class_symbol LIKE "B60L%"; just to inspect what's going on. Or leave out the WHERE clause entirely.
Also note that the IPC classes are based on version 8 of the IPC. This is nice if you are using some old articles with IPC based definitions, but not so handy if you are building your own definitions based on the most recent version at WIPO.
________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


Post Reply