Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database.

Saved in:
Bibliographic Details
Title: Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database.
Authors: Taques, Fernando H.1,2 (AUTHOR) fernando.taques@inv.uam.es, Chasco, Coro1 (AUTHOR), Taques, Flávio H.3 (AUTHOR)
Source: Journal of Geographical Systems. Jan2025, Vol. 27 Issue 1, p31-61. 31p.
Subject Terms: *Patent databases, *Patent offices, *Patent applications, *Big data, *Erythropoietin
Abstract: 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. [ABSTRACT FROM AUTHOR]
Database: Energy & Power Source
Full text is not displayed to guests.
FullText Links:
  – Type: pdflink
Text:
  Availability: 1
Header DbId: enr
DbLabel: Energy & Power Source
An: 183484286
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 0
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Taques%2C+Fernando+H%2E%22">Taques, Fernando H.</searchLink><relatesTo>1,2</relatesTo> (AUTHOR)<i> fernando.taques@inv.uam.es</i><br /><searchLink fieldCode="AR" term="%22Chasco%2C+Coro%22">Chasco, Coro</searchLink><relatesTo>1</relatesTo> (AUTHOR)<br /><searchLink fieldCode="AR" term="%22Taques%2C+Flávio+H%2E%22">Taques, Flávio H.</searchLink><relatesTo>3</relatesTo> (AUTHOR)
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <searchLink fieldCode="JN" term="%22Journal+of+Geographical+Systems%22">Journal of Geographical Systems</searchLink>. Jan2025, Vol. 27 Issue 1, p31-61. 31p.
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: *<searchLink fieldCode="DE" term="%22Patent+databases%22">Patent databases</searchLink><br />*<searchLink fieldCode="DE" term="%22Patent+offices%22">Patent offices</searchLink><br />*<searchLink fieldCode="DE" term="%22Patent+applications%22">Patent applications</searchLink><br />*<searchLink fieldCode="DE" term="%22Big+data%22">Big data</searchLink><br />*<searchLink fieldCode="DE" term="%22Erythropoietin%22">Erythropoietin</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: 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. [ABSTRACT FROM AUTHOR]
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=enr&AN=183484286
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.1007/s10109-024-00445-0
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 31
        StartPage: 31
    Subjects:
      – SubjectFull: Patent databases
        Type: general
      – SubjectFull: Patent offices
        Type: general
      – SubjectFull: Patent applications
        Type: general
      – SubjectFull: Big data
        Type: general
      – SubjectFull: Erythropoietin
        Type: general
    Titles:
      – TitleFull: Integrating big data with KNIME as an alternative without programming code: an application to the PATSTAT patent database.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Taques, Fernando H.
      – PersonEntity:
          Name:
            NameFull: Chasco, Coro
      – PersonEntity:
          Name:
            NameFull: Taques, Flávio H.
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Text: Jan2025
              Type: published
              Y: 2025
          Identifiers:
            – Type: issn-print
              Value: 14355930
          Numbering:
            – Type: volume
              Value: 27
            – Type: issue
              Value: 1
          Titles:
            – TitleFull: Journal of Geographical Systems
              Type: main
ResultId 1