-
Data modeling
Maybe this topic is not directly related to oracle dba.
But I think a dba should master some basic data modeling skills.
There are a lot of experienced dbas in this forum.
Would you please refer some good websites or articles or books
about data modeling?
Thanks in advance.
-
1) Handboof of Relational Database Design: Flemming and Von Halle
2) Data Modeling Essentials : Simsion
-
"Data Model Patterns: Conventions of Thought" by David C. Hay, Richard Barker
-
I agree %100, we are in the process of rolling out a new app and I have been in a few functional design meeting. Although in my shop (which is a huge outfit) we have DA's that do the moddeling, it is interesting to see the whole flow from user request to front end to data model.
We should also add that the applications (AKA DEVELOPERS )
should learn a thing or two about data models. Coding for the front end and collapsing models for coding simplicity are the most popular reasons for bad performance. Developers should learn that a data model and RDBMS work well together.
"Yes we need code/decode table!"
"Yes you will have to code joins!"
"No we will not creat one huge table for coding simplicity!!"
Raise your hand if you do not have any flat tables in your system.
MH