---------- Forwarded message ---------- From: Fabrízio de Royes Mello <[email protected]> Date: 2015-09-21 23:18 GMT-03:00 Subject: [pgbr-geral] PGBR2015 - Inscrições Abertas To: Comunidade PostgreSQL Brasileira <[email protected]>
Boa noite, Estão abertas oficialmente as inscrições para o PGBR2015 [1]. É importante salientar que essa ano, além das tradicionais palestras e lightning talks, teremos duas atividades extras (aka Tutoriais): TUTORIAL 1: - Título: Construção de banco de dados espaciais com PostGIS - Instrutor: Luis Fernando Bueno - Idioma: Português - Resumo: Neste tutorial os participantes aprenderão como utilizar a extensão PostGIS para criar banco de dados espaciais no PostgreSQL. Serão demonstrados os comandos que permitem converter dados espaciais para tabelas do PostgreSQL. Também serão abordadas diversas funções de manipulações de dados espaciais e uma introdução à Análise Espacial no ambiente do PostgreSQL. A integração do PostGIS/PostgreSQL com software de Sistema de Informação Geográfica será objeto de estudo neste tutorial, bem como o uso de ferramentas para divulgação de dados espaciais na Web. TUTORIAL 2: - Título: Author's introduction to Full-Text Search in PostgreSQL - Instrutor: Oleg Bartunov e Teodor Sigaev - Idioma: Inglês - Resumo: Full-Text Search ( FTS ) is a search for the documents, which satisfy query and, optionally, return them in some order. Most usual case is to find documents containing all query terms and return them in order of their similarity to the query. Notions of query and similarity are very flexible and depend on specific applications. There is a widespread opinion, that built-in full-text search facility in databases is not important, since there are many off-database solutions like Solr, Sphinx or Elastic Search, which are fast and easy managed. Think about document as a result of multi-tables join restricted by arbitrary filters and it will be clear, that it’s impossible to index such “collection” using off-database engines. Moreover, sometimes it’s important to find a document immediately after uploading it into database. That's why, many databases have built-in full text search engines, which allow to combine text searching and additional metadata, stored in various tables and available through powerful and standard SQL language. We will explain what is a full-text search in database and when it’s necessary to use. We review other text search options available in PostgreSQL and introduce FTS we developed for PostgreSQL. FTS in PostgreSQL was designed to be fully configurable using SQL commands, which allows to develop very sophisticated search engines. We’ll show how to create custom parsers, dictionaries and examples of different FTS configurations. We also will explain the extendability infrastructure in PostgreSQL, what are the GiST and GIN indexing frameworks and how they can be used to speedup full-text search queries. Also, we will talk about a future of FTS in PostgreSQL and our roadmap. --------------- As inscrições com pacote completo, ou seja, dois tutoriais no dia 18/11 e palestras dias 19/11 e 20/11 tem 20% de desconto. Fiquem ligados em nossos canais [2] [3] [4] para novidades. A hashtag oficial do evento será #pgbr2015. Att, [1] http://pgbr.postgresql.org.br/2015/#registration [2] http://pgbr.postgresql.org.br/2015 [3] https://www.facebook.com/pgbr2015 [4] https://twitter.com/postgresqlbr -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
