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
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • 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
      • Security Best Practices for PostgreSQL
    • 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 / 2UDA

2UDA

Create and Visualize Machine Learning Models Using 2UDA

2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite that unifies databases, machine learning, data mining, and visualization. The application can be installed using a user-friendly, one-click desktop installer.

2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite. This one-click desktop installer has the ability to unify databases, machine learning, data mining, and visualization.

2UDA builds on the capabilities of Orange, an open source machine learning and data visualization tool, by integrating it with the PostgreSQL database.

How 2UDA Works

To perform complex data analytics using 2UDA, machine learning models (supervised and unsupervised) are loaded from Orange and deployed into the PostgreSQL database. Currently, all popular machine learning models such as PCA, K-Means, KNN, SVM, Naive Bayes, and Logistic Regression can be used to train the dataset. These models are then used to build interactive visualizations to explore regression analyses, statistical distributions, decision trees, heatmaps, hierarchical clustering, and linear projections.

Download and Install

The 2UDA installer is available to download for Windows, macOS, and Linux and supports five (5) languages: English, French, German, Italian, and Spanish.

The 2UDA installer is available to download for Windows with support for PostgreSQL 9.5.23 and above.

9.6.24 – 10.20

11.15 – 12.10 – 13.6

The 2UDA installer is available to download for MacOS and supports PG 9.5.23 and above.

9.6.24 – 10.20

11.15 – 12.10 – 13.6

The 2UDA installer for PostgreSQL is available to download for Linux.

9.5 – 9.6 – 10

11

If you need to install a standalone version of PostgreSQL, use Postgres Installer for an easy, GUI-based installation.

Known Issues

  • The following PostGIS extensions are currently supported only on Windows.
    • postgis_sfcgal
    • address_standardizer
  • Support for macOS Catalina is not yet available.
  • Support for the installation of multiple major versions of 2UDA on a single server is not yet available. However, it is on the roadmap.

Support for other platforms will be added in later versions.

Availability

2UDA for PostgreSQL 9.5.25, 9.6.21, 10.16, 11.11, 12.6 and  13.2 was released on February 12, 2021

Feedback

For feedback or queries related to 2ndQuadrant Unified Data Analytics, email us at [email protected].

2UDA Knowledge Base

Blogs

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 […]

Read more

Machine‌ ‌Learning‌ ‌with‌ ‌2UDA‌ ‌-‌ ‌PostgreSQL‌ ‌and‌ ‌ Orange‌ ‌-‌ ‌Concluding‌ ‌the‌ ‌series‌

July 17, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

In this blog series, we have covered the following machine learning models to utilize Machine Learning capabilities with 2UDA. KNN SVM Random Forest Tree Logistic Regression AdaBoost Neural Network Now we are bringing you a recap of this blog series in order to summarize the results we obtained through these models in a single post. […]

Read more

How to use Neural Network Machine Learning model with 2UDA – PostgreSQL and Orange (Part 7)

June 25, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we will use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We are going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL […]

Read more
View All Blogs

Get in touch with us!

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
Scroll to top
×