Logo TIB AV-Portal Logo TIB AV-Portal

PostgreSQL, batteries included

Video in TIB AV-Portal: PostgreSQL, batteries included

Formal Metadata

PostgreSQL, batteries included
Title of Series
CC Attribution - NonCommercial - ShareAlike 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this license.
Release Date
Production Year
Production Place
Seoul, South Korea

Content Metadata

Subject Area
This presentations presents some advanced features of PostgreSQL involving third party tools integrated directly into the database, and allowing for more features, especially for spatial data management. PostgreSQL is a very versatile RDBMS, and has a lot of core features. What is less known is that it can be used as a data platform, integrating external modules to further expand the capabilities of data management. First of all, some contrib PostgreSQL modules of interest are shown, useful for geocoding : pg trgm allows for trigram indexing and search, allowing string comparison with a tolerance to typo errors fuzzystrmatch also allows fuzzy string comparison directly inside the database using soundex algorithms FTS, aka Full Text Search, is a powerful text indexing and search mechanism right inside PostgreSQL Then, we show the Foreign Data Wrapper tools, which allow access to and from remote data. oracle fdw now supports Oracle Spatial and PostGIS natively, and let you exchange data in heterogeneous systems ogr fdw is a foreign data wrapper dealing with OGR data sources : access all these vector data files directly from your spatial database Foreign Data Wrapper really makes PostgreSQL a data platform, enabling easy import and export of data, migration plan, and transparent heterogeneous data systems. Last, we present some advanced data processing capabilities using PostgreSQL development languages. Pl/R lets you leverage the power of the R statistics framework to do advanced analysis of your spatial data Pl/Py put all Python modules at your disposal, with unlimited power for data processing, communication and interaction with external systems All these tools, usually less known than PostgreSQL and PostGIS bulk features, further improve the data platform, with high connectivity and interoperability, and almost unlimited features in terms of data processing. PostgreSQL, PostGIS, and -free- batteries included !
Computer animation
Computer animation
Computer animation