Icon

01_​Create_​ESCO_​network_​with_​SQLite

Create ESCO network with SQLite
Read tables, create ISCO vertices, extract properties Create edges for ISCO taxonomy Create edges between ISCO and Occupations Read skill csv and upload Skill nodes Read Occupation data and upload Occupation vertices,extract upload results and prepare them for joining Join skills and occupations by rids, create a query and upload edges Extract rids for Skill nodes Create ESCO network with SQLiteThis workflow creates an ESCO network with SQLite. It pulls data from text files - ESCO dataset - places them in a database, extracts and manipulates graph data and visualizes the results in OrientDB, the open source NoSQL database managementsystem. The workflow shows the capabalities of OrientDB nodes. It demonstrates ETL processes from SQLite to OrientDB with the help of OrientDB nodes; the Connection, Command and Execute nodes are used. The Connection node is a generalnode to start working with OrientDB; the Command node executes uploading operations and the Execute node performs batch uploads. Note: Before you can run this workflow, you need to create an OrientDB database and user and install the OrientDB extensions from the KNIME Partner Update Site. Read ISCOCreate connectionUpload ISCOConvert responseto tableJoin by codes in order to make edgesUpload OccupationUpload skillsCreating scriptcommandsUpload Skills-OccupationedgesNode 213Upload ISCO taxonomy edgesRead OccupationRead SkillConnect to ISCODatabase Reader OrientDB Connection OrientDB Command JSON to Table Joiner OrientDB Command OrientDB Command String Manipulation Create ISCOTaxonomy Occupation-skilllinks reader OrientDB Execute OrientDB Execute OrientDB Execute Database Reader Database Reader Extract ridsfor Occupation Extract ridsfor ISCO Extract nodesfor Skill Joining Skilland Occupation SQLite Connector Read tables, create ISCO vertices, extract properties Create edges for ISCO taxonomy Create edges between ISCO and Occupations Read skill csv and upload Skill nodes Read Occupation data and upload Occupation vertices,extract upload results and prepare them for joining Join skills and occupations by rids, create a query and upload edges Extract rids for Skill nodes Create ESCO network with SQLiteThis workflow creates an ESCO network with SQLite. It pulls data from text files - ESCO dataset - places them in a database, extracts and manipulates graph data and visualizes the results in OrientDB, the open source NoSQL database managementsystem. The workflow shows the capabalities of OrientDB nodes. It demonstrates ETL processes from SQLite to OrientDB with the help of OrientDB nodes; the Connection, Command and Execute nodes are used. The Connection node is a generalnode to start working with OrientDB; the Command node executes uploading operations and the Execute node performs batch uploads. Note: Before you can run this workflow, you need to create an OrientDB database and user and install the OrientDB extensions from the KNIME Partner Update Site. Read ISCOCreate connectionUpload ISCOConvert responseto tableJoin by codes in order to make edgesUpload OccupationUpload skillsCreating scriptcommandsUpload Skills-OccupationedgesNode 213Upload ISCO taxonomy edgesRead OccupationRead SkillConnect to ISCODatabase Reader OrientDB Connection OrientDB Command JSON to Table Joiner OrientDB Command OrientDB Command String Manipulation Create ISCOTaxonomy Occupation-skilllinks reader OrientDB Execute OrientDB Execute OrientDB Execute Database Reader Database Reader Extract ridsfor Occupation Extract ridsfor ISCO Extract nodesfor Skill Joining Skilland Occupation SQLite Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: artem
Created at: 2019-02-13
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v3.7.2
Tags: OrientDB NoSQL network analysis

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!