Hub

44 results

Filter
Filter by tag
SQL
Database
Education Database preprocessing Life science SQLite H2 Db E-learning
  1. 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
    knime
  2. 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
  3. Workflow
    Titanic KNIME Beispiel (deutsch) - SQL Datenbanken mit KNIME
    Knime Titanic Einführung
    +6
    Titanic: Machine Learning from Disaster https://www.kaggle.com/c/titanic Einführung in KNIME (deutsch) - https://hub.knime.com/ml…
    mlauber71 > Public > knime_einfuehrung_beispiel_titanic > m_150_sql_database_titanic
    0
    mlauber71
  4. Workflow
    DB Looping Example
    DB Read/Write DB Loop
    +4
    This workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL query that uses the values f…
    knime > Examples > 01_Data_Access > 02_Databases > 24_DB_Looping
    0
    knime
  5. 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
  6. 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…
    haoran > Public > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    0
    haoran
  7. 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
    mlauber71
  8. Workflow
    DB Looping Example
    DB Read/Write DB Loop
    +4
    This workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL query that uses the values f…
    haoran > Public > 01_Data_Access > 02_Databases > 24_DB_Looping
    0
    haoran
  9. Workflow
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment
    DB SQL Node
    +3
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment The…
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_100_db_create_bigdata_tables
    0
    mlauber71
  10. 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
  11. Workflow
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment
    DB SQL Node
    +3
    This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment The…
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_001_db_create_local_bigdata_tables
    0
    mlauber71
  12. Workflow
    Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
    H2 Sql Create
    +5
    Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
    mlauber71 > Public > kn_example_db_h2_primary_key
    0
    mlauber71
  13. 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
    mlauber71
  14. 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
  15. Workflow
    forum 44727 - 01 Practicing with Traditional Databases
    Big data Database H2
    +3
    forum 44727 - 01 Practicing with Traditional Databases
    mlauber71 > Forum > 2022 > kn_forum_44727_l4_bd_course_practice_db_tables
    0
    mlauber71
  16. Workflow
    Load tables from SQLite "Northwind" DB into H2 and make all columns lower case
    Sql Sqlite Northwind
    +3
    Load tables from SQLite "Northwind" DB into H2 and make all columns lower case
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_000_db_prepare_northwind_db
    0
    mlauber71
  17. Workflow
    Prepare the Northwind database into a consistant H2 db to provide a database environment to play with
    H2 SQLIte Northwind
    +3
    These tables are included in the local database
    mlauber71 > Public > kn_example_db_h2_prepare_northwind_db_small > m_001_prepare_northwind_db_h2
    0
    mlauber71
  18. 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
  19. 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
    1
    mlauber71
  20. Workflow
    H2 java based database example
    H2 Database Sql
    H2 is a free database you can use with KNIME either as a file on your drive or as an in memory DB
    mlauber71 > Public > kn_example_h2_database > m_001_h2_db
    0
    mlauber71