Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mythili
Starting Member
3 Posts |
 Posted - 2007-07-26 : 11:25:06
|
| Dear Gurus,Anybody dont mine, please tell me what is logical data modeling and physical data modeling?Please forgive me if am posted anything wrongMythili |
|
|
sqldba2k6
Posting Yak Master
176 Posts |
Posted - 2007-07-26 : 14:27:13
|
| Logical data models (LDMs). LDMs are used to explore the domain concepts, and their relationships, of your problem domain. This could be done for the scope of a single project or for your entire enterprise. LDMs depict the logical entity types, typically referred to simply as entity types, the data attributes describing those entities, and the relationships between the entities. Physical data models (PDMs). PDMs are used to design the internal schema of a database, depicting the data tables, the data columns of those tables, and the relationships between the tables. The focus of this article is on physical modeling. Check the below link for detailed explaination..http://www.agiledata.org/essays/dataModeling101.html |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-26 : 16:25:29
|
for some reason i like LEGO analogies lately  Logical data modeling: Thinking of a concept of a thing you'll build in your mindPhysical data modeling: Acctually building the thing from toys_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Logical Data modelling