Hub

62 results

Filter
SQL
Database Education Database preprocessing H2 Life science
+2
  1. 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
  2. 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
  3. 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
  4. Workflow
    demonstrates the use of DB Update and DB Merge with MS Access DB
    Ms Access Sql
    +5
    demonstrates the use of DB Update and DB Merge with MS Access DB
    mlauber71 > Public > kn_example_db_update_merge_ms_access
    1
  5. 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
    1
  6. Workflow
    School of duplicates - and how to deal with them - H2 version
    Sql Duplicates Remove
    +7
    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_db_h2
    0
  7. Workflow
    Model Deployment SQL Recoding
    Deployment File Database
    +7
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from a database, reads the…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
    0
  8. Workflow
    An overview of KNIME based functions to access big data systems (with KNIME's local big data environment)
    Knime Sql Db
    +5
    An overview of KNIME based functions to access big data systems (with KNIME's local big data environment) Use SQL with Impala/Hiv…
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_020_db_access_local_bigdata_tables
    0
  9. 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.
    burdhasp > Public > Exercises - L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02_Database_Data_Manipulation
    0
  10. Workflow
    remove duplicates with condition and add the last date
    H2 SQL Rank
    +1
    remove duplicates with condition and add the last date
    mlauber71 > Forum > 2022 > kn_forum_38543_rank_deduplicate
    0
  11. 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
    0
  12. Workflow
    use H2 and KNIME to realize a BETWEEN match of timestamps
    Sql Join Time
    +3
    use H2 and KNIME to realize a BETWEEN match of timestamps…
    mlauber71 > Public > kn_example_db_h2_join_by_timestamp > m_001_db_h2_join_timestamp
    0
  13. Workflow
    Create HIVE table and show the way it was created and describe the structure
    Hive Big data Knime
    +3
    Create a Big Data table, show the structiure and fields
    mbergman > Public > kn_example_hive_create_table_show_describe
    0
  14. Workflow
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a databas…
    janina > Customized Training > Customized Training - Life Sciences > Solutions > 05. Database - solution
    0
  15. Workflow
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a databas…
    pau22nanda > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    0
  16. Workflow
    Example how to use H2 database with a uuid unique identifier
    H2 Sql Create
    +6
    Example how to use H2 database with a uuid unique identifier
    mlauber71 > Forum > 2021 > kn_forum_36064_db_h2_use_uuid_unique_identifier
    0
  17. Workflow
    Database
    Database Database preprocessing Education
    +2
    "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a database - Filterin…
    ciaccindr > Public > Corso2022 > L1-LS > Exercises > 05. Database
    0
  18. Workflow
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a databas…
    ciaccindr > Public > Corso2022 > L1-LS > Solutions > 05. Database - solution
    0
  19. Workflow
    An overview of KNIME based functions to access big data systems - use it on your own big data system (including PySpark)
    Knime Sql Db
    +5
    An overview of KNIME based functions to access big data systems - use it on your own big data system (including PySpark) Use SQL …
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_120_db_access_bigdata_tables
    0
  20. Workflow
    use H2 to produce a Position / Rank number within a group variable (window functions)
    Position Rank Nulls
    +6
    use H2 to produce a Position / Rank number within a group variable (window functions) use custom JDBC driver - THX tobias.koetter…
    mlauber71 > Public > forum > kn_forum_31608_h2_group_rank_window_function
    0