libreplanet-br-sp
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[lp-br-sp] Fwd: [pgbr-geral] PGBR2015 - Inscrições Abertas


From: Albino B Neto
Subject: [lp-br-sp] Fwd: [pgbr-geral] PGBR2015 - Inscrições Abertas
Date: Tue, 22 Sep 2015 15:17:34 -0300

---------- Forwarded message ----------
From: Fabrízio de Royes Mello <address@hidden>
Date: 2015-09-21 23:18 GMT-03:00
Subject: [pgbr-geral] PGBR2015 - Inscrições Abertas
To: Comunidade PostgreSQL Brasileira <address@hidden>


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
address@hidden
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral



reply via email to

[Prev in Thread] Current Thread [Next in Thread]