Icon

11. Database

Database

Exercise 11 for KNIME User Training
- Writing data into a database
- Reading data from a database
- Aggregating data in a database
- Filtering data in a database
- Joining data in a database
- Reading data in a database into a KNIME table

Activity: Databases- Connect to the database.mv.db database with the H2 Connector node- Write the Fully Joined Data into the database as a new table called adult- Select the adult table in the database- Count the number of records per product- Filter out products that occur less than 1000 times by joining the aggregated and the original database table- Read the filtered database table into a KNIME data table H2 Connector Fully Joined Data Activity: Databases- Connect to the database.mv.db database with the H2 Connector node- Write the Fully Joined Data into the database as a new table called adult- Select the adult table in the database- Count the number of records per product- Filter out products that occur less than 1000 times by joining the aggregated and the original database table- Read the filtered database table into a KNIME data table H2 Connector Fully Joined Data

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: knime
Created at: 2014-06-17
On NodePit since: 2021-12-06
Last update: 2024-04-27
Created with KNIME version: v4.4.0
Tags: databaseH2database preprocessingeducation

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

Try NodePit Runner!