Search found 124 matches

by EPO / PATSTAT Support
Wed Jul 10, 2019 3:04 pm
Forum: PATSTAT Product Line
Topic: Efficient text searching in PATSTAT Online
Replies: 0
Views: 64

Efficient text searching in PATSTAT Online

Since the latest version PATSTAT Online allows text searching with the T-SQL features CONTAINS and FREETEXT. A keyword search in the title or the abstract now takes only seconds instead of (many) minutes. More details can be found in section 6.3.2 of the "PATSTAT Online user manual" in the documenta...
by EPO / PATSTAT Support
Tue Jul 09, 2019 7:53 am
Forum: PATSTAT Product Line
Topic: IPC / CPC historical coverage
Replies: 1
Views: 271

Re: IPC / CPC historical coverage

Patents that were filed before the current classifications schemes came into existence, have been (re)classified using varying methods: human input, full text keyword analysis, concordance tables from existing classification schemes to new one’s or a combination of the different approaches. There is...
by EPO / PATSTAT Support
Wed Jun 19, 2019 7:23 am
Forum: Linked open EP data/open EP bulk data
Topic: New data set: EP full-text data for text analytics
Replies: 0
Views: 1699

New data set: EP full-text data for text analytics

Patent data analysts, researchers and PATSTAT users have been asking for it since long. A bulk data set consisting of XML-tagged titles, abstracts, descriptions, claims and search reports covering all EP publications, designed to facilitate natural language processing work and linkable to PATSTAT or...
by EPO / PATSTAT Support
Fri Jun 14, 2019 5:35 pm
Forum: PATSTAT Product Line
Topic: BLOCKCHAIN search strategy for....
Replies: 0
Views: 700

BLOCKCHAIN search strategy for....

The PATSTAT team is aware that many researchers are doing analysis on patent filings related to "BLOCKCHAIN" technology. At the latest "Search Matters " event https://www.epo.org/learning-events/events/conferences/search-matters.html , two collegue examiners presented a search strategy that provides...
by EPO / PATSTAT Support
Thu Jun 13, 2019 9:19 am
Forum: PATSTAT Product Line
Topic: TLS229_APPL_NACE2
Replies: 4
Views: 176

Re: TLS229_APPL_NACE2

Hello Christelle, yes of course. It's a variation on the second query. Here is an example that gives you a patent count per Nace code for all applications filed in 2016 at the French patent office. (no including PCT applications filed at INPI). Select distinct tls902_ipc_nace2.nace2_descr ,tls229_ap...
by EPO / PATSTAT Support
Wed Jun 12, 2019 5:49 pm
Forum: PATSTAT Product Line
Topic: TLS229_APPL_NACE2
Replies: 4
Views: 176

Re: TLS229_APPL_NACE2

Hello Christelle, On (1) the "concordance table" is part of PATSTAT under the LTS902_IPC_NACE table. If you run a query like the one below, you will retrieve all records, wich you can download if you would like to do so. SELECT ipc ,not_with_ipc ,unless_with_ipc ,nace2_code ,nace2_weight ,nace2_desc...
by EPO / PATSTAT Support
Wed Jun 05, 2019 10:13 am
Forum: PATSTAT Product Line
Topic: New PATSTAT release 2019 Spring edition is now available
Replies: 0
Views: 196

New PATSTAT release 2019 Spring edition is now available

We would like to inform you that the 2019 Spring edition is now ready for download and also PATSTAT Online has been updated. For a short overview on the changes, kindly have a look at this document: Readme.pdf Detailed information on the changes is available in the PATSTAT Data Catalog: DataCatalog_...
by EPO / PATSTAT Support
Wed Jun 05, 2019 9:40 am
Forum: PATSTAT Product Line
Topic: Now available: EP full-text data for analytics
Replies: 2
Views: 382

Now available: EP full-text data for analytics

Patent data analysts, researchers and PATSTAT users have been asking for it since long. A bulk data set consisting of XML-tagged titles, abstracts, descriptions, claims and search reports covering all EP publications, designed to facilitate natural language processing work and linkable to PATSTAT. O...
by EPO / PATSTAT Support
Thu May 23, 2019 9:30 am
Forum: PATSTAT Product Line
Topic: Retrieving tables of random sample
Replies: 2
Views: 513

Re: Retrieving tables of random sample

Hi Jon, TABLESAMPLE is not supported by the driver we are using in PATSTAT Online. Nevertheless, there are many other ways to get a random sample. The technical identifier APPLN_ID is a sequential number assigned to the applications as they are loaded into the database. [[So it can be regarded as ra...
by EPO / PATSTAT Support
Wed May 22, 2019 1:15 pm
Forum: PATSTAT Product Line
Topic: Patent specialization by technology class for Greece
Replies: 1
Views: 133

Re: Patent specialization by technology class for Greece

Hello Hannah, technology classes can be identified thought for example the patent classification scheme, be it IPC or CPC classess (at various levels of granularity). Another option would be to use the so called "technology fields and sectors" available via the TLS230 and TLS901 tables in PATSTAT. B...