About OPEN

Name: Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers
Start: 2019-1-17T18-18-00-00
End: 2019-1-17T20-20-00-00
Location: Alachisoft

OPEN (Organisation of Pakistani Entrepreneurs) is a global network of Pakistani entrepreneurs and professionals, with chapters in 13 cities from Silicon Valley to New York to London to Islamabad. OPEN provides a platform for Pakistani entrepreneurs and professionals of a city to connect, network, collaborate, mentor and support each other. For more than 15 years, OPEN has established itself as the most reputed global brand of Pakistani professionals and has helped countless in their entrepreneurial journeys.

Upcoming Events

Event Type:

All

SIG:

All

In Collaboration With:

All

Event Location:

All

event speaker:

All

2019thu17jan6:00 pmthu8:00 pmJoin Heterogeneous Databases using PostgreSQL Foreign Data WrappersPostgreSQL - SIG - 146:00 pm - 8:00 pm Alachisoft, Plot 43, Street 36, G-10/4 G 10 Markaz, Islamabad

Event Details

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 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 column store joins.

Who Should Attend?

Database enthusiasts.

Participation Charges

Free

RSVP to event

Make sure to RSVP to this amazing event!

YesNoMaybe

OpenSpaces Still Available

Speakers for this event

Ibrar Ahmed

Ibrar Ahmed

FinTech Speaker Senior Software Engineer @ Percona
Ibrar Ahmed is a Agile Software / PostgreSQL Architect, Blockchain Crypto Currency / FinTech Speaker Senior Software Engineer @ Percona. He has 18+ years of Software development experience, ranges from architecting the software to extreme programming in C, C++, Visual C++, Java. Experience in development in Windows, Linux, Solaris, HP-UX and PowerPC.

FinTech Speaker Senior Software Engineer @ Percona