É com orgulho que a Comunidade SQLPort anuncia que este ano, no dia anterior ao já anunciado SQLSaturday, vamos realizar um Workshop de dia inteiro com um conhecido especialista holandês - Hugo Kornelis. O tema do Workshop será "An effective (though uncommon) approach to database design" e vai se centrar-se ao tema de desenho de base de dados, tópico de interesse e utilidade fundamental a Programadores e Arquitectos de Software.

Pela primeira vez vamos ter um especialista internacional que vai dar um workshop de dia inteiro; para financiar os custos de trazer Hugo a Portugal, vamos pedir uma pequena taxa de inscrição. Todo o dinheiro que restar após o pagamento das despesas vai ser será partilhado entre o Hugo Kornelis e a PASS.

Neste preciso momento, o local exacto do Workshop encontra-se em definição (vai depender de número de pessoas inscritas), e será anunciado em breve. O Workshop terá início as 09:30 e será realizado durante o dia inteiro (Sexta-Feira, 16 de Março) com o fim previsto às 17:30.

Content (4 Blocks):

Basics:
Physical, logical, and conceptual model:
 -Universe of Discourse (UoD)
 -Principles of modeling
Initial model:
 -Verbalization
 -Diagramming

Constraints
How to test:
 -Types of constraints
 -Uniqueness
 -Mandatory Role
 -Subset, Equality, Exclusion
 -Frequency, Value
 -Other constraints

Transformations
Subtype analysis:
 -Fact type / Entity type transformation
 -Nominalisation / denominalisation

Relational model
Logical model:
 -Grouping
 -Lexicalizing
 -Transforming to relational model
Physical model:
 -Optimizations to consider

Preços:

Até final de Fevereiro (Early Bird):
Para membros da SQLPort: 50€
Público em geral: 75€
 
Em Março:
Para membros da SQLPort: 75€
Público em geral: 100€

Top 30 membros do ano 2011: 50€ (em qualquer período)

Para efectuar reserva por favor use o seguinte endereço de contacto: workshops@sqlport.com.

Sobre Hugo Kornelis:

Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server.

In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences.

Sobre a sessão:

In database design a lot of effort is spent on ensuring that database designs are perfectly normalized and slated for great performance. But there is one aspect that, though even more important, tends to get a lot less attention: correctness. If a database is completely normalized and performs brilliantly, but won't store the data that the business needs, or allows modification that should be rejected as violating business rules - what use is it?

In this precon, Hugo Kornelis presents a method that enables the database designer to find out exactly what the business needs are. Common pitfalls, such as miscommunications due to abstraction and jargon are avoided because the method relies completely on using concrete examples in the jargon of the business. The method presented tells you exactly what questions to ask, how to ask them, and how the answers to your question should be incorporated in your data model.

At the end of this day, you'll be able to make a conceptual data model for every application, and to transform that data model into a (completely normalized) logical database design.