Geert Boedt and Dan Shalloe, EPO
PATSTAT is the EPO's backbone data set for statistical analysis on bibliographical and legal status patent data. Access to it has recently become a lot easier, with the launch of PATSTAT Online.
Often patent information specialists are confronted with the fact that they know exactly what kind of data they need, but the tools they have available only provide pre-calculated indicators or data sets coming out of a “black box”.
The PATSTAT product line puts the underlying “raw data” at the user's fingertips. If you have very specific needs for (large amounts of) patent data, PATSTAT might be the database you have been looking for.
The workshop will give you an introduction to PATSTAT and how to write SQL queries to extract data. We will be using EPO's “Patent information services for experts” which hosts the complete PATSTAT database on an SQL server. Participants are requested to bring their own laptops for hands-on exercises. A little background knowledge of relational databases will make it easier to enjoy the presentations.