Icon

10. Database - solution

Database - Solution

Solution to the 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 Read data intoKNIMEGroup by productsCount occurrencescount > 1000Filter to productsin bottom tableRead adult tableWrite adult tableinto database H2 Connector DB Reader DB GroupBy DB Row Filter DB Joiner DB Table Selector Fully Joined Data Fully Joined Data DB Writer 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 Read data intoKNIMEGroup by productsCount occurrencescount > 1000Filter to productsin bottom tableRead adult tableWrite adult tableinto database H2 Connector DB Reader DB GroupBy DB Row Filter DB Joiner DB Table Selector Fully Joined Data Fully Joined Data DB Writer

Nodes

Extensions

Links