how does dimensional modelling used by datawarehousing fit into relational theory?
From: Daniel Hanks [EMAIL PROTECTED]
Date: 2003/11/19 Wed PM 04:35:03 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make
I have not read through the entire thing but from what I have seen so far, I
like Data Modeling for Everyone by Sharon Allen (CurlingStome Publishing)
ISBN 1904347002.
It covers the theory to the implementation (Logical - Physical
transformation).
From: [EMAIL PROTECTED]
Reply-To: [EMAIL
Unfortunately according to Amazon.com this book is out of print.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 8:40 AM
Data Modeling Essentials by Graeme C Simsion is a very good book.
American
there are used copies for sale right on there.
From: KENNETH JANUSZ [EMAIL PROTECTED]
Date: 2003/11/20 Thu AM 11:20:15 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any articles/books that take relational theory and make it
Unfortunately according
Hear, hear!
pb
--- Michael Milligan [EMAIL PROTECTED] wrote:
As Date is want to say, Theory is practical! (Chapter One,
Relational
Database Writings 1991-1994).
IMHO, a lack of understanding of relational database theory leads
directly
to database designs so flawed that they can't
Why in an IT shop - do us DBA's only seem to understand this? As I see it most
programmers don't understanding data models at all! It makes it easier for them to
ignore the DBA's as being theoretical, academic
-Original Message-
Sent: Thursday, November 20, 2003 1:30 PM
To:
:35:03 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make it
Agreed. And I think you'll admit it's better to be familiar with and aware of the
theory, even if current db products don't live up to the model
Paula - It may get worse. A noted O-O author said a database is just a
means to persist an object. I also see a lot of young developers that
haven't taken much Computer Science, so haven't been exposed to underlying
theories like relational modeling. Well, we DBAs just have to be lights
shining
which noted O-O author said that about DBs?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 02:59:58 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make it
Paula - It may get worse. A noted O
Title: RE: Any articles/books that take relational theory and make it english?
Ryan,
I often recommend Database Design for Mere Mortals by Michael J. Hernandez for my students, new database developers, and especially for programmers that I work with. It's a step above something like
Data Modeling Essentials by Graeme C Simsion is a very good book.
American Express made the following
annotations on 11/19/2003 07:36:46 AM
--
On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote:
I swapped emails with a member of the list and Im having trouble seeing how you can
take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that
BCNF essentially means you have a key that you can put a unique constraint on.
Ryan:
I think the presentation on data modeling may help you understand and
explain thoroughly to your team. If not, I would obtain a copy of Robert
Barker's CASE*METHOD - Entity Relationship Diagramming book. The Data
Modeling Essentials book is very technical and often hard to follow for
To me, CJ Date is the one who makes it crystal clear. Not in his main book,
but in his Relational Database Readings books, which I have most of.
I have also seen some good articles by Fabian Pascal.
I also have a new book called Data Modeling for Everyone by Sharon Allen,
published by
recipients of list ORACLE-L
Subject: Re: Any articles/books that take relational theory
and make it
On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote:
I swapped emails with a member of the list and Im having trouble
seeing how you can take 3NF, BCNF, etc... and turn that into DBA
speak. One
] [mailto:[EMAIL PROTECTED] On
Behalf Of Daniel Hanks
Sent: 19 November 2003 16:25
To: Multiple recipients of list ORACLE-L
Subject: Re: Any articles/books that take relational theory
and make it
On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote:
I swapped emails with a member
As Date is want to say, Theory is practical! (Chapter One, Relational
Database Writings 1991-1994).
IMHO, a lack of understanding of relational database theory leads directly
to database designs so flawed that they can't possibly allow their
application to accomplish their goals. If you don't
17 matches
Mail list logo
