Federation with Foreign Data Wrappers PGDay IT 20131025

  • Slides: 63
Download presentation
Federation with Foreign Data Wrappers PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. fetter@disqus.

Federation with Foreign Data Wrappers PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. fetter@disqus. com All rights reserved.

Table Virtual Interface

Table Virtual Interface

Index Virtual Interface

Index Virtual Interface

SQL/MED

SQL/MED

<DIGRESSION>

<DIGRESSION>

EXTENSION S!

EXTENSION S!

</DIGRESSION>

</DIGRESSION>

<PAST>

<PAST>

SQL/MED in Postgre. SQL contrib/dblink

SQL/MED in Postgre. SQL contrib/dblink

SQL/MED in Postgre. SQL DBI-Link

SQL/MED in Postgre. SQL DBI-Link

Time Passes. . .

Time Passes. . .

Postgre. SQL 8. 4

Postgre. SQL 8. 4

Infrastructure Only

Infrastructure Only

Postgre. SQL 9. 0

Postgre. SQL 9. 0

More Infrastructure

More Infrastructure

Postgre. SQL 9. 2

Postgre. SQL 9. 2

Reads ANALYZE

Reads ANALYZE

</PAST >

</PAST >

<PRESENT >

<PRESENT >

Postgre. SQL 9. 3

Postgre. SQL 9. 3

WRITES!

WRITES!

Wrappers. Lots of Wrappers.

Wrappers. Lots of Wrappers.

<SQL >

<SQL >

Oracle

Oracle

My. SQL

My. SQL

ODBC

ODBC

</SQL >

</SQL >

<No. SQL>

<No. SQL>

Couch. DB

Couch. DB

Redis

Redis

</No. SQL>

</No. SQL>

<File>

<File>

file

file

file_text_array

file_text_array

</File>

</File>

<Creativity>

<Creativity>

Twitter

Twitter

LDAP

LDAP

S 3

S 3

</Creativity>

</Creativity>

More!

More!

PGXN

PGXN

Multicor n

Multicor n

<New_Commands>

<New_Commands>

{CREATE | ALTER | DROP} FOREIGN DATA WRAPPER

{CREATE | ALTER | DROP} FOREIGN DATA WRAPPER

{CREATE | ALTER | DROP} SERVER

{CREATE | ALTER | DROP} SERVER

{CREATE | ALTER | DROP} USER MAPPING

{CREATE | ALTER | DROP} USER MAPPING

</New_Commands>

</New_Commands>

<INTROSPECTION >

<INTROSPECTION >

Remote Partitioning • Expose information_schema. columns. • Create view over them. • Create foreign

Remote Partitioning • Expose information_schema. columns. • Create view over them. • Create foreign table generator.

</INTROSPECTION >

</INTROSPECTION >

</PRESENT >

</PRESENT >

<FUTURE>

<FUTURE>

<INTROSPECTION >

<INTROSPECTION >

CREATE FOREIGN TABLE (…LIKE. . . )

CREATE FOREIGN TABLE (…LIKE. . . )

More and better.

More and better.

</INTROSPECTION >

</INTROSPECTION >

Full SQL/MED Compliance

Full SQL/MED Compliance

The ever-interesting: Stuff I Never Thought Of

The ever-interesting: Stuff I Never Thought Of

</FUTURE>

</FUTURE>

Molte Grazie! PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. fetter@disqus. com All rights

Molte Grazie! PGDay. IT 2013/10/25 Copyright© 2013 David Fetter david. fetter@disqus. com All rights reserved.