Search found 232 matches
- 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...
- 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...
- 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...
- 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.
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.
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...