BotecoNet Internacional para Administradores PostgreSQL
BotecoNet Internacional para Administradores PostgreSQL
Quando: 22 de outubro de 2009.
Horário: 19h00 às 20h30
Onde: presencialmente na sede da 4Linux ou pela internet ao vivo.
Conheça os treinamentos de PostgreSQL oferecidos pela 4Linux!
Participantes e temáticas:
Bruce Momjian: Security on PostgreSQL
"Securing PostgreSQL From External Attack" -- This 30-minute talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even ntercept database sessions and return false data. Postgres supports features o eliminate all of these threats, but administrators must understand the attach vulnerabilities to protect against them. This talk covers all known Postgres external attack vectors.
Magnus Hagander: Hidden gems of PostgreSQL
Hidden gems of PostgreSQL-This talk will introduce some not so well-known features in PostgreSQL, either in the core product or in add-on modules, that can make the developers or DBAs life a lot easier.
PostgreSQL is filled with advanced functions that sometimes go way beyond what other databases provide. Some of this is provided in the database, and some is provided as addon modules either in the contrib area of the system, or as completely standalone projects on pgfoundry or elsewhere. This talk will introduce a mix of suck features, in all areas of the database - from administration task to security and encryption.
Flavio Gurgel; "Turbinando seu Data Warehouse com PostgreSQL - Particionamento de tabelas"
"Turbinando seu Data Warehouse com PostgreSQL - Particionamento de tabelas"
Em bancos de dados que armazenam informações utilizadas em relatórios extratificados, quando as tabelas tem milhões de registros e apenas uma fração deles é utilizada por vez, o particionamento de tabelas pode agilizar não somente a geração de relatórios, mas também pode otimizar a carga de dados e a manutenção rotineira. Nesta apresentação será mostrado como planejar uma boa estratégia de particionamento, os cuidados a serem tomados, os ganhos e também os problemas e impedimentos inerentes à técnica.
Data: 22/10/2009 - 19:00 até 20:30
Local: 4Linux, Rua Teixeira da Silva, 660, São Paulo, SP
Palestrantes
Flávio Gurgel
Flávio Gurgel Engenheiro Eletricista pela Universidade Federal do Paraná, entusiasta do Software Livre e Linux desde 1999. Já atuou na migração de escritórios para o Linux e no reaproveitamento de hardware através do LTSP - Linux Terminal Server Project. Especialista em bancos de dados desde 1995, trabalha com PostgreSQL e MySQL, presta consultoria, suporte e treinamento aos clientes da 4Linux. Também desenvolve aplicações em PHP e conhece Assembler de alguns microprocessadores.
Magnus Hagander
Magnus Hagander is a developer and a committer in the PostgreSQL Global Development Group.
Magnus developed and maintains the Windows port as part of an international team within the PostgreSQL Global Development group. He also works on other parts of the PostgreSQL backend, most recently authentication, SSL and Kerberos-related features.
He contributes to pgAdmin, the postgresql.org website and related infrastructure. He's been a PostgreSQL user since version 6.3. He currently serves as President of the Board for PostgreSQL Europe.
During paid daytime, he is a PostgreSQL and open source software consultant, and provides support and training through Redpill Linpro in Stockholm, Sweden.
Bruce Momjian
Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB. Previously, he was employed by SRA Japan and Great Bridge LLC, both PostgreSQL support companies. He has spoken at many international open-source conferences. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world's largest law firms. Prior to this, he was a high school computer science teacher and holds a Masters in Education.