Identifying patents based on citation from different technological fields

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

torben
Posts: 13
Joined: Thu Nov 12, 2015 9:59 am

Identifying patents based on citation from different technological fields

Post by torben » Tue Jan 22, 2019 9:40 am

Hello,

I'm trying to create a complex query. My objective is to find patents that cite at least three patents from different technological fields. I have already created a search string which shows me the technological fields of the cited patents. I still need to check whether there are at least three cited patents from different technological fields. Any ideas? Following you will find my first query and two slides how the check should work.

Query:

Code: Select all

SELECT cited_publication.appln_id as cited_appln_id, cited_publication.publn_auth as cited_publn_auth
,cited_publication.publn_nr cited_publn_nr
,cited_publication.publn_kind cited_publn_kind
,cited_publication.publn_date cited_publn_date
,techn_field.techn_field_nr 
,techn_field.weight
,citing_publn.publn_auth citing_publn_auth
,citing_publn.publn_nr citing_publn_nr
,citing_publn.publn_kind citing_publn_kind
,citing_publn.publn_date citing_publn_date
, citing_publn.appln_id citing_appln_id

FROM tls211_pat_publn cited_publication

JOIN tls212_citation on cited_publication.pat_publn_id = tls212_citation.cited_pat_publn_id
JOIN tls211_pat_publn citing_publn on tls212_citation.pat_publn_id = citing_publn.pat_publn_id
JOIN tls230_appln_techn_field techn_field on cited_publication.appln_id = techn_field.appln_id

Slides:
Image https://ibb.co/crBBLCD
Image https://ibb.co/CvfSqYM


EPO / PATSTAT Support
Posts: 227
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Identifying patents based on citation from different technological fields

Post by EPO / PATSTAT Support » Thu Jan 24, 2019 2:59 pm

Hello Torben,
your attached pictures suggest that you are looking for 3 groups of cited documents that have no common technological field. Correct ?
Do you have access to PATSTAT Global on a local server ?
Geert BOEDT
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply