Icon

01 Practicing with Traditional Databases

01 Practicing with Traditional Databases
Exercise 1: Practicing with Traditional DatabasesIn this exercise you'll create a database table, and load and manipulate data in the database1) Read the AirlineDataset.table file. The data contain information about US domestic flights in January 2007.2) Connect to the H2 database (database.mv.db file)3) Remove the "airline" table from the database if it exists 4) Create a new table "airline" on the database based on the table specs of the local data table. Use dynamic settings.5) Insert the data into the "airline" database table6) Filter the data to flights that were not cancelled AND had Austin-Bergstrom International Airport (AUS) as destination7) Write the filtered data into a new database table called "airline_Austin" 8) Read the "airline_Austin" table into KNIME9) Optional: Delete the cancelled flights directly on the database with the following statement in the DB SQL Executor node:DELETE from "PUBLIC"."airline" where "Cancelled" = 1; Node 1Node 2Node 3Node 5Node 6Node 10Node 11Node 12Node 13 Table Reader H2 Connector DB Table Remover DB Table Creator DB Writer DB Row Filter DB ConnectionTable Writer DB Reader DB SQL Executor Exercise 1: Practicing with Traditional DatabasesIn this exercise you'll create a database table, and load and manipulate data in the database1) Read the AirlineDataset.table file. The data contain information about US domestic flights in January 2007.2) Connect to the H2 database (database.mv.db file)3) Remove the "airline" table from the database if it exists 4) Create a new table "airline" on the database based on the table specs of the local data table. Use dynamic settings.5) Insert the data into the "airline" database table6) Filter the data to flights that were not cancelled AND had Austin-Bergstrom International Airport (AUS) as destination7) Write the filtered data into a new database table called "airline_Austin" 8) Read the "airline_Austin" table into KNIME9) Optional: Delete the cancelled flights directly on the database with the following statement in the DB SQL Executor node:DELETE from "PUBLIC"."airline" where "Cancelled" = 1; Node 1Node 2Node 3Node 5Node 6Node 10Node 11Node 12Node 13 Table Reader H2 Connector DB Table Remover DB Table Creator DB Writer DB Row Filter DB ConnectionTable Writer DB Reader DB SQL Executor

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: Maarit Laukkanen
Created at: 2021-03-11
On NodePit since: 2021-03-23
Last update: 2024-04-20
Created with KNIME version: v4.3.2
Tags: big datadatabase

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

Try NodePit Runner!