| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Modeling
Jeff,
Thanks for the reference. Reader comments on the book were very positive.
One more question to you, Jared, and the list is does anyone have any suggestions for books that contain libraries of designs? That is what I was getting at when asking about that other book. I wouldn't mind having 3 or 4 books that contain numerous good design examples for common "things".
I will start off with the David Hay book and the book you recommended. I think it would be nice to have some good reference material with great examples and "template" designs for those types of things I've never had to model. Something to give a little jump start to the design process.
Regards,
L. Elkins
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jeff Cox
Sent: Friday, August 25, 2000 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Modeling
The David Hay book is wonderful, and another one that is definitely worth the price is "Data Modeling Essentials" by Graeme C. Simsion.
Jeff Cox
Scottsdale, AZ
1-800-321-6899 ext. 3370
-----Original Message-----
From: Larry G. Elkins [SMTP:elkinsl_at_flash.net] Sent: Thursday, August 24, 2000 5:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Data Modeling
Jared,
In addition to the David Hay book, do you, or any of the listers, have any thoughts on the following book?
The Data Model Resource Book : A Library of Logical Data and Data Warehouse
Designs
by Len Silverston, Kent Graziano, William H. Inmon
I've got some Kimball and some Inmon books addressing DW's; but, the book above sounded interesting. Most, but not all, of the reviewers at the Amazon site spoke favorably of the book.
Regards,
L. Elkins
-----Original Message-----
Sent: Thursday, August 24, 2000 10:39 AM
To: Burton, Laura L.
Cc: 'oracledba_at_quickdoc.co.uk'
Laura,
When data modeling, it is too early to talk about tables.
Rather, you should be talking about entities and attributes.
You don't really need an employee entity, as an employee is just a person, as is a witness.
There are a number of good books on data modeling. A search on Amazon should find David Hay's excellent book, as well as others.
Here's one simple possibility.
| |
| ACCIDENT |
| WITNESSES |
| |
--------------
\|/ \|/
| |
| |
| |
| |
------------ ------------
| | | |
| ACCIDENT | | PERSON |
| | | |
| | | |
Jared
-- Author: Larry G. Elkins INET: elkinsl_at_flash.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Jeff Cox INET: jeff.cox_at_ips-sendero.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Fri Aug 25 2000 - 18:36:54 CDT
 |
 |