Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers

Schedule

Presented by:

Ibrar

Ibrar Ahmed

Percona LLC

Ibrar Ahmed is a Senior Software Architect in Percona LLC. Prior to coming to open source development, he had vast experience in software design and development. The main focus was on the system level embedded development. After joining EnterpriseDB, an Enterprise PostgreSQL company in 2006 he started his career in open source development specifically in PostgreSQL. He has contributed to the PostgreSQL community as well as other open source communities. His contribution is from the main performance feature enhancements to various PostgreSQL modules. In the database field, he has experience in other well-known databases MySQL, Oracle, and NoSQL databases such as MongoDB and Hadoop. His experience is not limited to core databases, but with the tools related to databases like Hive, HBase and Spark. He also worked on integrating these tools with PostgreSQL.

He gave more than fifteen PostgreSQL talks in the last one year in various parts of the World (PostgreConf-EU, PostgreConf-ASIA, PostgreConf-NY, Percona Lives, etc ). He also authored multiple books on PostgreSQL.

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