Search found 96 matches

by mkracker
Wed Dec 23, 2015 8:34 am
Forum: PATSTAT Product Line
Topic: Amended 2015b tables
Replies: 2
Views: 1140

Re: Amended 2015b tables

Hi Rachie, Last week every PATSTAT subscriber should have received an e-mail notification indicating where to find the amended tables. Please contact our PATSTAT help desk (patstat@epo.org) with your contact details to find out why we missed you. Thank you. The updated tables are available till abou...
by mkracker
Mon Dec 21, 2015 12:07 pm
Forum: PATSTAT Product Line
Topic: count patents for german patent office
Replies: 1
Views: 1107

Re: count patents for german patent office

Like you already did, it is good practice to check the quality of your data and the plausibility of your result. Basically your query is fine, but you did not consider some particularity of the German patent office. The DPMA also publishes granted EPs in their Bulletin using PUBLN_KIND code D1. Thes...
by mkracker
Mon Dec 21, 2015 8:58 am
Forum: PATSTAT Product Line
Topic: IPC NACE2 Concordance "not with ipc"
Replies: 1
Views: 1376

Re: IPC NACE2 Concordance "not with ipc"

Dear Florian, I do not know the table from OECD you mentioned. But I can give some information on the data used in PATSTAT. Table TLS902_IPC_NACE2 contains a mapping / concordance between IPC symbols and NACE2 (= NACE revision2) codes, which is the result of a work of Eurostat in co-operation with K...
by mkracker
Fri Dec 18, 2015 5:44 pm
Forum: PATSTAT Product Line
Topic: Tool for import PATSTAT into MySQL
Replies: 1
Views: 1528

Tool for import PATSTAT into MySQL

Many of the PATSTAT Raw Data users work on MySQL. Recently I was in contact with Simone Mainardi ( http://www.simonemainardi.com/ ), who created a handy tool to upload the PATSTAT Raw Data files into MySQL. Simone is happy to share his effort with the community and recently upgraded it to be compati...
by mkracker
Wed Dec 16, 2015 11:20 am
Forum: PATSTAT Product Line
Topic: Time out error - Acceleration of query needed
Replies: 4
Views: 948

Re: Time out error - Acceleration of query needed

Just my observations and hints: Searching in long texts with wild cards,which you do heavily in your query, is costly in PATSTAT Online. A relational database is not the ideal tool for searching text. In your query there is no need to put a wild card on the left side of the IPC symbol, like ipc_clas...
by mkracker
Thu Dec 03, 2015 9:07 am
Forum: PATSTAT Product Line
Topic: Non-zero applicant and inventor sequence number
Replies: 1
Views: 880

Re: Non-zero applicant and inventor sequence number

You guessed correctly. If APPLT_SEQ_NR and INVT_SEQ_NR are > 0 in the table TLS207_PERS_APPLN or table TLS227_PERS_PUBLN, then an applicant is also an inventor for that application. As you mentioned, this is quite often the case. As usual, there are several ways to model data. The PATSTAT model was ...
by mkracker
Thu Nov 19, 2015 9:00 am
Forum: PATSTAT Product Line
Topic: Error Message
Replies: 3
Views: 1206

Re: Error Message

Daniel, This is the classical division-by-zero error, because you compute "SUM(1/(nb_applicants*1.00))". It will help if you include in your statement "AND nb_applicants > 0"; then your query will run fine. Still, I do not fully understand the situation. In principle, there exist applications in PAT...
by mkracker
Wed Nov 18, 2015 10:14 pm
Forum: PATSTAT Product Line
Topic: Patstat 2015b - worst so far
Replies: 2
Views: 1090

Re: Patstat 2015b - worst so far

I'm sorry to hear that you have had troubles loading the data into your database. Among the many tests we do before shipping the disks, we load the csv files again in our DBMS (we are using MS SQL Server v2008). For 2015b we did not encounter any problems. To better understand your problem, could yo...
by mkracker
Sun Nov 01, 2015 10:34 pm
Forum: PATSTAT Product Line
Topic: Selecting a subset of results: equivalent to MySQL's LIMIT?
Replies: 2
Views: 1625

Re: Selecting a subset of results: equivalent to MySQL's LIM

You are right, the easiest way to do this is with the OFFSET ... FETCH clause, which is new in version 2012. Luckily PATSTAT Online is running on MS SQL Server 2012. An ORDER BY clause is mandatory for the OFFSET ... FETCH. So to conform to the syntax, you must append to your query these lines to sk...
by mkracker
Thu Sep 03, 2015 3:28 pm
Forum: PATSTAT Product Line
Topic: Missing person address in Patstat online?
Replies: 2
Views: 1076

Re: Missing person address in Patstat online?

Inventor address data is not available in PATSTAT Online. To facilitate the analysis on a micro-regional level despite missing addresses, we are currently investigating the possibilities of extending PATSTAT data with NUTS3/TL3 and other related information. In the meantime, you could have a look at...