We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

PostgreSQL, batteries included

Formale Metadaten

Titel
PostgreSQL, batteries included
Serientitel
Anzahl der Teile
183
Autor
Lizenz
CC-Namensnennung - keine kommerzielle Nutzung - Weitergabe unter gleichen Bedingungen 3.0 Deutschland:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen und nicht-kommerziellen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen und das Werk bzw. diesen Inhalt auch in veränderter Form nur unter den Bedingungen dieser Lizenz weitergeben.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache
Produzent
Produktionsjahr2015
ProduktionsortSeoul, South Korea

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
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 !