2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
    • Support
      • 24/7 PostgreSQL Support
      • Developer Support
    • DBA Services
      • Remote DBA
      • Database Monitoring
    • Consulting Services
      • Health Check
      • Performance Tuning
      • Database Security Audit
      • PostgreSQL Upgrade
    • Migration Services
      • Migrate to PostgreSQL
      • Migration Assessment
  • Products
    • Postgres-BDR ®
    • PostgreSQL High Availability
    • Kubernetes Operators for BDR & PostgreSQL
    • Managed PostgreSQL in the Cloud
    • Installers
      • Postgres Installer
      • 2UDA
    • 2ndQPostgres
    • pglogical
    • Barman
    • repmgr
    • OmniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Multi-Master Replication in PostgreSQL
      • PostgreSQL with High Availability
      • Security Best Practices for PostgreSQL
      • BDR
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Multi-Master Replication in PostgreSQL
      • PostgreSQL with High Availability
      • Security Best Practices for PostgreSQL
      • BDR
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Blog2 / 2ndQuadrant3 / Image classification using 2UDA – Orange
Image classification using 2UDA – Orange
Semab Tariq

Image classification using 2UDA – Orange

August 31, 2020/0 Comments/in 2ndQuadrant /by Semab Tariq

In this article, We are going to perform analysis on different images of Animals like. Cats, Cows, Fish, Dogs, and Elephants and based on the feature set of every image we will try to see if our model is able to classify each Animal into the correct category or not. The expected result should be

  • Our model should determine the Animal type from the image.
  • Each image of Cat should go into the Cat category.
  • Each image of Cow should go into the Cow category.
  • Each image of Dog should go into Dog category.
  • Each image of Elephant should go into the Elephant category.
  • Each image of Fish should go into the Fish category.

Software versions and Operating system information

We are going to use 2UDA version 12.4-1 for Windows to implement Image classification. This version combines:

  • PostgreSQL 12.4
  • Orange 3.26.0

You can find the latest version of 2UDA here.

Step 1:

Select Animal images

  • Create a local folder named Animals. And place about 5 images of each animal in that folder. 

Below is the screenshot of the folder which contains 25 different images

 

Step 2:

Create a workflow with orange

  • Go to the desktop and double click on the Orange icon.
  • Create a blank project by clicking on New from the menu.

 

Step 3:

Load images into Orange

  • Drag and drop Import Images widget from Image Analytics menu

  • Double click on Import Images widget and select the folder which contains Animal images.

  • We can also view the data in the Data Table widget. Drag and drop Data Table widget from the Data menu. Connect it with Import Images widget double click on Data Table widget to view the results.

 

Step 4:

Image Embedding

Above data, table results are very limited and cannot be used in machine learning. To get more information from images we need to use a widget called Image Embedding. Image Embedding reads images and uploads them to a remote server or evaluate them locally. Deep learning models are used to calculate a feature vector for each image. It returns an enhanced data table with additional columns (image descriptors).

NOTE: If you do not want to upload images to a remote server and let these servers evaluate your images. Then you can even select the local option under the Embedder option to evaluate images locally on your computer. This is a small and fast model but final results can be different as compare to online models. 

  • Drag and drop Image Embedder widget from Image Analytics menu and connect it with the Import Image widget
    NOTE: Double click on Image Embedder widget if you want to change the Embedding option to local.

  • To view, the results connect Image Embedding widget to the data table widget from the data menu

  • We can now see hundreds of columns against one image. These columns determine features of one image and that data will be used to categorize the images at the end.

Step 5:

Compute a distance between rows or columns

The distance widget will compute the distance between rows/columns.

  • Drag and drop Distance widget from Unsupervised menu
  • Connect Image Embedding widget to Distance widget

  • Select Distance Metric as Cosine.

Step 6:

Hierarchical clustering

This widget is used to group items using a hierarchical clustering algorithm.

  • Drag and drop hierarchical clustering widget from Unsupervised menu
  • Connect Distance widget with hierarchical clustering widget

Step 7:

View the results

Now we can see results in Image Viewer.

  • Drag and drop the Image Viewer widget from Image Analytics menu
  • Connect Image Viewer widget with Hierarchical Clustering widget.

  • Double click on Hierarchical Clustering and Image viewer widget to open.

We can see the Hierarchical Clustering widget is successfully able to determine 5 groups. We can also select a group to see images in the Image Viewer widget.

Select other groups in the Hierarchical Clustering widget output to view the results.

 

For any questions or comments, please get in touch using the contact form here

 

Tags: 2UDA, Hierarchical clustering, Image analytics, Image embedding, Orange
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Get in touch with us!

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Featured External Blogs

Tomas Vondra's Blog

Our Bloggers

  • Simon Riggs
  • Alvaro Herrera
  • Andrew Dunstan
  • Craig Ringer
  • Francesco Canovai
  • Gabriele Bartolini
  • Giulio Calacoci
  • Ian Barwick
  • Marco Nenciarini
  • Mark Wong
  • Pavan Deolasee
  • Petr Jelinek
  • Shaun Thomas
  • Tomas Vondra
  • Umair Shahid

PostgreSQL Cloud

2QLovesPG 2UDA 9.6 backup Barman BDR Business Continuity community conference database DBA development devops disaster recovery greenplum Hot Standby JSON JSONB logical replication monitoring OmniDB open source Orange performance PG12 pgbarman pglogical PG Phriday postgres Postgres-BDR postgres-xl PostgreSQL PostgreSQL 9.6 PostgreSQL10 PostgreSQL11 PostgreSQL 11 PostgreSQL 11 New Features postgresql repmgr Recovery replication security sql wal webinar webinars

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Advanced partition matching for partition-wise join Advanced partition matching for partition-wise join Parallelism comes to VACUUM Parallelism comes to VACUUM
Scroll to top
×