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 / Products2 / Postgres-BDR®3 / IoT Solution

IoT Solution by 2ndQuadrant

Build a Highly Available Database Eco-system for the Internet of Things using Postgres-BDR®

IoT Solution by 2ndQuadrant, Postgres-BDR IoT, Database Eco-system for the Internet of Things

The IoT Solution from 2ndQuadrant is a distributed data storage platform for the Internet of Things that provides on-demand horizontal scalability, complex data analytics, and deep learning features. The storage solution can be deployed on-premise, in the cloud, on edge devices, or a hybrid of the three.

With the IoT solution, data can be stored in the form of time series or spatial to run analytics and gain valuable information such as predictive analytics. The IoT solution is powered by Postgres-BDR to ensure up to 99.999% availability, providing scalable and reliable PostgreSQL clusters in a geographically distributed environment.

IoT Solution Features

  • Real-time Analytics. Perform data analytics on large volumes by blending historic and real-time data. This provides the means to convert insights into actions in real-time.
  • Time Series Data. Store precision data, as well as aggregate, normalize and analyze data in a time series. It also provides fast reads/writes, real-time query performance, and database scalability to petabytes.
  • Deep Learning. Run Machine Learning and Artificial Intelligence models on sensors, edge systems, or human data for predictive analytics, anomaly detection, and to improve efficiency of products and services.
  • Geo-Spatial Support. Store, access, manage and analyze spatial data with built-in spatial functions, operators, and indexes using PostGIS.

How BDR Makes It Possible

The IoT Solution is powered by Postgres-BDR’s following key features:

  • Highly scalable PostgreSQL database.
  • Very high availability of nodes – up to 99.999%
  • Multi-master replication of data in a geographically distributed setting.
  • Very fast data processing and storing.
  • Ability to write data locally and run queries across geographic clusters on demand.

Data Security, Privacy and Protection

The 2ndQuadrant IoT Solution ensures privacy, protection, and security for business-critical data. This is addressed through device-level authentication, encryption, and several other security protocols at all tiers of the data store.

Considering the sensitivity of IoT device data, the IoT Solution uses selective replication technology to allow users to control the node locations in which their data can be stored. This helps ensure that all nodes comply with local data protection laws. In addition, this data is partitioned in a way to make it easier to delete, ensuring compliance to regulations and retention policies.

SLA-based Production Support

The IoT Solution is backed by 2ndQuadrant’s world renowned, SLA-based Production Support – which guarantees a 15-minutes initial response, a workaround within 4 hours, and a bug fix within 24 hours.

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
×