Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database [Data set]

DOI

Dataset accompanying the publication "Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database ". Accessing massive datasets can be challenging for users unfamiliar with programming codes. Combining Konstanz Information Miner (KNIME) and MySQL tools on standard configuration equipment allows for addressing this issue. This research proposal aims to present a methodology that describes the necessary configuration steps in both tools and the required manipulation in KNIME to transmit the information to the MySQL environment for further processing in a database management system (DBMS). In addition, we propose a procedure so that the use of this point-and-click software in research work can gain in reproducibility and, therefore, in credibility in the scientific community. To achieve this, we will use a big database regarding patent applications as a reference, the PATSTAT Global 2023, provided by the European Patent Office (EPO). As well known, patent data can be a valuable source for understanding innovation dynamics and technological trends, whether for studies on companies, sectors, nations or even regions, at aggregated and disaggregated levels.

How to cite the database (APA style): Taques, F.H.; Chasco, C. & Taques, F. (2024) Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database [Data set] (doi: 10.23728/b2share.645943e855924aa299a2e2dc873ce530) Source: Taques, F.H.; Chasco, C. & Taques, F. (2024) Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database. Journal of Geographical Systems (doi: 10.1007/s10109-024-00445-0).

Identifier
DOI https://doi.org/10.23728/b2share.645943e855924aa299a2e2dc873ce530
Source https://b2share.eudat.eu/records/645943e855924aa299a2e2dc873ce530
Metadata Access https://b2share.eudat.eu/api/oai2d?verb=GetRecord&metadataPrefix=eudatcore&identifier=oai:b2share.eudat.eu:b2rec/645943e855924aa299a2e2dc873ce530
Provenance
Creator Taques, Fernando Henrique; Chasco, Coro; Taques, Flavio
Publisher EUDAT B2SHARE
Publication Year 2024
Funding Reference Regional Studies Association (RSA)
Rights Creative Commons Attribution-NonCommercial-ShareAlike (CC-BY-NC-SA); info:eu-repo/semantics/openAccess
OpenAccess true
Contact coro.chasco(at)uam.es
Representation
Language English
Format zip; xlsx
Size 44.5 MB; 2 files
Discipline 2.5.6 → Economics → Computational economics; 4.1.16.1 → Information science → Data management; 4.1.16.3.1 → Database → Relational database; 5.3.3 → Business → Business analysis
Spatial Coverage (4.352 LON, 50.850 LAT); Europe
Temporal Coverage 2000-2022