Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers

Schedule

Presented by:

Untitled auto x2

Ibrar Ahmed

pgEdge

Ibrar Ahmed, Principal Engineer at pgEdge, brings 25 years of experience in software design and open-source development, particularly PostgreSQL. With a strong background in system-level embedded development, Ibrar has made impactful contributions during his tenure at companies like EnterpriseDB, Percona, and Bitnine. Since 2006, he's been instrumental in enhancing PostgreSQL's core engine, driving performance improvements, and refining essential modules.

His expertise spans MySQL, Oracle, and NoSQL solutions like MongoDB and Hadoop, alongside tools like Hive, HBase, and Spark. A prolific author and blogger, Ibrar shares deep insights into PostgreSQL with several authoritative books. Over the past year, he’s delivered over fifteen talks worldwide at PostgreSQL conferences, further cementing his reputation. His dedication to advancing data management technology continues to shape

No video of the event yet, sorry!

PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as Clickhouse, MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of Foreign Data Wrappers (FDW). This presentation will explain in detail how PostgreSQL FDWs work. It will include a detailed explanation of simple features and will introduce more advanced features that were added in recent versions of PostgreSQL. Examples of these would be to show how aggregate pushdown and join pushdown work in PostgreSQL.

The talk will include working examples of these advanced features and demonstrating their use with different databases. These examples show how data from different database flavors can be used by PostgreSQL, including those from heterogeneous relational databases, and showing NoSQL joins.

Date:
2019 July 5 11:50 CST
Duration:
40 min
Room:
JINGGE HALL TRACK1 - English Track
Conference:
Beijing 2019
Language:
Track:
English Speaker Track
Difficulty:
Medium