Search found 232 matches
- Wed Aug 22, 2018 8:10 am
- Forum: Linked open EP data/open EP bulk data
- Topic: Linked open EP data at the SEMANTiCs 2018 conference
- Replies: 0
- Views: 2994
Linked open EP data at the SEMANTiCs 2018 conference
We are pleased to announce that EPO’s linked open EP data will be presented at the SEMANTiCS 2018 in an industry talk as well on a poster & demo stand. SEMANTiCS conference ( https://semantics.cc/ ) is the leading European conference on Machine Learning, Data Science, Linked Data and Natural Languag...
- Tue Aug 21, 2018 10:02 am
- Forum: PATSTAT Product Line
- Topic: Forward citation.
- Replies: 2
- Views: 3153
Re: Forward citation.
Your group by should use the same ALIAS as in the select: GROUP BY a.docdb_family_id .
And if you want to do a typical "family-family" count then you should use the family_id in your count. (But maybe you want to effectively count applications, depends on your analysis.)
And if you want to do a typical "family-family" count then you should use the family_id in your count. (But maybe you want to effectively count applications, depends on your analysis.)
- Mon Aug 13, 2018 5:09 pm
- Forum: PATSTAT Product Line
- Topic: Estimating US patent "oppositions"
- Replies: 3
- Views: 2399
Re: Estimating US patent "oppositions"
Hello Rahul, I had a look at the application you specified, but could not see any legal status referring to a filed opposition on that application. select reg101_appln.appln_id ,[appln_auth] ,[appln_nr] ,[appln_filing_date] ,[status] ,[internat_appln_id] ,[internat_appln_nr] ,[event_seq_nr] ,[event_...
- Thu Jul 26, 2018 3:03 pm
- Forum: PATSTAT Product Line
- Topic: TLS_215 documentation inconsistency
- Replies: 1
- Views: 1921
Re: TLS_215 documentation inconsistency
Dear David, Actually, I do not see an inconsistency. In easy terms: If a (set of) claims of a patent application has an citation of category X, then this citation destroys this (set of) claims. The patent application will not be granted unless these claims are removed. In contrast, the citation cate...
- Wed Jul 25, 2018 12:56 pm
- Forum: PATSTAT Product Line
- Topic: Estimating US patent "oppositions"
- Replies: 3
- Views: 2399
Re: Estimating US patent "oppositions"
Dear Rahul, I understand from your question that you are aware that there are no real oppositions in the US patent system, but re-examinations / post grant reviews. Also, a company may be involved on 2 sides: it may be either the appellant or the respondent / patent owner in post-grant review procee...
- Wed Jul 25, 2018 9:34 am
- Forum: PATSTAT Product Line
- Topic: Need Help with International Patents
- Replies: 2
- Views: 1845
Re: Need Help with International Patents
Hi Musso, You asked 2 questions: 1) As you mentioned, the same invention can be filed as patent (and probably later granted) in several jurisdictions. Such a group of patent is called “patent family”. There are multiple definitions of what precisely makes a patent family. The EPO uses two family typ...
- Tue Jul 24, 2018 4:13 pm
- Forum: PATSTAT Product Line
- Topic: Published patents by company
- Replies: 1
- Views: 1349
Re: Published patents by company
I am not sure what you actually want to achieve. What I noted is that your last join has the join condition ‘company.person_id = cited.pat_publn_id’. You are comparing a person ID with a patent publication ID, which will get you random results. It’s a complex query. I recommend you re-do it incremen...
- Tue Jul 24, 2018 3:50 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT and Espacenet consistency
- Replies: 1
- Views: 1367
Re: PATSTAT and Espacenet consistency
The Espacenet field identifier PD stand for “publication date”, and its PATSTAT equivalent is the attribute PUBLN_DATE in table TLS211_PAT_PUBLN. So your query is almost perfect. It just needs a join with the publication table as well: select * from tls201_appln a left outer join tls202_appln_title ...
- Tue Jul 24, 2018 11:12 am
- Forum: PATSTAT Product Line
- Topic: IPC Classification
- Replies: 1
- Views: 2104
Re: IPC Classification
Hi Musso, I think this is what you want: select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol, a3.person_name, a3.person_ctry_code from tls201_appln a1 left outer join tls207_pers_appln a2 on a2.appln_id = a1.appln_id left outer join tls206_person a3 on a3.person_id = a2.person_id left outer join ...
- Tue Jul 24, 2018 10:09 am
- Forum: PATSTAT Product Line
- Topic: Error: insufficient disk space
- Replies: 1
- Views: 1646
Re: Error: insufficient disk space
Dear Pradeep, There are several reasons why your query has problems: - Last week we had a full disk issue which caused the error message you reported. This is fixed. Sorry for the inconvenience this has caused. - The other reason is that your query is – as you assumed – much too heavy, because it co...