DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Data modeling

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    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.
    Last edited by Lily_Liu_2004; 05-26-2004 at 04:18 PM.

  2. #2
    Join Date
    Feb 2004
    Posts
    35
    1) Handboof of Relational Database Design: Flemming and Von Halle
    2) Data Modeling Essentials : Simsion

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    "Data Model Patterns: Conventions of Thought" by David C. Hay, Richard Barker
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    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
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width