building equivalent patent families

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

o10o
Posts: 9
Joined: Fri Jan 09, 2009 2:40 pm

building equivalent patent families

Post by o10o » Tue Jan 24, 2017 3:00 pm

Hi,
Does somebody know
if i can find somewhere sql scripts to help me to build equivalent patent families?

Thanks in advance


Geert Boedt
Posts: 176
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: building equivalent patent families

Post by Geert Boedt » Tue Jan 24, 2017 4:00 pm

Hello o10o,
the so called "equivalents" are a synonym for "simple family" or also called "Docdb patent family".
This family concept is pre-defined in PATSTAT through the attribute DOCDB_FAMILY_ID. Every patent application in PATSTAT belongs to strictly 1 Docdb patent family.
The concept of this family is that they share the same priority picture.

The INPADOC family is based on as set of linked Docdb patent families, defined through "shared" priorities. These families are equal or larger then the Docdb patent families and can contain applications that cover different inventions. Similar to the Docdb patent family, each patent can only be a member of 1 INPADOC family.

Patent families are recreated for each PATSTAT release in order to include the new patent applications.
There exist a number of other patent family concepts such as "Triadic patent families", etc...

Docdb patent family members can be retrieved by joining TLS201_APPLN tables via the DOCDB-FAMILY_ID attribute. Here is an example:

Code: Select all

SELECT tls201_appln.appln_id 
      ,tls201_appln.appln_auth 
      ,tls201_appln.appln_nr 
      ,tls201_appln.appln_kind 
      ,tls201_appln.appln_filing_date 
      ,tls201_appln.docdb_family_id 
      ,tls201_appln.inpadoc_family_id 
      ,tls201_appln.docdb_family_size 
      ,tls201_appln.nb_citing_docdb_fam 
      ,simple_family.appln_id 
      ,simple_family.appln_auth 
      ,simple_family.appln_nr 
      ,simple_family.appln_kind 
      ,simple_family.appln_filing_date 
      ,simple_family.docdb_family_id 
      ,simple_family.docdb_family_size 
  FROM tls201_appln join tls201_appln as simple_family 
	on tls201_appln.docdb_family_id = simple_family.docdb_family_id
  where tls201_appln.appln_auth = 'EP' and tls201_appln.appln_nr = '99203729'
Result:
family.xlsx
(10.49 KiB) Downloaded 281 times
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


o10o
Posts: 9
Joined: Fri Jan 09, 2009 2:40 pm

Re: building equivalent patent families

Post by o10o » Tue Jan 24, 2017 4:09 pm

Thank you very much Geert :)


Post Reply