Hub

74 results

Filter
SQL
Database Education H2 Database preprocessing Life science SQLite Knime
  1. Workflow
    Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an embedded script editor. These nodes can be…
    knime > Examples > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    2
    knime
  2. Workflow
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
    Database Sql Hive
    +11
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark) KNIME as a powerful data anaylytics platfo…
    mlauber71 > Public > _db_sql_bigdata_hive_spark_meta_collection
    1
    mlauber71
  3. Workflow
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    Sql Sqlite Loop
    +2
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    mlauber71 > Public > kn_example_db_loop_multiple_tables
    1
    mlauber71
  4. Workflow
    Decision Tree with all its exports
    Machine learning Decision tree Sql
    +3
    A simple decision tree with all the possibilities to store the results (as PMML or Ruleset or SQL Code) and evaluation (ROC curve
    mlauber71 > Public > kn_example_decision_tree
    1
    mlauber71
  5. Workflow
    Play around with SQLite and Date and Time functions
    Sql Date Time
    +2
    Play around with SQLite and Date and Time functions
    mlauber71 > Public > kn_example_db_sqlite_timestamp
    1
    mlauber71
  6. Workflow
    School of duplicates - and how to deal with them
    Sql Duplicates Remove
    +1
    Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easienst ways to deal with…
    mlauber71 > Public > kn_example_duplicates_school_of
    1
    mlauber71
  7. Workflow
    demonstrates the use of DB Update and DB Merge with MS Access DB
    Ms Access Sql
    +6
    demonstrates the use of DB Update and DB Merge with MS Access DB
    mlauber71 > Public > kn_example_db_update_merge_ms_access
    1
    mlauber71
  8. Workflow
    15_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME …
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 15_Database_Data_Manipulation - Solution
    0
    stervis
  9. Workflow
    15_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 15_Database_Data_Manipulation
    0
    stervis
  10. Workflow
    02_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME …
    stervis > Public > E-Learning > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 02_Database_Data_Manipulation - Solution
    0
    stervis
  11. Workflow
    Decision Tree with all its exports
    Machine learning Decision tree Sql
    +3
    A simple decision tree with all the possibilities to store the results (as PMML or Ruleset or SQL Code) and evaluation (ROC curve
    andriyansyah > Public > kn_example_decision_tree
    0
    andriyansyah
  12. Workflow
    02_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    stervis > Public > E-Learning > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02_Database_Data_Manipulation
    0
    stervis
  13. Workflow
    Play around with SQLite and Date and Time functions
    Sql Date Time
    +2
    Play around with SQLite and Date and Time functions
    deganza > Public > KNIME_Solutions_for_real_applications > c2.1_Data_Access_with_KNIME_SQL_and_Co > Data Access - 03 Databases example
    0
    deganza
  14. Workflow
    add fields to Hive table
    Hive Sql Big data
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > kn_example_bigdata_hive_add_column
    0
    mlauber71
  15. Workflow
    add fields to Hive table
    Hive Sql Big data
    +2
    Use KNIME and Hive/SQL syntax to add columnd to a Big Data table (migrated to KNIME 4.0 and new DB nodes)
    mlauber71 > Public > kn_example_bigdata_hive_add_column_db_40
    0
    mlauber71
  16. Workflow
    H2 do an UPDATE on the server using a VIEW of the existing and the new data
    H2 Update Append
    +2
    H2 do an UPDATE on the server using a VIEW of the existing and the new data
    mlauber71 > Public > kn_example_db_h2_update_in_databse
    0
    mlauber71
  17. Workflow
    Example how to use H2 database to create table with upload and from scratch
    H2 Sql Create
    +5
    Example how to use H2 database to create table with upload and from scratch H2 is an SQL database that 'lives' in a single file o…
    mlauber71 > Public > kn_example_db_h2_create_table_from_scratch
    0
    mlauber71
  18. Workflow
    demonstrates the use of DB Update and DB Merge
    H2 Update Merge
    +2
    demonstrates the use of DB Update and DB Merge
    mlauber71 > Public > kn_example_db_update_merge
    0
    mlauber71
  19. Workflow
    create table in MySQL
    Mysql Sql Db
    +1
    create table in MySQL
    mlauber71 > Public > kn_example_db_mysql
    0
    mlauber71
  20. Workflow
    Construct a Right Join with SQLite
    Sql Sqlite Join
    +2
    I built a workflow that does that also to play around with SQLite and to see what it could do. I have two databases that both hav…
    mlauber71 > Public > kn_example_db_sqlite_right_joiner_loop
    0
    mlauber71