Publication

Getting Started with PATSTAT Register

Gaétan Jean A de Rassenfosse
2017
Journal Articles

Abstract

This article 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.

Official source

https://infoscience.epfl.ch/entities/publication/acfc155a-7cdd-47ae-bf11-8fac00d04fdd

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Gaétan Jean A de Rassenfosse
2017
Journal Articles

Abstract

Official source

https://infoscience.epfl.ch/entities/publication/acfc155a-7cdd-47ae-bf11-8fac00d04fdd

About this result

Related concepts (13)

MySQL

MySQL (ˌmaɪˌɛsˌkjuːˈɛl) is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database.

Database

In computing, a database is an organized collection of data (also known as a data store) stored and accessed electronically through the use of a database management system. Small databases can be stored on a , while large databases are hosted on computer clusters or cloud storage. The design of databases spans formal techniques and practical considerations, including data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues, including supporting concurrent access and fault tolerance.

Relational database

A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL (Structured Query Language) for querying and updating the database. The term "relational database" was first defined by E. F. Codd at IBM in 1970. Codd introduced the term in his research paper "A Relational Model of Data for Large Shared Data Banks".

Related publications (29)

Long plasma duration operation analyses with an international multi-machine (tokamaks and stellarators) database

Stefano Coda, Jeffrey Huang

Combined high-fusion performance and long-pulse operation is one of the key integration challenges for fusion energy development in magnetic devices. Addressing these challenges requires an integrated vision of physics and engineering aspects with the purp ...

IOP Publishing Ltd2024

GELEX: Generative AI-Hybrid System for Example-Based Learning

Tanja Christina Käser Jacober, Paola Mejia Domenzain, Aybars Yazici, Jibril Albachir Frej

Traditional example-based learning methods are often limited by static, expert-created content. Hence, they face challenges in scalability, engagement, and effectiveness, as some learners might struggle to relate to the examples or find them relevant. To a ...

Association for Computing Machinery2024

Insights from an extensive triaxial testing campaign on a shale for comparative site characterization of a deep geological repository

Lyesse Laloui, Alessio Ferrari, Eleonora Crisci

Several boreholes were drilled for site comparison of a deep geological repository (DGR) in Northern Switzerland. The main target of the exploration program was the >100m thick Opalinus Clay, the designated host rock encountered at approximately 450 to 100 ...

Elsevier2024