Search found 232 matches

by EPO / PATSTAT Support
Wed Feb 12, 2020 4:24 pm
Forum: PATSTAT Product Line
Topic: MS SQL server bulk loading script example
Replies: 0
Views: 2100

MS SQL server bulk loading script example

Loading PATSTAT in a MS SQL server is dependant on your MS SQL server edition and your server settings. At the EPO we use MS SQL Enterprise edition 2017. This means we can use the Bulk data tools to import the data. The scripts might not work on earlier versions of MS SQL server. So, this is what wo...
by EPO / PATSTAT Support
Wed Jan 29, 2020 9:58 am
Forum: PATSTAT Product Line
Topic: Seeking help on using PATSTAT global 2019
Replies: 1
Views: 628

Re: Seeking help on using PATSTAT global 2019

Hello Asraf, The scripts provided in the documentation for creating the data base and the tables are only provided as an example on how it can be done. CREATE DATABASE [patstat2019b] ON PRIMARY ( NAME = N'patstat2019b_dat', FILENAME = N'D:\mssql_dbs\patstat2019b\patstat2019bdat.mdf' , SIZE = 200000M...
by EPO / PATSTAT Support
Wed Jan 15, 2020 2:00 pm
Forum: PATSTAT Product Line
Topic: Missing data on inventor Origin
Replies: 2
Views: 897

Re: Missing data on inventor Origin

Hello Ucindami, indeed, replenishment via the priority filings or the family members is the best approach to add the missing country codes. The EPO will make available any country information it receives from the respective national patent offices. And we will not replenish any person country data o...
by EPO / PATSTAT Support
Tue Dec 10, 2019 9:27 am
Forum: PATSTAT Product Line
Topic: countrow for PATSTAT Global
Replies: 1
Views: 595

Re: countrow for PATSTAT Global

Hello Patty,
the easiest check is to do a record count on all of the tables.
In the attached file you will find the SQL query and the results is should show for PATSTAT Autumn 2019 - with the understanding that you loaded all tables and files.
TestScripts.zip
(1.29 KiB) Downloaded 81 times
by EPO / PATSTAT Support
Mon Nov 25, 2019 12:58 pm
Forum: PATSTAT Product Line
Topic: Including variables without ID in the table
Replies: 3
Views: 1671

Re: Including variables without ID in the table

Hello Richard, table TLS214_NPL_PUBLN can be linked to TLS212_CITATION via the attribute NPL_PUBLN_ID. Here is a query that extract all citation information (exept the citation categories) from a single patent applications. SELECT citing.appln_id, citing.publn_auth, citing.publn_nr, citing.publn_kin...
by EPO / PATSTAT Support
Tue Nov 12, 2019 5:06 pm
Forum: PATSTAT Product Line
Topic: Including variables without ID in the table
Replies: 3
Views: 1671

Re: Including variables without ID in the table

Hello Richard, "Connecting" or "linking" tables in PATSTAT is done via the different kinds of SQL "JOIN" s. A JOIN clause is used to combine rows from two or more tables, based on (a) related column(s) between them. This "related column" is very often the primary key or a combination of "foreign key...
by EPO / PATSTAT Support
Mon Nov 04, 2019 3:05 pm
Forum: PATSTAT Product Line
Topic: Counting domestic patents applied internationally
Replies: 10
Views: 5539

Re: Counting domestic patents applied internationally

1980 was the first year EP patents were granted. select year(publn_date) grant_date , count(appln_id) #_applications from tls211_pat_publn where publn_kind = 'B1' and publn_auth = 'EP' group by year(publn_date) order by year(publn_date) So it makes sense that no renewal fees records are available fr...
by EPO / PATSTAT Support
Mon Nov 04, 2019 2:06 pm
Forum: PATSTAT Product Line
Topic: PCT route, international patents and the EP application authority
Replies: 3
Views: 2085

Re: PCT route, international patents and the EP application authority

Hello Ucindami, your questions are rather related to the patent application & granting procedure. A good introduction to the general rules for EP and PCT (international) applications are the "Guide for applicants", which you can find at this link: http://documents.epo.org/projects/babylon/eponet.nsf...
by EPO / PATSTAT Support
Fri Oct 25, 2019 10:52 am
Forum: PATSTAT Product Line
Topic: triadic patents -query help
Replies: 5
Views: 3491

Re: triadic patents -query help

Hello Thomas, the concept of OECD triadic families is not based on EPO (DocDB % INPADOC) patent families. For more information on the OECD approach, kindly have a look at the attached documents: OECD Triadic patent families methodology.pdf OECD Triadic Patent Families - Sept 2017.pdf Replicating the...
by EPO / PATSTAT Support
Tue Oct 22, 2019 5:20 pm
Forum: PATSTAT Product Line
Topic: Counting domestic patents applied internationally
Replies: 10
Views: 5539

Re: Counting domestic patents applied internationally

"My intention is to capture the level of innovation at the country level." Many researchers are using the first priority filing to measure innovative capacity. But it does not work for EP and WO applications (or other regional offices) where no priority was filed. ... In which case they mostly use t...