If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > level of data model

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-22-10, 12:39
collinm collinm is offline
Registered User
 
Join Date: Nov 2009
Posts: 5
level of data model

hi

there are the cdm, ldm and pdm

some software allow to generate theses three type of model some other not

i don't see the utility of cdm

when i check this web page

Conceptual, Logical, and Physical Data Models

if find useless the cdm

any comment?
why create a cdm when we use crow's foot, baker, ie... notation

i found usefull cdm for the merise method... but it's only used in france...

thanks
Reply With Quote
  #2 (permalink)  
Old 01-22-10, 14:00
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
I agree. Your logical model will include the conceptual model.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #3 (permalink)  
Old 01-22-10, 15:22
collinm collinm is offline
Registered User
 
Join Date: Nov 2009
Posts: 5
does somebody create cdm and ldm?
why?
Reply With Quote
  #4 (permalink)  
Old 01-22-10, 17:33
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
LDM yes. CDM no.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #5 (permalink)  
Old 01-22-10, 17:44
dportas dportas is offline
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 732
All depends on what modelling methods you use. The ORM "Rmap" approach for example derives the final database implementation directly from the conceptual model. So getting the conceptual model correct is the most critical aspect of the design process.
Object Role Modeling

ER diagrams are very limited in the range of relationships, constraints and other options that can be properly expressed. Typically an ER diagram doesn't capture enough information to allow for complex data modelling as well as an effective implementation of that model. That's why it's common to take a staged approach, where the model is progresively refined and adjusted, beginning with a Description of what's being modelled and ending with a Design of a database.

Many software development projects today also use Agile methods. In that case I find it useful to create smaller, subject-area models that are shared with the team in each sprint / iteration and that will probably be much closer to what is actually implemented rather than what is conceptually being represented - i.e. model as Design rather than Description.
Reply With Quote
  #6 (permalink)  
Old 01-24-10, 06:05
andrewst andrewst is offline
Moderator.
 
Join Date: Sep 2002
Location: UK
Posts: 5,171
Without it being a formal process, I would say that I do tend to start with a CDM, i.e. an ERD without the attributes filled in, as a way of understanding the broad data requirements. I don't call it a CDM though, if pushed I'd probably have just called it a sketchy, overview LDM.
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On