Skip site navigation (1) Skip section navigation (2)

Meeting: 6/19/08, The Relational Model with Jeff Davis

From: "Selena Deckelmann" <selenamarie(at)gmail(dot)com>
To: "Postgresql PDX_Users" <pdxpug(at)postgresql(dot)org>
Subject: Meeting: 6/19/08, The Relational Model with Jeff Davis
Date: 2008-05-29 16:15:37
Message-ID: 2b5e566d0805290915w1a194cddp2e6e387d8c1ad35f@mail.gmail.com (view raw or flat)
Thread:
Lists: pdxpug
Topic:   The Relational Model
Who:      Jeff Davis
Date:     6/19/08, 7pm
Where:   FreeGeek, 1731 SE 10th Ave, Portland, OR

Come to our next PostgreSQL Users Group meeting where Jeff Davis will
discuss the finer points of the Relational Model, otherwise known as
the model upon which all major SQL databases systems like Oracle,
MySQL and PostgreSQL are based.

He's fresh off giving a talk about this at PgCon, where it was very
well received!

Here's his abstract from that talk:

"This talk focuses on two common data management tasks, and how the
relational model can help. First, how to answer complex questions
about your data, and provide an answer that can be understood by
non-IT people unambiguously. Second, how to effectively extract
meaning from disorganized (or under-documented) data sets for
effective data migration or reporting.

The relational model, on which all SQL DBMSs are based, is founded on
both logic and sets. Relational operators like JOIN and UNION have a
direct logical meaning, and you can use those operators to answer
complex questions from your data unambiguously. Not only can you
provide unambiguous answers, but you can translate SQL queries into
the language of logic, which can be understood by people outside of
IT.

Equally important is the utility of logic working backwards to help
find meaning in disorganized (or perhaps undocumented) data sets.
Nearly every inherited data set is less than perfectly documented, and
often inconsistent. Changes to (or replacement of) the application
require this data to be migrated. By iteratively making assertions and
then testing them using the rules of logic and the convenience of
sets, you can find exceptions and contradictions that help you refine
the meaning of data, and possibly correct inconsistencies."

Jeff - feel free to chime in if you were planning to talk about
something else :)

After the meeting, refreshments at the Lucky Lab!

-selena




-- 
Selena Deckelmann
United States PostgreSQL Association - http://www.postgresql.us
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily

pdxpug by date

Next:From: Selena DeckelmannDate: 2008-06-02 02:17:12
Subject: Call for proposalsfor PDXPUG PgDay: due June 20, 2008
Previous:From: Selena DeckelmannDate: 2008-05-23 19:40:05
Subject: Fwd: [pdxfunc] Matthias Felleisen talk on computer science education, at PSU

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group