Hi,
Does somebody know
if i can find somewhere sql scripts to help me to build equivalent patent families?
Thanks in advance
building equivalent patent families
-
- Posts: 176
- Joined: Tue Oct 19, 2004 10:36 am
- Location: Vienna
Re: building equivalent patent families
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:
Result:
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'
Best regards,
Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna
Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna
Re: building equivalent patent families
Thank you very much Geert