Using FDW Like Never Before
Henrietta Dombrovskaya is a database researcher and developer with over 30 years of academic and industrial experience. She holds a Ph.D. in Computer Science from University of Saint Petersburg, Russia. She taught Database and Transaction theory at the University of Saint – Petersburg (Russia), as well as multiple database tuning classes for both beginners and advanced professionals.
Her professional experience includes consulting for a number of government projects in Chicago and New York, and providing Data services in the financial sector, manufacturing, and distribution. She is a co-author, with B. Novikov, of the book “System Tuning”, BHV, S.-Petersburg, Russia. Her researches in overcoming object-relational impedance mismatch were publish in the Proceedings of EDBT 2014 Athens and ICDE 2016 in Helsinki. At Braviant Holdings she is happy to have an opportunity to implement the results of her research in practice
Henrietta Dombrovskaya is a co-organizer of the Chicago PostgreSQL User Group
At Braviant Holdings we consider foreign data wrappers to be the best thing even introduced in PostgreSQL. We use them virtually everywhere, both for our apps which interact with OLTP databases and for the ETL for our Data Warehouse.
One of the best things about using the FDW is that they allow you to map objects of various types. You can map tables, views, other foreign tables, you can use indexes remotely/ You can even map a query!
But what about mapping functions? Strictly speaking, there is no way, but as usual, when there is a will, there is a way.
In this talk we will show how ability to call the functions remotely assisted our transition from the legacy system to the newly designed service-based framework and allowed to maintain the data accuracy and consistency.
- 2019 March 20 09:00
- 20 min
- Postgres Conference