Getting Started with PATSTAT Register
  This paper provides a technical introduction to the PATSTAT Register database, which contains bibliographical, procedural and legal status data on patent applications handled by the European Patent Office. It presents eight MySQL queries that cover some of the most relevant aspects of the database for research purposes. It targets academic researchers and practitioners who are familiar with the PATSTAT database and the MySQL language. 
Gaetan de Rassenfosse, Martin Kracker, Gianluca Tarasconi
cs.DB