PGCon2011 - Final (2011.06.11)

PGCon 2011
The PostgreSQL Conference

Speakers
Yotaro Nakayama
Schedule
Day Talks - 1 - 2011-05-19
Room DMS 1140
Start time 13:30
Duration 01:00
Info
ID 353
Event type Lecture
Track Advanced Features
Language used for presentation English
Feedback

Real Federation Database System leveraging PostgreSQL FDW

Federation Database System solves transparent access to heterogeneous DBMS to realize Optimized Database schema design according to optimized business process. Our database team develops Real Federation Database System leveraging PostgreSQL FDW. This federation system enhances the current optimization of Foreign Scan and adds Foreign Data Wrapper for another RDBMS such as Oracle and Microsoft SQL Server.

We implement Federation Database System using PostgreSQL FDW and realize following things:

  • Access heterogeneous external data source as local data
  • Location, Vendor and Platform Transparency
  • Without change of existing system change
  • Real-time Data Reference and Data Update These features give us various advantages as follows:
  • Optimization of Business Process across multiple business systems
  • Integrated Database access
  • Avoidance of redundant data management My presentation explains the development technique for Federation Database System based on PostgreSQL FDW. It includes the optimization technique for heterogeneous distributed database access and integration technique of Foreign Data Wrapper to heterogeneous RDBMS (e.g. Oracle and Microsoft SQL Server) and so on. And also we would like to discuss the requirements for new Federation Database System for this cloud era.